Answer Posted / techie
Can anyone of you explain me the below statement.
"A solution used for lock escalation in past jobs have been
to have the jobs take an explicit lock on the partition
which prevents lock escalation."
How do i take lock on the partition level, what would be
the definition for it. I googled but couldnt get any
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to check last update on table in db2?
What is role in db2?
What is nvl in db2?
How to restart a DB2 program?
How can you quickly find out the # of rows updated after an update statement?
Is db2 a mainframe?
How do I add a column to a table in db2?
Can one database have multiple instances?
Explain about mirror activator disk mirroring?
What is a plan and package in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the max length of sqlca?
How to access db2 tables in mainframe?
What is the use of db2?
What is temporal table in db2?