DB2 Connection time out

rggoud · Post by **rggoud** » Wed Apr 13, 2005 3:38 pm

Hi,

I'm getting the following error in one of the jobs connecting to Mainframe Db2 database.

[IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032

This job has 6 lookup stages querying the DB2 database ( some are complex queries / some are simple) . Lookup happens at db2 and updates happens at Oracle. I will appreciate your views on how to avoid this error ?

Thanks.

legendkiller · Post by **legendkiller** » Thu Apr 14, 2005 5:45 am

I guess this is problem on source database and not with datastage

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Apr 14, 2005 8:15 am

This occurs in db2 when it has memory and heap size problems. Ask you DBA for it.

I believe your job will work with less number of db2 connections. So alternatively look for splitting the load into smaller jobs.