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 find schema of a table in db2?
What is the advantage in De-normalizing tables in DB2?
is it compulsory commitment control in journal?
How can record locking be achieved in those DB2 versions which do not support it?
What is the difference between bind and rebind in db2?
What does db2 stand for?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Explain what are the various isolation levels possible?
what is the responsibility of the construction superintendent
What is dbrm? When it will be created?
What is scrollable cursor in db2?
What is data manager?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How many databases are there?
can all users have the privilage to use the sql statement select * (dml)?