Updating the base batch reports

Follow these steps to update the base batch report program or to use the base programs directly.

Procedure

  • To update the base batch report program:
    1. Compile the program. You must provide your own compile JCL.
    2. Bind the batch report. The bind job is generated by TCz.
    3. Run the following batch report jobs (these jobs are generated by TCz):
      • CQMDSC - Dynamic SQL CPU
      • CQMDSE - Dynamic SQL Elapsed
      • CQMDSG - Dynamic SQL Getpages
      • CQMSSC - Static SQL CPU
      • CQMSSE - Static SQL Elapsed
      • CQMSSG - Static SQL Getpages
      • CQMSSO - Summary of Objects
  • To use the base programs directly:
    1. Run the bind jobs (the bind jobs are generated by TCz and use IBMTAPE. SCQMDBRM in the bind job).
    2. Run the following batch report jobs (these jobs are generated by TCz and using IBMTAPE.SCQMLOAD in batch report job):
      • CQMDSC - Dynamic SQL CPU
      • CQMDSE - Dynamic SQL Elapsed
      • CQMDSG - Dynamic SQL Getpages
      • CQMSSC - Static SQL CPU
      • CQMSSE - Static SQL Elapsed
      • CQMSSG - Static SQL Getpages
      • CQMSSO - Summary of Objects