Mention and explain the contention situations caused by locks?
- 1 Answers
- 999 Views
- I also Faced
- E-Mail Answers
Answer Posted / ereshwari
Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List some fields from sqlca?
What is difference between rollback and commit?
What is database reorganization?
What is an instance database?
What is copy pending status in db2?
Explain package in db2 and its advantages?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What's The Percentage Free Space ?
List down the data types in the db2 database.
What is db2 plan table?
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 .....
What is precompiler in db2?
What types of tables are there in the db2 database?
How does db2 sample database connect?
How to retrieve rows from a db2 table in embedded sql?
