How do I handle -911 (deadlock) error in a db2 program so
that the program will never abend?
- 3 Answers
- 20667 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kcs
Naidu,
Please go thru the qns before answering.Everyone knows that
it has to be restarted.
Qns here is how do you handle it in the program so that it
will never abend with deadlock.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naidu sekhar yandrapu
-911 ABEND DEDLCOK WITH TIMEOUT
SOL: RESTART JOB AFTER SOME TIME
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / 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 |
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What does CURRENTDATA option in bind indicate
How many sub queries can you combine together ?
What is an instance database?
What is buffer pool and list some of them?
What is db2 and what is the use of db2 optimizer?
What language is db2 written in?
is there any restrictions for unions ?
Mention the definition of cobol in varchar field.
Explain about cursor stability?
How to view db2 table structure?
What if we fail to give values in columns declared as NOT NULL ?
COBOL 
