DB2 Connector Stage
Posted: Mon Oct 22, 2012 11:22 pm
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
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