Deadlock and 0c7



Get solution for your ABEND Codes & System Error Messages, SQL Codes, File Status etc...

Deadlock and 0c7

Postby bbu12345 » Wed Jun 23, 2010 12:52 pm

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).
bbu12345
 
Posts: 1
Joined: Wed Jun 23, 2010 12:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Deadlock and 0c7

Postby dick scherrer » Wed Jun 23, 2010 11:47 pm

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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to ABENDS & SQL Codes

 


  • Related topics
    Replies
    Views
    Last post