Page 1 of 1

Deadlock and 0c7

PostPosted: Wed Jun 23, 2010 12:52 pm
by bbu12345
Hi

I have a cics program which sometimes dumps with a 0c7 abend. But when I find the statement I am 99% certain that this statement could not cause a 0c7. The first time i saw this, there was actually a -911 message in the 0c7 dump. Other times the program displays the SQLSTATE as 40001, which is also a deadlock. The error always occurs when there are huge batchruns on tables that the program tries to access. SO im thinking that this is acctually a deadlock and not a 0c7/ASRA, but why would the program dump with the 0c7 instead of the deadlock (could be a timeout).

Re: Deadlock and 0c7

PostPosted: Wed Jun 23, 2010 11:47 pm
by dick scherrer
Hello and welcome to the forum,

What does the code do after the sql error is detected?

If it does anything with any numeric field and the field does not contain a valid value an 0c7 could happen.

Without seeing any detail, my guess is that possibly a host variable is being used, but the value was not retrieved.

But when I find the statement I am 99% certain that this statement could not cause a 0c7.
Then your understanding may need adjustment or the incorrect statement has been identified. . .