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 |
What does it mean if the null indicator has -1, 0, -2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is an inner join, and an outer join ?
What is the command used by TSO users to invoke DB2?
What is database reorganization?
what is rebinding ?
Why db2 is called db2?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What are the 4 environments which can access DB2 ?
What is consistency token in db2?
What is dbrm in db2 database?
Comment whether the cursor is closed during commit or not.