How do u achieve record level locking in DB2 versions when
record level locking is not allowed?
Answer Posted / s
By storing one row per data page and using page locks.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
List down the types of triggers in the db2 database?
What happens in bind step in a db2 program?
Explain package in db2 and its advantages?
When the like statement is used?
Why do we use cursor?
What is dbrm?
What is bufferpool in db2?
What is a page in db2?
What does sqlcabc has?
What is the usage of open cursor command?
What is difference between alias and synonym in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is syscat in db2?
What is the role of union all and union
Name the lockable units in DB2?