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
What is reorg?
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.
What does sqlcabc has?
i want to maintain uniqueness on pdf without make lf??????????
Why do we need reorg in db2?
What is a db2 collection?
What is bufferpool in db2?
What is the syntax for FETCH in DB2 ?
How does a cursor work?
How to check last update on table in db2?
What's The Percentage Free Space ?
What is db2 catalog database?
What is page size in db2?
What r the comman abends in db2, jcl and cobol???????
What is the use of runstats in db2?