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 11 for z/OS:
- CATENFM
- CATMAINT
- DIAGNOSE
- LISTDEF
- OPTIONS
- QUIESCE
- REPAIR
- REPORT
- TEMPLATE
- All DSN stand-alone utilities
All other utilities are included in the Db2 Utilities Suite for z/OS (5655-W87, FMID JDBBB1K):
- 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 Db2 utility products
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 the utility product:
- SMP/E RECEIVE job, DSNRECVK
- Job DSNRECVK loads the Db2 Utilities Suite for z/OS Db2 11 program modules, macros, and procedures into temporary data sets (SMPTLIBs).
- SMP/E APPLY job, DSNAPPLK
- Job DSNAPPLK, copies and link-edits the program modules, macros, and procedures for the Db2 Utilities Suite for z/OS Db2 11 into the Db2 target libraries.
- SMP/E ACCEPT job, DSNACCPK
- Job DSNACCPK, copies the program modules, macros, and procedures for the Db2 Utilities Suite Db2 11 into the Db2 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 module, DSNUTILB, is split into multiple parts:
- a release-independent module called DSNUTILB
- a release-dependent module DSNUT111
- utility-dependent load modules
To operate in a mixed-release data sharing environment, you must have the following modules available to the utility jobs that operate across the data sharing group:
- The release-dependent modules from both releases
- All applicable utility-dependent modules