IBM MainFrame Interview Question:

How to handle -911 (deadlock) error in a db2 program so that the program will never abend?

Submitted by: Administrator

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.
Submitted by: Administrator