41) How is a typical DB2 batch pgm executed ? 1. Use DSN utility to run a DB2 batch program from native TSO. An example is shown: DSN SYSTEM(DSP3) RUN Continue Reading »
Home / Posts Tagged "Mainframe DB2 Interview Questions"
31) How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only ) Use WITH HOLD option in DECLARE CURSOR statement. But, it Continue Reading »
21.) Explain about RCT. RCT is expanded as Resource – Control Table and is defined in the DB2/CICS region. This is the component that comprises of features that are gathered Continue Reading »
11.) Explain the function of Data Manager. The physical database is managed by the DB2 component called Data manager. It invokes other system components to perform logging, locking etc. 12.) Continue Reading »
1.) How would you find out the total number of rows in a DB2 table? Use SELECT COUNT(*) … in db2 query 2.) How do you eliminate duplicate values in Continue Reading »