How do u achieve record level locking in DB2 versions when
record level locking is not allowed?

Answers were Sorted based on User's Feedback



How do u achieve record level locking in DB2 versions when record level locking is not allowed?..

Answer / nahid gorji

By using locksize page and Isolation level CS.

Is This Answer Correct ?    2 Yes 2 No

How do u achieve record level locking in DB2 versions when record level locking is not allowed?..

Answer / s

By storing one row per data page and using page locks.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is the advantage in De-normalizing tables in DB2?

0 Answers  


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


pls tell me abt the normalization five types....

2 Answers  


What is meant by union and union all?

0 Answers  


What is query_cache_limit?

0 Answers  






Can we insert update delete in view?

0 Answers  


What is a lock?

1 Answers  


What is bind in db2?

0 Answers  


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. TIA

8 Answers   CGI, Wipro,


what is sql abend code -801,-802?

2 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


What is JOIN and different types of JOIN.

2 Answers   IBM,


Categories