Mainframe DB2 Interview Questions

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…

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…

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…

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.)…

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…