Stand-alone utilities

Some stand-alone utilities can be run only by means of JCL.

These stand-alone utilities are:

  • DSN1COPY
  • DSN1COMP
  • DSN1PRNT
  • DSN1SDMP
  • DSN1LOGP
  • DSNJLOGF
  • DSNJU003 (change log inventory)
  • DSNJU004 (print log map)

Most of the stand-alone utilities can be used while Db2 is running. However, for consistency of output, the table spaces and index spaces must be stopped first because these utilities do not have access to the Db2 buffer pools. In some cases, Db2 must be running or stopped before you invoke the utility.

Begin general-use programming interface information.Stand-alone utility job streams require that you code specific data set names in the JCL. To determine the fifth qualifier in the data set name, you need to query the Db2 catalog tables SYSIBM.SYSTABLEPART and SYSIBM.SYSINDEXPART to determine the IPREFIX column that corresponds to the required data set. End general-use programming interface information.

The change log inventory utility (DSNJU003) enables you to change the contents of the bootstrap data set (BSDS). This utility cannot be run while Db2 is running because inconsistencies could result. Use the STOP DB2 MODE(QUIESCE) command to stop the Db2 subsystem, run the utility, and then restart Db2 with the START DB2 command.

The print log map utility (DSNJU004) enables you to print the bootstrap data set contents. The utility can be run when Db2 is active or inactive; however, when it is run with Db2 active, the user's JCL and the Db2 started task must both specify DISP=SHR for the BSDS data sets.