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 |
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
What is copy book?
What is a composite index and how does it differ from a multiple index?
Is db2 a mainframe?
What does sqlcabc has?
Why do chiropractors use drop table?
What is bufferpool in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
If I have a view which is a join of two or more tables, can this view be updateable?
how to resolve -811
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
Define db2 and its databases?