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 |
Why do we use cursor?
what is SMP/E? and what are the major steps of it? thanks...
What is a collection?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What does the REORG Utility do?
What is alias in db2?
How can you display the current date & current time ?
What is phantom read in db2?
What is the role of data manager in the db2 database?
Which transaction use a command thread ?
What db2 400?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?