Interested to Buy Any Domain ? << Click Here >> for more details...
What techniques will be used to avoid deadlock??
- 5 Answers
- 14410 Views
- IBM, SUN, I also Faced
- E-Mail Answers
Answer Posted / nahid gorji
-Minimize the lock size as much as possible.
- Maximize the sharing of the resource by using CS or UR
Isolation levels when possible.
- Minimize the number of rows in one page for frequently
used tables if you want to avoid row locksize.
- use CURRENTDATA( NO) to avoid acuiring locks.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is db2 command?
What type of database is db2?
What is difference between rollback and commit?
Define sqlca.
What is release/acquire in bind?
what is the responsibility of the construction superintendent
Which components manage deadlocks in db2?
How is the value function used?
What are the different types of base tables?
What are concurrency issues?
What is the difference between using bind () and rebind () methods of naming class?
can we view the access paths created by dbrm ? how ? thx
What is sqlca?
Mention the definition of cobol in varchar field.
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 .....
