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 is clone table?
What db2 400?
Is it possible using max on a char column?
Discuss about db2 bind?
What is a plan and package in db2?
What are the different types of base tables?
What is a collection in db2?
Who uses db2?
What are the contents of a dclmgen?
On which levels locks can be applied?
What is the difference between db2 and oracle?
What is the difference between dbm cfg and db cfg file in db2 ?
Explain what are the various isolation levels possible?
Which isolation level provides highest data integrity?
What is a db2 schema?