Answer Posted / andank
The Answer # 1 is perfect. When Lock esculation happens,
DB2 issues a warning message, DSNI031I.
Please beaware Lock Escalation and Lock Promotion are two
different concepts.
Lock promotion is the action of exchanging one lock on a
resource for a more restrictive lock on the same resource,
held by the same application process.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How can we retrieve the total number of records in RPG & CLLE?
List down the data types in the db2 database.
Can you tell me how can you find out the # of rows updated after an update statement?
What is db2 command?
What is ibm db2 used for?
What is cascading rollback?
What type of database is db2?
How to restart a DB2 program?
What is check constraint. Explain with example.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is a page in db2?
Explain package in db2 and its advantages?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
List out the data types available.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
