How can you classify the locks in db2?


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

Post New Answer

More DB2 Interview Questions

What is an instance database?

0 Answers  


How do you select a row using indexes in db2?

0 Answers  


What is RUNSTATS?

3 Answers  


What is a collection in db2?

0 Answers  


How does DB2 store NULL physically?

2 Answers  


How would one remove old reorg information from the DB2 catalog?

2 Answers  


Is db2 a mainframe database?

0 Answers  


If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  


I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  


What is the error code -803 ?

3 Answers  


For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,


Categories