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 |
i want to delete 20th million record how ?
When is the access path determined for dynamic SQL?
what is different three logs in DB2?
What is syscat in db2?
Define db2.
What is cursor stability in db2?
Is db2 free?
What does runstats do in db2?
What is deadlock?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
how to unload different table data into different gdg files/ vsam files.