DSXchange

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.

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

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.