Answer Posted / Subhash Kumar Mishra
Page-level locks in DB2 can have several disadvantages:
1. Fine-grained locks: Because each page is locked individually, it leads to more lock contention, which can potentially reduce concurrent access and performance.
2. Lock escalation: If too many pages are locked at the page level, DB2 may escalate these locks to table or partition level, leading to increased lock contention and potential performance degradation.
3. Lack of consistency: Page-level locks do not provide read consistency across multiple pages. This means that a query reading from multiple pages could potentially see an inconsistent state of the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
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.
What is the latest version of ibm db2?
