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
Answer / nahid gorji
By using locksize page and Isolation level CS.
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / s
By storing one row per data page and using page locks.
Is This Answer Correct ? | 1 Yes | 2 No |
How to execute stored procedures?
Before you give the explain statement, what are the prerogatives?
What is package versioning? Please give an example.
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is an intent lock?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is meant by explain?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the different types of base tables?
What is the syntax for FETCH in DB2 ?
What are the rules for db2 programming?
What is explain in db2?