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 a cursor?

2 Answers  


What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  


How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  


can any one expalin check point with an example?

1 Answers  


How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,


How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,


Can there be more than one cursor open for any program?

0 Answers  


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


What is db2 bind process?

0 Answers  


what is difference between Plan and Package

1 Answers   Syntel,


In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


How do I delete a table in db2?

0 Answers  


Categories