IBM MainFrame Question: Download Questions PDF
How to handle -911 (deadlock) error in a db2 program so that the program will never abend?
Answer:
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.
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.
Download IBM MainFrame Interview Questions And Answers
PDF
| Previous Question | Next Question |
| select distinct(empid),distinct(dept),name from EMP will the above query work? | Suppose I have 1000 rows in a db2 table. I want to update first 100 records, How do I do it? |