DataStage - Database Connectivity Issue
Moderators: chulett, rschirm, roy
DataStage - Database Connectivity Issue
We have a sequencer that triggers 35+ jobs in parallel which reads from multiple tables of single database (Same schema) and writes into dataset. Jobs are failing randomly due to the below errors. Change in the error is job name. Rest all same. Job completes successfully When we re-ran the failed job. Do we need to set any configuration setting
dbeR_RT_LI_SVFS_ASSOCIATE_src: The connector could not establish a connection to DB2 database XXXX using user username1.
dbeR_RT_LI_SVFS_ASSOCIATE_src: SQLConnect reported: SQLSTATE = 08001: 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.88.123.54". Communication function detecting the error: "connect". Protocol specific error code(s): "111", "*", "*". SQLSTATE=08001 (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line 840)
dbeR_RT_LI_SVFS_ASSOCIATE_src: The connector could not establish a connection to DB2 database XXXX using user username1.
dbeR_RT_LI_SVFS_ASSOCIATE_src: SQLConnect reported: SQLSTATE = 08001: 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.88.123.54". Communication function detecting the error: "connect". Protocol specific error code(s): "111", "*", "*". SQLSTATE=08001 (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line 840)
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI