DB2 Connector Stage

[praburaj]

Hi All,

My job is a simple direct load.

I am extracting the records from the source file and trying to load the data

into the db2 connector stage. But job got aborted due to below mentioned

error.

"The connector could not establish a connection to DB2 database TIS_STGD using user "Ax_etl."
"QLSTATE = 08001: Native Error Code = -1,224: Msg = [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032 (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line 807)"

I have checked with our DBA. He was able to insert to data manually into the table. But not able to insert the data when I am trying load from datastage.

I really don't know the issue. Any guideance is really appreciated

[chandra.shekhar@tcs.com]

This link may help.

http://publib.boulder.ibm.com/infocente ... 1224n.html