What is lock escalation in db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is DCLGEN ?

3 Answers  


What information is used as input to the bind process?

2 Answers  


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


what is consistency token

3 Answers  


Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  






Explain about dbrm.

0 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,


What's the maximum number of characters that a tablename can have?

3 Answers  


What is the usage of open cursor command?

0 Answers  


Why select is not preferred in embedded sql programs?

0 Answers  


what are bind concepts in db2 cobol?

0 Answers  


Categories