Interested to Buy Any Domain ? << Click Here >> for more details...
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 the usage of open cursor command?
What is cursor in dbms?
What does db2 stand for?
Is the primary key a clustered index?
Which isolation level provides maximum concurrency?
How connect db2 database to datastage?
What are the prerogatives?
Is db2 a programming language?
Explain various types of locks in db2?
What are the two types of logging in the db2 database? Explain them.
How to view db2 table structure?
What is the physical storage length of the data types date, time, and timestamp?
Can you use max on a char column?
What is sqlca’s maximum length?
What is release/acquire in bind?
