Tailoring the JCL

Complete the procedures in this topic to tailor the Performance Reporter.

Before you begin

For prerequisites and tips to consider, see Setting-up-performance-batch-reports.

Important

If you use Performance Reporter utilizing BMC AMI Load make sure that your SSIDs are configured to run with NGT utilities or your jobs will fail with RC=8 and you will receive the following error: NGTR300E NGT HAS NOT BEEN CONFIGURED FOR DB2 SUBSYSTEM 0GBL.

To tailor extract JCL

Edit one of the following members in UBBSAMP and tailor it for your periodic production:

  • DPRSMF (IBM LOAD utility)
    This method loads the Db2 tables by using the Db2 LOAD utility, DSNUTILB.
  • DPRSMFNL (BMC AMI Load utility)
    This method loads the Db2 tables by using BMC AMI Load utility, NGTUTIL.

Related topic

Setting-up-performance-batch-reports

DPRSMF and DPRSMFNL are runtime jobs that extract accounting and statistics records from SMF, reformat them, and load them into Db2. (For more information, see the Working-with-reports.) You can load accounting records can be loaded in summary tables, detail tables, or both.

  1. Verify the job card.
  2. Change the HIDP parameter to the high-level qualifier of your BMC product libraries.For the BMC AMI Load utility, change the NGTLINK parameter to your BMC AMI Load product library.
  3. Verify your Db2 Load and Exit library names.
  4. Specify the data set name of the unloaded SMF data set for the SMF parameter.
  5. Specify the UNIT name to allocate temporary work space.
  6. Specify the target Db2 system for the SYSTEM parameter.
  7. Specify the ID of a Db2 Load Utility for the UID parameter.
  8. Change the value of the SSID parameter to the target Db2 subsystem ID in the first input control statement for Step 3.
  9. If you changed default creator names in the Performance Reporter tables, verify and if necessary correct the table name.
  10. If you changed the default database names (when setting up Performance Reporter defaults or creating new tables), change those names in the REPAIR step.

To tailor summarization JCL

Edit the following members in UBBSAMP and tailor it for your periodic production:

  • DPRSUM (IBM LOAD utility)
    This method loads the Db2 tables by using the Db2 LOAD utility, DSNUTILB.
  • DPRSUMNL (BMC AMI Load utility)
    This method loads the Db2 tables by using the BMC AMI Load utility, NGTUTIL.

DPRSUM and DPRSUMNL summarize accounting data and purge outdated data from the performance data tables. (For more information, see the Working-with-reports.) You can load accounting records in summary tables, detail tables, or both.

  1. Verify your job statement to the member.
  2. Change the HIDP parameter to the high-level qualifier of your BMC product libraries.For the BMC AMI Load utility, change the NGTLINK parameter to your BMC AMI Load product library.
  3. Verify your Db2 Load and Exit library names.
  4. Specify the UNIT name to allocate temporary work space.
  5. Specify the target Db2 system for the SYSTEM parameter.
  6. Specify the ID of a Db2 load utility for the UID parameter.
  7. Examine and change the control statements as necessary to implement your data storage strategy.
  8. If you changed default names in the Performance Reporter tables, modify the table name.

To tailor report JCL

Edit member DPRREPT in UBBSAMP and tailor it for your periodic production. DPRREPT runs the reporting jobs. For more information, see the Working-with-reports.

  1. Add your job statement to the member.
  2. Change the HIDP parameter to the high-level qualifier of your BMC product libraries.
  3. Verify your Db2 Load and Exit library names.
  4. Specify the UNIT name to allocate temporary work space.
  5. Adjust the list of reports as needed for your site. The default generates all the Performance Reporter predefined reports.
  6. Specify the target Db2 system for the SSID parameter.
  7. If you changed default names in the Performance Reporter tables, modify the table name.
  8. Delete unwanted reports.

To tailor Data Collector batch report JCL

This procedure is optional. If you do not plan to use the BMC AMI OpsM for Db2 Data Collector batch reports, you can skip this procedure.

Edit the JCL member #DOMRPRT that is provided with the Data Collector, and tailor it for your environment. This job creates Data Collector batch reports.

  1. Add your job statement to the member.
  2. Change the ?TRACEDSN? text to specify the input NGL archive data set that is used to produce the Data Collector batch reports.
  3. Insert the Data Collector batch report control cards following the SYSIN DD * JCL statement to produce your report. The comment section following the job stream lists the control cards you can use.

To tailor Data Collector archive Performance Reporter table load JCL

This procedure is optional. If you do not plan to use the Data Collector archive data set as input to the SMF Performance Reporter table load process, you can skip this procedure.

This job creates a Data Collector archive data set, and then uses it as input to the SMF Performance Reporter table load process.

  1. In UBBSAMP, edit the following members to tailor it for your environment and add your job statement:
    • DPRARC (IBM LOAD utility)
    • DPRARCNL (BMC AMI Load utility)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*