Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

0911N

Status
Not open for further replies.
stressman

stressman

Programmer
Jan 4, 2002
48
FR
hi all
i work with proC and DB2 v7.2.6
i need some help or information about the message 0911N timeout or deadlock
i'm nearly sure that the lock table gestion is good but sometimes i keep having this error that rollback all my information
is there a way to avoid it??

Thanks a lot for your precious help.
 
Sort by date Sort by votes
Stressman,

not sure about your environment. I can give a bit of guidance as to what happens on the mainframe and maybe it will point you in the correct direction.

I run under CICS using dynamic plan allocation. Within CICS we have ROLBE=YES set. This effectively means when we have a timeout or deadlock we will rollback with a -911 SQLCODE.
If I set ROLBE=NO then the deadlock would finish with a -913 but the UOW wouldn't be rolled back.

If your getting lots of these maybe you need to review the application design or the db2 locking strategy you have in place.

Cheers
Greg
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top