By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,501 Members | 1,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,501 IT Pros & Developers. It's quick & easy.

Urgent SQLCODE : 30081 Connection problem

P: n/a
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.LUname).
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 8 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
hi probably try to set the following in the server

db2set COMM=TCPIP
and again try to start the instance.
or check the entries in the /etc/services (if the box is UNIX platform)
file on both the machine the server and client.And if required updae
the DBM CGF to the corresponding port. Hope this will help.

Cheers,
lakshman


Suresh wrote:
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.LUname).
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 8 '06 #2

P: n/a
"Suresh" <su*******@indiatimes.com> wrote in message
news:11**********************@j55g2000cwa.googlegr oups.com...
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


Can you ping the server? If no, it is not a DB2 problem.

If yes you can ping the server, please post how you catalogued the remote
server from your client (catalog node and catalog db). Also, logon to the
DB2 server and do "db2 get dbm cfg" and post results here.
Jun 8 '06 #3

P: n/a
In article <11**********************@j55g2000cwa.googlegroups .com>,
la************@gmail.com says...
hi probably try to set the following in the server

db2set COMM=TCPIP


If still necessary, this should be: db2set DB2COMM=TCPIP
But please collect the items Mark asked for and post them here, that
would make it a lot easier to solve the problem.
Jun 8 '06 #4

P: n/a
Hi

DB2COMM =TCPIP is prenset in setting

plz help me to solve problem.....
db2 get dbm cfg settings

Database Manager Configuration

Node type = Database Server with local and remote clients

Database manager configuration release level = 0x0a00

CPU speed (millisec/instruction) (CPUSPEED) = 2.755342e-07

Max number of concurrently active databases (NUMDB) = 8
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =

Default charge-back account (DFT_ACCOUNT_STR) =

Java Development Kit installation path (JDK_PATH) =
/opt/IBMJava2-141

Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
/db2/db2inst1/sqllib/db2dump

Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON

SYSADM group name (SYSADM_GROUP) = DB2IADM1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =

Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) =
NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO

Default database path (DFTDBPATH) =
/db2/db2inst1

Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024

Sort heap threshold (4KB) (SHEAPTHRES) = 20000

Directory cache support (DIR_CACHE) = YES

Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000

Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 200
Agent pool size (NUM_POOLAGENTS) =
100(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) =
MAX_COORDAGENTS

Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0

Index re-creation time and redo index build (INDEXREC) = RESTART

Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180

SPM name (SPM_NAME) =
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =

TCP/IP Service name (SVCENAME) = db2inst1
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE

Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO

No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC

Gert van der Kooij wrote:
In article <11**********************@j55g2000cwa.googlegroups .com>,
la************@gmail.com says...
hi probably try to set the following in the server

db2set COMM=TCPIP


If still necessary, this should be: db2set DB2COMM=TCPIP
But please collect the items Mark asked for and post them here, that
would make it a lot easier to solve the problem.


Jun 8 '06 #5

P: n/a
"Suresh" <su*******@indiatimes.com> wrote in message
news:11**********************@f6g2000cwb.googlegro ups.com...
Hi

DB2COMM =TCPIP is prenset in setting

plz help me to solve problem.....
db2 get dbm cfg settings

Database Manager Configuration

Node type = Database Server with local and remote clients
TCP/IP Service name (SVCENAME) = db2inst1


The SVCENAME looks a little suspicious. Please go to /etc/services and post
the line for db2inst1 (should include a port number).

We also need you client configuration parms where you catalogued the db and
the node. From the client, do the following:

db2 list node directory
db2 list db directory
Jun 8 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.