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
- 21709 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the advantage in De-normalizing tables in DB2?
What is the result of open cursor statement?
What is the role of the data page in the db2 database?
What is the maximum size of varchar data type in db2?
What language is db2 written in?
How to access db2 tables in mainframe?
Explain the function of data manager.
What is the difference between bind and rebind in db2?
What is query_cache_limit?
Mention the location where the output received from explain statement is stored.
List some fields from sqlca?
How to execute stored procedure in db2 command editor?
What are the rules for db2 programming?
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 .....
Explain about cursor stability?
