Db2 stand-alone utilities

The stand-alone utilities run as batch jobs that are independent of Db2. The only way to run these utilities is to use JCL.

Invoking stand-alone utilities
To invoke a stand-alone utility, you must use JCL. Some stand-alone utilities read the utility control statements from an input stream; other utilities obtain the function definitions from JCL EXEC PARM parameters.
DSNJCNVB
The DSNJCNVB stand-alone conversion utility converts the bootstrap data set (BSDS) so that it can support up to 10,000 archive log volumes and 93 active log data sets per log copy.
DSNJCNVT
The DSNJCNVT stand-alone conversion utility converts the bootstrap data set (BSDS) records that are necessary to support 10-byte RBA and LRSN fields.
DSNJLOGF (preformat active log)
When writing to an active log data set for the first time, Db2 must preformat a VSAM control area before writing the log records. The DSNJLOGF stand-alone utility avoids this delay by preformatting the active log data sets before bringing them online to Db2.
DSNJU003 (change log inventory)
The DSNJU003 stand-alone utility changes the bootstrap data sets (BSDSs).
DSNJU004 (print log map)
The DSNJU004 (print log map) stand-alone utility generates a variety of information that can be useful in backup and recovery situations.
DSNJU008 (print CDDS)
The DSNJU008 (print CDDS) stand-alone utility prints the compression dictionary data set (CDDS).
DSN1COMP
The DSN1COMP stand-alone utility estimates space savings that are to be achieved by data compression in table spaces, including LOB table spaces, and indexes. You can estimate the space savings for fixed-length Db2 data compression, Huffman compression, or both.
DSN1COPY
You can use the DSN1COPY stand-alone utility to copy Db2 VSAM data sets.
DSN1LOGP
The DSN1LOGP stand-alone utility formats the contents of the recovery log for display.
DSN1PRNT
With the DSN1PRNT stand-alone utility, you can print Db2 VSAM data sets. These data sets can contain table spaces or index spaces, image copy data sets, and sequential data sets that contain Db2 table spaces or index spaces.
DSN1SDMP
IBM Support might advise you to use the IFS selective dump (DSN1SDMP) stand-alone utility. DSN1SDMP enables you to force dumps when selected Db2 trace events occur, write Db2 trace records to user-defined z/OS data sets, or start another Db2 trace.

Parent topic: Db2 utilities