How does DB2 determine what lock-size to use?
- 2 Answers
- 8042 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 is rebind in db2?
how to identify the pseudo conversation by seeing the program
What does CURRENTDATA option in bind indicate
What does the CHECK Utility do ?
Q4. How will you get the count of record without using COUNT verb in query?
On which levels locks can be applied?
What is the maximum size of a char data type in db2?
What are column-name qualifiers used?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What are the full forms of spufi and dclgen and why are they used?
When is the authorization check on DB2 objects done - at BIND time or run time?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
COBOL 
