What is buffer pool and list some of them?


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

Post New Answer

More DB2 Interview Questions

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.?

3 Answers  


If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


Mention some fields that are a part of sqlca.

0 Answers  


What is the purpose of using commit?

0 Answers  


For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  


What is check constraint. Explain with example.

0 Answers  


What is difference between rollback and commit?

0 Answers  


How do I optimize a query in db2?

0 Answers  


What is the purpose of the DSNC transaction ?

1 Answers  


What is an inner join, and an outer join ?

1 Answers   CTA,


What is SPUFI?

4 Answers  


Categories