Interested to Buy Any Domain ? << Click Here >> for more details...
How do I handle -911 (deadlock) error in a db2 program so
that the program will never abend?
- 3 Answers
- 21526 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is consistency token in db2?
Define db2 and its databases?
What is dclgen in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Before you give the explain statement, what are the prerogatives?
What are db2 objects?
How will you return the number of records in table?
What is cursor with hold option in db2?
What is bind package and plan in db2?
How to check last update on table in db2?
What are the different types of base tables?
How can you do the explain of a dynamic sql statement?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Can we delete records from view?
