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
- 21878 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 |
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to fetch the last row from the table in SQL (db2)?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What do you need to do before you do EXPLAIN?
What is the format (internal layout) of ?TIMESTAMP??
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
Give a brief description of db2 isolation levels?
If I have a view which is a join of two or more tables, can this view be updateable?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What are the uses of db2 optimizer?
select distinct(empid),distinct(dept),name from EMP will the above query work?
How to create backup table in db2?
COBOL 
