cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with Db2 database disconnectivity

Maladri1
Newcomer
0 Kudos
84

HI All,

Our PRD db2 database is getting down for twice a week.

please suggest the solution for it.

please find the below details for your reference.

*** ERROR in DB6Connect[dbdb6.c, 2009] CON = 0 CACHEID = -1 (BEGIN)
C &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication
C &+ protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "
C &+ ". Communication function detecting the error: "connect". Protocol specific error code(s): "79", "*", "
C &+ *". SQLSTATE=08001
C &+
C &+
C *** ERROR in DB6Connect[dbdb6.c, 2009] (END)
C *** ERROR => DbSlConnect to 'PRD' as 'sapprd' failed
[dbdb6.c 2016]
B dbcon[exec_reconnect]: reconnect failed for connection 0, rc=3
B 01: name=R/3*INACT_PACK, con_id=000000014, state=DISCONNECTED, tx=NO , bc=NO , hc=NO , perm=NO , reco=NO , isol=DEF,
B info=NO , timeout=000, con_max=255, con_opt=255, occ=NO , prog=SAPLPA_PACKAGE_SERVICES
B dbcon[db_con_reconnect]: } rc=3
B dblink[db_reconnect]: { new_reconnect_message=0
B dbcon[db_con_reconnect]: { reco_trials=3, reco_sleep_time=5
B 00: name=R/3, con_id=000000000, state=DISCONNECTED, tx=NO , bc=NO , hc=NO , perm=YES, reco=YES, isol=DEF,
B info=NO , timeout=000, con_max=255, con_opt=255, occ=NO , prog=
B dbcon[exec_reconnect]: connection=0
B dbcon[exec_reconnect]: opening connection 0 ...
C *** ERROR in DB6Connect[dbdb6.c, 2009] CON = 0 CACHEID = -1 (BEGIN)
C &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication
C &+ protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "
C &+ 10.0.0.27". Communication function detecting the error: "connect". Protocol specific error code(s): "79", "*", "
C &+ *". SQLSTATE=08001
C &+
C &+
C *** ERROR in DB6Connect[dbdb6.c, 2009] (END)
C *** ERROR => DbSlConnect to 'PRD' as 'sapprd' failed
[dbdb6.c 2016]
B dbcon[exec_reconnect]: disconnecting from connection 0 ...
C *** ERROR in DbSlDisconnectDB6[dbsldb6.c, 1567] CON = 0 CACHEID = -1 (BEGIN)
C &+ DbSlDisconnectDB6: connection 0 does not exist

Please find me on this?

Thanks 

SWF_Fields

Accepted Solutions (0)

Answers (0)