CLI Driver error in the job....

pavans · Post by **pavans** » Sat Feb 09, 2008 5:19 am

Hi
I am getting the below error.

DB2EffPrcc,0: Fatal Error: Fatal: [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
[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
SQLFetch: Error retrieving results from server.

Thanks in advance.

ArndW · Post by **ArndW** » Sat Feb 09, 2008 5:22 am

Can you do a "DB2 connect" from a command line to this instance? Is this a new error or a new installation?

pavans · Post by **pavans** » Sat Feb 09, 2008 5:29 am

ArndW wrote:Can you do a "DB2 connect" from a command line to this instance? Is this a new error or a new installation? ...

I checked the DB2 instance and its connecting.
Any workaround to solve this issue.

ArndW · Post by **ArndW** » Sat Feb 09, 2008 5:31 am

No workaround since the issue's cause hasn't been identified. What about the answers to the second question - is this a new problem or did it work before? Does it affect just this job/table/database?

pavans · Post by **pavans** » Sat Feb 09, 2008 5:36 am

ArndW wrote:No workaround since the issue's cause hasn't been identified. What about the answers to the second question - is this a new problem or did it work before? Does it affect just this job/table/database? ...

This is a new problem.
There is a sequence with 7 jobs in it.
l1,l2,l3,l4,l5,l6,l7.
The job l4 is aborting with the above error. Once l4 runs then the next job is triggered.

ArndW · Post by **ArndW** » Sat Feb 09, 2008 5:58 am

Do you have any jobs that can read from or write to DB2 that are working? If yes, do you have any jobs that can read from or write to this particular table with this particulare userid that are working?