Configuring and running the Db2 Utility Compare JCL

Edit online

Follow these steps to configure the job to generate the Db2 Utility Compare summary report.

Before you begin

The Db2 Utility Compare job is provided in the highlevel.SDAJSAMP library in member DAJUTC.

Procedure

  1. Copy the DAJUTC member to a location where you can edit and run the job.
  2. Provide a valid job statement for your site.
  3. Edit the PARM= value on the EXEC statement and the job DDs as described in the JCL comments.
  4. Edit the job parameters in the DAJSYSIN DD.
    Details about each parameter are described in the job comments. Additional notes are as follows:
    • Time periods should be identical in length. If they are not, Db2 Automation Expert issues a warning message, but still generates the summary report.
    • The base and new time periods cannot overlap.
    • Supported utilities are listed in the UTILITY_NAME section, commented out. If no specific utilities are uncommented, the defaults are REORG, COPY, and RUNSTATS.
    • When multiple utilities are specified, execution data in the summary report is shown for all utilities.
    • The JOB_PROFILE parameter is required. You must include at least one existing Db2 Automation Expert job profile that is available on the subsystem where you will submit the job.
  5. Submit the job.
  6. Check for messages returned from the job.
    They are located in the DD name defined by the MESSAGES DD.
  7. Review the summary report output that is generated in the DD name defined by the DAJSUMM DD.