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 bind plan?
What is the use of value function?
Can we update view in db2?
What is the physical storage length of timestamp data type?
Mention the downsides of page level lock.
What parameters are used to control the free space in DB2?
Explain about cursor stability?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the clustering index in the db2 database?
How can the duplicate values be eliminated from db2 select?
What are bind parameters in db2?
What does db2 plan contain?
How do I import data from excel to db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are the benefits of using the db2 database?