Db2 utilities packaging

Several utilities are included with Db2 at no extra charge. Other utilities are available in the separate Db2 Utilities Suite for z/OS® product.

The following utilities are core utilities, which are included (at no extra charge) with Db2 12 for z/OS:

  • CATMAINT
  • DIAGNOSE
  • LISTDEF
  • OPTIONS
  • QUIESCE
  • REPAIR
  • REPORT
  • TEMPLATE
  • All DSN stand-alone utilities

Start of changeAll other utilities are enabled for general use by the Db2 Utilities Suite for z/OS (FMID HDBCC1K):End of change

  • BACKUP SYSTEM
  • CHECK DATA
  • CHECK INDEX
  • CHECK LOB
  • COPY
  • COPYTOCOPY
  • EXEC SQL
  • LOAD
  • MERGECOPY
  • MODIFY RECOVERY
  • MODIFY STATISTICS
  • REBUILD INDEX
  • RECOVER
  • REORG INDEX
  • REORG TABLESPACE
  • RESTORE SYSTEM
  • RUNSTATS
  • STOSPACE
  • UNLOAD

All Db2 utilities operate on catalog, directory, and sample objects, without requiring purchase of the Db2 Utilities Suite for z/OS.

SMP/E jobs for the Db2 Utilities Suite for z/OS product

To load the Db2 utility products, use System Modification Program Extended (SMP/E). SMP/E processes the installation cartridges and creates Db2 distribution target libraries.

Db2 provides several jobs that invoke SMP/E. These jobs are on the cartridge that you received with Db2 Utilities Suite for z/OS:

SMP/E RECEIVE job, DSNRECVK
Job DSNRECVK loads the Db2 Utilities Suite for z/OS Db2 12 procedures and samples into temporary data sets (SMPTLIBs).
SMP/E APPLY job, DSNAPPLK
Job DSNAPPLK copies and link-edits the procedures and samples for the Db2 Utilities Suite for z/OS Db2 12 into the Db2 Utilities Suite target libraries.
SMP/E ACCEPT job, DSNACCPK
Job DSNACCPK copies the procedures and samples for the Db2 Utilities Suite Db2 12 into the Db2 Utilities Suite distributed libraries.

The prologue for each job contains directions for tailoring the job for your site. Follow the instructions carefully to ensure that your SMP/E process for Db2 Utilities Suite for z/OS works correctly.

For detailed instructions for installing the Db2 Utilities Suite for z/OS product, see Db2 Utilities Suite for z/OS Program Directory.

Operation of Db2 utilities in a mixed-release data sharing environment

The utilities batch program, DSNUTILB, has a release-independent module called DSNUTILB and a release-dependent module for Db2 12 called DSNUT121. To operate in a mixed-release data sharing environment, you must have these modules available to the utility jobs that operate across the data sharing group, plus a release-dependent module for Db2 11 called DSNUT111. For more information, see Db2 utilities coexistence recommendations.