473,551 Members | 2,722 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Connecting to Server Problem

Hi Guys

I have Db2 server installed on remote server. i am connecting to that
remote server by using VPN.

I want to connect that remote DB2 server instance using my local
machine DB2 development client. Bur Its gives me following error
message. I searched lots of things on net and tried on remote server
but i didnt got suceess. Can any one tell me how to set TCP\IP
connection protocol on server for particular instance. Becuase I think
While creating db2 instance they didnt specified TCP\IP connection
protocol and TCP\IP service name. So please explain me how I can set
set TCP\Ip connection protocol along with setting service on particular
TCP port.

Error Message:

SQL30081N A communication error has been detected. Communication
protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected: "10.5.4.3".
Communication function detecting the error: "connect". Protocol
specific error code(s): "10061", "*", "*". SQLSTATE=08001

Explanation:

An error has been detected by the communication subsystem.

If the connection has already been established, possible causes
include the following:

o A communication subsystem error at the client node or server
node has caused the connection to go down.

o If a SOCKS server is being used, a communications subsystem
error on the SOCKS server has caused the connection to go
down.

o A network error has caused the connection to go down.

o The database agent at the server was forced off by the system
administrator.

o The database agent at the server was terminated due to an
abnormal termination of a key database manager process.

If you are trying to establish a new connection, possible causes
include the following:

o The remote database server has not been cataloged correctly
at the client.

o The database manager configuration file at the server has not
been configured with the proper communication parameters.

o The communication subsystem at the client node or server node
has not been configured correctly, or has not been started
successfully.

o The communication subsystem at the SOCKS server, if one is
being used, has not been configured correctly, or has not
been started successfully.

o The DB2COMM environment variable at the server doesn't
specify the communication protocol used by the client.

o The database manager at the server has not been started, or
has not been started successfully. One or more of the
communication protocols specified by DB2COMM may not have
been successfully started.

Refer to the token values for details. Depending on the
protocol being used and the communication function invoked, some
tokens may not be applicable. The following is the explanation
of the token values:
<protocol> The actual communication protocol being used. Valid
token values are:

o TCP/IP

o APPC

o NETBIOS

o IPX/SPX

<interface> The application programming interface used to invoke
the above communication protocol services. Valid token values
are:

o SOCKETS

o SOCKS

o CPI-C

o DLR or DD

o TLI or Connection/Bindery

o SOAP

o MQI-CLIENT

<location> This is a protocol specific ID which uniquely
identifies the node that detected the error. If the protocol
being used is:

o TCP/IP

The format of the ID is the Internet address in dot
notation.

o APPC

The format of the ID is the fully qualified LU name
(networkID.LUna me).

o NETBIOS

The format of the ID is the Workstation name (nname).

o IPX/SPX

The format of the ID is the network address and node address
in hexadecimal notation (network.node).

o MQ

The format of the ID is the MQ queue name.

o SOAP

The format of the ID is the Internet address in dot
notation.

If the location information is not available at the time that
the error occurred, this token is not filled in.

<function> The name of the communication subsystem function that
returned the error code(s).

<rc1>, <rc2>, <rc3> The list of the available error codes and
subcodes that are specific to each protocol being used. Tokens
that are not applicable contain "*".

If the protocol being used is:

o TCP/IP

- If <rc1> is present and contains the global errno value from
the TCP/IP sockets function call. When using Windows Sockets,

if present, <rc1> contains the error from the TCP/IP
sockets function call returned by WSAGetLastError ().

- If <rc2> is present and contains the global h_errno value
from the TCP/IP name resolution function call. When using
Windows Sockets, if present, <rc2> contains the error
from the TCP/IP database function call returned by
WSAGetLastError ().

- If <rc3> is present and contains "0", it means that the
TCP/IP connection has been closed. This could be caused by one

of the following:

- The database agent at the server was forced off by the
system
administrator.

- A database agent could not be started at the server because

the maxagents database manager configuration
parameter has been exceeded. Check the administration
notification log to see if an error message has been
logged.

- The connection may have been closed by the remote server at

the TCP/IP level.

- The database agent at the server was terminated due to an

abnormal termination of a key database manager
process.

Note: When using Windows Sockets, if the <function> is
WSAStartup, and <rc1> is 0, then <rc2> contains the
Windows Sockets Specification version level requested by
DB2, and <rc3> contains the Windows Sockets
Specification version level supported by the Windows
Sockets DLL.

o APPC

<rc1> contains the return code from the CPI-C function. If
present, <rc2> contains the global errno value from the
CPI-C function call. <rc3> is not applicable.

o NETBIOS

<rc1> contains the return code from the call to NetBIOS.
<rc2> and <rc3> are not applicable.

o IPX/SPX

<rc1> contains the global t_errno value from the call to
TLI Services, or the return code from the call to NetWare

Connection or Bindery Services. If the <rc1> t_errno is
TLOOK, <rc2> contains the TLI event that has occurred. If
the <rc2> event is T_DISCONNECT, <rc3> contains the
disconnect reason code. On AIX, if the <rc1> t_errno is
TSYSERR, <rc3> contains the system errno (defined in
sys/errno.h). If <rc1> contains the error return code from a
call to AIX NetWare Connection or Bindery Services, <rc2>
contains the error generator.

o MQ

<rc1>contains the function completion code, 1 for a warning
and 2 for an error. <rc2> contains the MQ-specific error
code. <rc3> is not used for MQ.

o SOAP

<rc1> contains the return code from the SOAP communication
function. The <rc2> depends upon the value of <rc3>.
<rc2> is either:

- The TCP/IP sockect error errorno value in UNIX,
WSAGetLastError for Windows operating systems.

- A Secure Socke Layer (SSL) return code from the Global
Security Kit (GSK).

The <rc3> value "0" indicates that this is a high-level
SOAP error (not a socket or GSKit error). the <rc3> value
"1" indicates that this was a socket error. the
<rc3> value "2" indicates that this was a GSKit
error.

See the Communications Errors appendix of the Message Reference
for more information on specific communication error codes.

User Response:

If the connection has already been established, check if:

1. The database agent at the server has been forced off.

2. The database manager at the server has abnormally
terminated.

3. A communication subsystem or network error has occurred. See
the Message Reference for more information on specific
communication error codes.

If you are trying to establish a new connection, check if:

1. The remote database server is cataloged properly on the
client node.

2. The database manager configuration file at the server is
configured with the proper communication related parameters.
If the database manager configuration parameters have been
updated at the server, ensure that you stop and then re-start
the database manager, for the changes to take effect.

3. The communication subsystems on both client and server nodes
are configured and started up properly.

4. The DB2COMM environment variable at the server specifies the
communication protocol used by the client.

5. The database manager at the server is successfully started.
Start database manager processing at the server should have
returned SQL1063, and not SQL5043. If SQL5043 is returned,
check the administration notification log for more
information.

6. A communication subsystem or network error has occurred.

If the problem persists, consult with your network administrator
and/or communication expert to determine the cause of the problem
using the set of tokens provided.

sqlcode : -30081

sqlstate : 08001

Thanks
Suresh

Jun 7 '06 #1
0 3909

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3624
by: Google Mike | last post by:
After a lot of thought and research, and playing with FreeTDS and InlineTDS, as well as various ODBC connections, I have determined that the fastest and cheapest way to get up and going with PHP on Linux, connecting to MS SQL Server, unless it was already pre-installed by your Linux installation, is to build your own multithreaded TCP socket...
4
5483
by: John Morgan | last post by:
I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP applied some sort of extra security arrangements to their SQL Server to allow access only through port 1433. they have told me to configure an alias...
12
2760
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed both the iis and sql server in a single machine. Not too long ago, the machine had some hardware problems, and management has decided to purchase new...
0
2014
by: cj.snead | last post by:
Hello, I am having trouble connecting to a remote named instance of SQL Server via Pocket PC. I have had absolutely no luck connecting with VS 2005 (even to a default instance), so I wen't back to VS .NET 2003 (I had success doing this a while back). I am trying to connect to a named instance of SQL. This is where I think my problem is. ...
3
2005
by: Vinod R.Shenoy | last post by:
Hi All, Came across a post wherin you had helped somebody with a similar problem and was wondering if you could help us out with it. Our problem is , We have a development SQL Server 2000 (running on Win2K SP4) machine that we want to run on a Windows 2003 server machine and access it via our internal LAN. We have opened the firewall...
6
7762
by: Todd Brewer | last post by:
Windows Server 2000 ASP.NET 2.0 SQL Server 2000 (on a physically seperate server) I moved an ASP.NET 2.0 application from a development server to production, and am getting the following error: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005,...
9
4286
by: darthghandi | last post by:
I am trying to create a server application using asynchronous sockets. I run into a problem when I try to connect to my server using a non-.net program. I can establish the connection, and send some packets in response to the programs first message, but when I receive a response back, it's the last packet I sent. After that packet, I...
2
4945
by: samadams_2006 | last post by:
Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express Edition" via the link on: http://msdn2.microsoft.com/en-us/express/bb410792.aspx
2
3023
by: orandov | last post by:
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error:
0
7565
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7492
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8002
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7522
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7847
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
3520
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1981
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1097
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
804
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.