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
- 21664 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 copy pending and check pending in db2?
What is COPY PENDING status?
What is meant by concurrency?
what is a collection?
How can you get the number of rows impacted by the last executed query?
What is concurrency?
max number of columns in a db2 table?
What is DYNSLT keyword? How do you perform selection using DYNSLT
Explain package in db2 and its advantages?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
pls explain the precompilation process of cobol-db2 pgm
What is dbrm? What it contains?
COBOL 
