KyaPoocha.com

Related Interview Questions

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

  Run the MODIFY RECOVERY Utility....

• What Utility is used to migrate DB2 from one release to the next ?  12.04.08

  The DUMPCAT Utility....

• What is the STOSPACE Utility used for ?  09.04.08

  The STOSPACE Utility updates the DB2 catalog with the DASD utilization of the table space and index space data sets....

• What does the RUNSTATS Utility do?  09.04.08

  The RUNSTATS Utility collects statistical information for DB2 table spaces, partitions, indexes, tables and columns and stores this data in the DB2 Catalog....

• What is the purpose of the QUIESE Utility ?  05.04.08

  The QUIESE Utility prevents the start of any new table space activity while it gives active threads a chance to finish their tasks. Once all thread are inactive...

• When do you use the IMAGECOPY ?  18.03.08

  To take routine backup of tables, After a LOAD with LOG NO and After REORG with LOG NO...

• What is REORG? When is it used?  18.03.08

  REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space.  I...

• When will you chose to run RUNSTATS ?  17.03.08

  After a load, or after mass updates, inserts, deletes, or after REORG....

• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do ?  17.03.08

  Looks like index page split has occurred.  DO a REORG of the indexes....

• How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?  10.03.08

  If the tablespace used is only allocated to that STOGROUP: - ALTER STOGROUP - add volume (new) delete volume(old) - REORG TABLESPACE or RECOVER TABLESPACE Cr...