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
- 21702 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 error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
can you use symbolic parameters in JOB?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
Why do we need reorg in db2?
How to resolve -504 sql code in DB2?
Mention some fields that are a part of sqlca.
select distinct(empid),distinct(dept),name from EMP will the above query work?
What are the four lockable units for DB2?
is it compulsory commitment control in journal?
How can you quickly find out the # of rows updated after an update statement?
What is difference between alias and synonym in db2?
COBOL 
