Default language.

Setting up performance batch reports


To produce batch reports, you must first customize the  Performance Reporter component. You can customize Performance Reporter during  configuration, or by manually completing the following tasks in this section.

Consider the following prerequisites and tips before proceeding:

  • Make sure that you have the SYSADM/SYSCTRL privileges on the Db2 system containing Db2 objects for the Performance Reporter to use.
  • Before customizing Performance Reporter manually, create UBBPARM and UBBSAMP data sets (if they do not already exist) and copy DMRPRJCL from BBPARM to UBBSAMP.
Success

Tip

Sample members use default Db2 object names. If you change one of the object names, be sure to change every occurrence in every sample member. To ensure that you change all occurrences, use the DZPRUCNV utility.

To use this utility:

  1. Modify the DMRPRJCL sample in UBBSAMP to site standards. (For more information see Using-product-libraries.)
  2. Change statements for each object name:

    OLD=defaultName, NEW=newName

    For each object whose name you want to change, replace newName with the preferred name. When all the changes are complete, change P=NOWRITE to P=WRITE and submit the job.

Warning

Important

If PTF BPD5352 is not applied, see, V12.2 Setting up Performance batch reports.

This section contains the following topics:


Warning

Important

No initial customization is required to use Data Collector batch reporting. For more information, see Working-with-reports. To use archived Data Collector trace data sets as input to batch reporting, see theSystem and SQL Performance for DB2 Administrator Guide.

 

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

BMC AMI Ops Monitor for Db2 13.1