Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 determine what lock-size to use?
- 2 Answers
- 8721 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 |
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is a db2 package?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain dclgen.
What is dbrm library?
How to know the primary key of a table without defining the primary key in the table?
what needs to be done if a table is in copy pending / check pending status?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to resolve -818 sql code in DB2?
What is a clustered index?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
COBOL 
