How do I handle -911 (deadlock) error in a db2 program so
that the program will never abend?
- 3 Answers
- 19647 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 concurrency in db2?
what are the SQL codes u freequently got?
define clustering index.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What are foreign keys in db2?
What is the default page size of buffer pools?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
How do you concatenate the firstname and lastname from emp table to give a complete name?
what is a trigger and types of triggers
How do you stop a db2 database in linux?
Which component is responsible for db2 startup and shutdown?
COBOL 
