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 |
select 100 records from million records ?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Where besides the DB2 catalog is database object information stored by DB2?
Why do chiropractors use drop table?
What is dynamic SQL?
How to select the duplicate rows from a table?
wht happens if we close cursor with cursor with hold option?
what is utility for parm lib
What is the SQL Communications Area and what are some of its key fields?
Which command is used to remove all rows from a table?
Is there any advantage to denormalizing DB2 tables?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?