« Technical Interview & Viva Questions : KyaPoocha.com home page
« Which catalog table stores referential constraints ?
How would one remove old reorg information from the DB2 catalog ? »



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


The DUMPCAT Utility.



Explore posts in the same categories: Database Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • How to migrate roles from one database to another database ?
    • 1. Include all the roles in a project by clicking on Insert -> Definitions into Project -> select Roles and...
  • What does the RUNSTATS Utility do?
    • The RUNSTATS Utility collects statistical information for DB2 table spaces, partitions, indexes, tables and columns and stores this data in...
  • What is the purpose of the QUIESE Utility ?
    • The QUIESE Utility prevents the start of any new table space activity while it gives active threads a chance to...
  • What is the STOSPACE Utility used for ?
    • The STOSPACE Utility updates the DB2 catalog with the DASD utilization of the table space and index space data sets....
  • What is Release Candidate?
    • A pre-release version, which contains the desired functionality of the final version, but which needs to be tested for bugs...
  • What utility can you use to show a dynamic listing of running processes?
    • Top-The top utility shows a listing of all running processes that is dynamically updated...
  • What is SQL*Loader?
    • SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. One can load...
  • What can the SET option of the Repair Utility accomplish ?
    • The set option of the Repair utility can reset a copy pending, check pending, and recover pending flags....
  • How is a typical DB2 batch program executed ?
    • There are two methods of executing a DB2-batch program 1. Use DSN utility to run a DB2 batch program from native...
  • Difference between Dispose and Finallize method?
    • Finalize method is used to free the memory used by some unmanaged resources like window handles (HWND). It's similar to...

    Comments are closed.