What are the disadvantages of PAGE level lock?

Question Posted / guest

3 Answers
8504 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the disadvantages of PAGE level lock?..

Less concurrency. Lock contention occurs when an
application program is trying to acquire a lock that is
already held by another program.

Is This Answer Correct ?

5 Yes

1 No

What are the disadvantages of PAGE level lock?..

Answer / thomas john

high resource utilization when large updates are to be done

Is This Answer Correct ?

2 Yes

2 No

What are the disadvantages of PAGE level lock?..

Answer / rahul

nothing

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More DB2 Interview Questions

What is the STOSPACE Utility used for?

1 Answers

Explain what a plan is?

3 Answers CTS,

What are catalog tables in db2?

0 Answers

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers

what is check point and restart Logic ? why do we go for that ??

2 Answers CGI, UST, Xansa,

What is a subselect? Is it different from a nested select?

1 Answers

What is the picture clause of null indicator variable?

0 Answers

How is deadlock resolved?

0 Answers

What is declare cursor?

0 Answers

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers

For more DB2 Interview Questions Click Here