DB2- 5 Types of Utilities

There are 5 kinds of Db2 utilities:

  • Data Consistency utility: Check,Repair,Report,Diagnose
  • Backup and Recovery Utility: Copy,CopytoCopy,Mergecopy,Quiesce,Recover,Rebuid index,Repair,Report recovery
  • Data movement and Organization utility: Load,Unlod,Reorg
  • Catologue manipulation utility: CATENFM, ATMAINT, DSNJCNVB, MODIFY RECOVERY, MODIFY STATISTICS, RUNSTATS,  STOSPACE
  • Stand-alone utility:DSNJLOGF, DSNJU003,DSNJU004, DSN1CHKR, DSN1COMP, DSN1COPY,DSN1SDMP,DSN1LOGP,DSN1PRNT

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.