How does DB2 determine what lock-size to use?
- 2 Answers
- 8238 Views
- I also Faced
- E-Mail Answers
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 do you do to keep the cursor from closing after a commit?
How do I start db2 in windows?
What kind of database is db2?
can we drop column from a table
What is sqlca’s maximum length?
What does reorg do in db2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is package in cobol db2?
What is consistency token in db2?
What is release/acquire in bind?
What is ibm db2 used for?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
COBOL 
