DB2 Timeout

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

DB2 Timeout

Post by raji33 »

Hi,

I am getting the below error. Any idea what it might be?

[IIS-CONN-DB2-000004] DB2 function SQLEndTran(SQL_COMMIT) failed: SQLSTATE = 08007: Native Error Code = -30,081: Msg = [IBM][CLI Driver] 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.31.22.18". Communication function detecting the error: "recv". Protocol specific error code: "73", "*", "0". SQLSTATE=08001 (CC_DB2Connection::commit, file CC_DB2Connection.cpp, line 1,229)

[IIS-CONN-DB2-000004] DB2 function SQLEndTran(SQL_ROLLBACK) failed: SQLSTATE = 08003: Native Error Code = -99,999: Msg = [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003 (CC_DB2Connection::rollback, file CC_DB2Connection.cpp, line 1,251)


Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Network. Firewall. Etc etc. Noted here:

http://www.ibm.com/support/docview.wss?uid=swg21164785
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply