MVSFORUMS.com

anandrk

Hello Everyone,

I have a doubt on DB2 batch program abends.

If a DB2 batch job abends due to SQL Code -805 or -818 for e.g, will it throw an User abend or System abend. Can anyone please tell what will be the abend code based on their real time experience ?

I am assuming that I have not written and SQL error handling routine in the Cobol program ?

I am sure Production Support guys will be able to answer this very well.

Thanks,
Anand

kolusu · Posted: Fri Jan 31, 2003 5:56 pm Post subject:

Anandrk,

Both -805 and -818 abends are raised even before the first statement in the program gets excueted. And it has got nothing to do with error handling routine in the cobol program.

Check this links for a detailed explanation of the errors -805 and -818.

-805 DBRM OR PACKAGE NAME NOT FOUND IN PLAN

-818 THE PRECOMPILER-GENERATED TIMESTAMP x IN THE LOAD MODULE IS DIFFERENT FROM THE BIND TIMESTAMP y BUILT FROM THE DBRM z

Hope this helps...

cheers

kolusu

vini · Posted: Wed Feb 25, 2004 4:23 pm Post subject:

coolman · Posted: Mon Jul 31, 2006 8:49 am Post subject:

Very rarely I have seen a -818 - A question that has been hovering on my mind for a while.

Is there a way that we can simulate an -818. It once happpened to me quite a while back and I can't remember how to simulate it - Here's my thought on the -805, I feel that once a job is compiled and bound atleast once, the next time someone recompiles the program and tries to run it, I feel it should give an -818 (because the location.collection.package would be there in the search order but only the ts would mismatch), however we get a -805

All thoughts are welcome on this
________
make a vaporizer