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 |
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What Utility is used to migrate DB2 from one release to the next?
What is table space in db2?
What is a DB2 access path?
How is a typical DB2 batch program executed ?
What is Declaration Generator(DCLGEN)?
What are data types?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What does the REORG Utility do?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is lock contention?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its