Application group wants batch job to terminate if it is unable to establish SQL session to external database.
Job log indicates MSGID QSQLMSG/SQ30080
"Communication error occurred during distributed database processing.
This appears in the joblog as a level 30 diagnostic message.
When this message is encountered we want the job to exceed end severity and terminate.
I have tried raising the severity code on the SQL message identifier and while it exceeds end severity for the job description attached to the active job the job does not end. i suspect this is happening because this the SQL message is received as a diagnostic not escape message.
How can I get the job to abend when this (or ther SQL specific message identifiers) are received in the active joblog?
April 23, 2010 6:31 PM
April 27, 2010 1:24 AM