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
All other utilities are enabled for general use by the Db2 Utilities Suite for z/OS (FMID HDBCC1K):
- 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.