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
- 21450 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 |
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is meant by a unit of recovery?
What is the picture clause of the null indicator variable?
What is the latest version of ibm db2?
What are leaf pages?
List out the buffer pools in db2
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Why might full image copies be faster to implement than an incremental image copy?
Suppose if I need to update a column, how you do that using cursor?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
COBOL 
