What is buffer pool and list some of them?
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 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?
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.
Mention some fields that are a part of sqlca.
What is the purpose of using commit?
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?
What is check constraint. Explain with example.
What is difference between rollback and commit?
How do I optimize a query in db2?
What is the purpose of the DSNC transaction ?
What is an inner join, and an outer join ?
What is SPUFI?