Mention the downsides of page level lock.
- 1 Answers
- 1246 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What do the initials DDL and DML stand for and what is their meaning?
Why do chiropractors use drop table?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Explain the use of the WHERE clause.
how to check the table is empty or not?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What is a NULL value? What are the pros and cons of using NULLS?
What is isolation level?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
what are extents?
COBOL 
