How do I handle -911 (deadlock) error in a db2 program so
that the program will never abend?
Answer Posted / sireesha
Dead lock time out erro occurs in the following case:
If two or more programs acquired exclusive lock on the
data,which may be needed for other programs without that
data which can not proceed further.
Solution: You can roll back current unit of work for one of
the programs after preset time interval for deadlocks and
terminate that program.
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What are db2 objects?
What are packages in db2?
What are the prerogatives?
Mention some fields that are a part of sqlca.
How to execute stored procedure in db2 command editor?
What is data manager?
What is a db2 schema?
What is release/acquire in bind?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How do I add a column to a table in db2?
How does a cursor work?
What is explain in db2?
What is temporal table in db2?
Highlight all the advantages that are attached to a package.
What action db2 takes when a program aborts in the middle of a transaction?