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 out the data types available.
How do I create a view in db2?
How can you classify the locks in db2?
What is data manager?
What are the two types of logging in the db2 database? Explain them.
How do we specify index to include or not during bind process.
Give a brief description of db2 isolation levels?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Explain about dbrm.
Explain various types of locks in db2?
Which components manage deadlocks in db2?
How to restart a DB2 program?
How and when does the db2 enforces the unique key?
What is null indicator in db2?
What is cobol db2?