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 is plan? is plan executable or package?
What is explain plan in db2?
When will you chose to run RUNSTATS?
How to insert more than one record using insert?
what happend with out using Commit,when closing cursor and program?
Define buffer pool.
What is data manager?
What are data types?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is a collection?
How to create db2 table in mainframe?
Name some fields from SQLCA