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
Which command is used to connect to a database in DB2 ? Give the Syntax.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How can you find out the # of rows updated after an update statement?
What is the role of union all and union
What is meant by explain?
What is explain plan in db2?
Define sqlca.
What is the syntax for creating a table in the db2 database?
What is the function of logging in the db2 database?
How do I add a column to an existing table in db2?
Is db2 a programming language?
What is a system catalog table in db2?
What is the maximum size of varchar data type in db2?
What's The Error Code For Unique Index Voilation?
What is a dbrm in db2?