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

How to execute stored procedures?

0 Answers  


Before you give the explain statement, what are the prerogatives?

0 Answers  


What is package versioning? Please give an example.

1 Answers  


What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,


What is an intent lock?

3 Answers  






What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,


What is meant by explain?

0 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 are the different types of base tables?

0 Answers  


What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,


What are the rules for db2 programming?

0 Answers  


What is explain in db2?

0 Answers  


Categories