How does DB2 determine what lock-size to use?
Answers were Sorted based on User's Feedback
Answer / 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 |
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What can the Locate option of the Repair Utility accomplish?
What are the abend codes occour in ur latest PROJECT in DB2
When DB2 connection fails, will online program work or give errors.
What is release/acquire in bind?
how to fetch multiple records without using cursor
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.
0 Answers ITC Infotech, Syntel,
What is db2 isolation?
What is dbrm? What it contains? When it will be created?
What is dbrm library?
What is difference between *omit and *nopass?