Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Default language.

Preparing tables for Performance Reporter

Use one of the following procedures to prepare the tables that Performance Reporter will use:

Warning

Important

If you want to update tables to a newer version, consider the following information:

  • You cannot skip release levels. That is, you can update tables to the new release level from one release level back.
  • Before updating tables to a newer version, Performance Reporter maintenance for the previous version must be fully up-to-date.

Related topic

Setting-up-performance-batch-reports

Before you begin

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

To create new Performance Reporter tables

  1. (Optional) Using the DZPRUCNV utility by accessing the DMRPRJCL sample in the UBBSAMP data set, change the default names to conform to your site's naming convention. See the samples in the following table.For more information, see Using-product-libraries.

    Default table name and description

    Default table space name

    Create table space/table member (UBBSAMP)

    Report members (BBPARM)

    Accounting tables

    DMRPR.DMRACDTL

    (Accounting table—detail)

    DMRPRTAD

    DPCSACDT

    DPCTACDT

    ACxxxxxx

    DMRPR.DMRACSUM

    (Accounting table—summary)

    DMRPRTAS

    DPCSACSM

    DPCTACSM

    SAxxxxxx

    DMRPR.DMRACSM2

    (Accounting table—summary–2)

    DMRPRTA2

    DPCSACS2

    DPCTACS2

    SAxxxxxx

    DMRPR.DMRAXDTL

    (Accounting Accelerator table—detail)

    DMRPRXAD

    DPCSAXDT

    DPCTAXDT

    Not applicable

    DMRPR.DMRAXSUM

    (Accounting Accelerator table—summary)

    DMRPRXAS

    DPCSAXSM

    DPCTAXSM

    Not applicable

    DMRPR.DMRAXSM2

    (Accounting Accelerator table—summary)–2

    DMRPRXA2

    DPCSAXS2

    DPCTAXS2

    Not applicable

    DMRPR.DMRADDTL

    (DDF accounting table—detail)

    DMRPRTDD

    DPCSADDT

    DPCTADDT

    ACxxxxx

    DMRPR.DMRADSUM

    (DDF accounting table—summary)

    DMRPRTDS

    DPCSADSM

    DPCTADSM

    SAxxxxxx

    DMRPR.DMRADSM2

    (DDF accounting table—summary–2)

    DMRPRTD2

    DPCSADS2

    DPCTADS2

    SAxxxxxx

    DMRPR.DMRAPDTL

    (Package accounting table—detail)

    DMRPRTPD

    DPCSAPDT

    DPCTAPDT

    ACxxxx

    DMRPR.DMRAPSUM

    (Package accounting table—summary)

    DMRPRTPS

    DPCSAPSM

    DPCTAPSM

    SAxxxx

    DMRPR.DMRAPSM2

    (Package accounting table—summary–2)

    DMRPRTP2

    DPCSAPS2

    DPCTAPS2

    SAxxxx

    DMRPR.DMRABDTL

    (Buffer accounting table—detail)

    DMRPRTID

    DPCSABDT

    DPCTABDT

    ACxxxxxx

    DMRPR.DMRABSUM

    (Buffer accounting table—summary)

    DMRPRTIS

    DPCSABSM

    DPCTABSM

    SAxxxxxx

    DMRPR.DMRABSM2

    (Buffer accounting table—summary–2)

    DMRPRTI2

    DPCSABS2

    DPCTABS2

    SAxxxxxx

    Statistics tables

    DMRPR.DMRSBFDT

    (Buffer statistics table—detail)

    DMRPRTBD

    DPCSSBDT

    DPCTSBDT

    STxxxxx

    DMRPR.DMRSBSUM

    (Buffer statistics table—summary)

    DMRPRTBS

    DPCSSBSM

    DPCTSBSM

    SSxxxxx

    DMRPR.DMRSBSM2

    (Buffer statistics table—summary–2)

    DMRPRTB2

    DPCSSBS2

    DPCTSBS2

    SSOVDFT

    SSOVRxx

    DMRPR.DMRSTDF

    (DDF statistics table—detail)

    DMRPRTSF

    DPCSSTSD

    DPCTSTSD

    STOVDFT

    DMRPR.DMRSDSUM

    (DDF statistics table—summary)

    DMRPRTFS

    DPCSSFSM

    DPCTSFSM

    STOVDFT

    DMRPR.DMRSDSM2

    (DDF statistics table—summary–2)

    DMRPRTF2

    DPCSSFS2

    DPCTSFS2

    SSxxxxx

    DMRPR.DMRSXDTL

    (Statistics Accelerator table—detail)

    DMRPRXSD

    DPCSSXDT

    DPCTSXDT

    Not applicable

    DMRPR.DMRSXSUM

    (Statistics Accelerator table—summary)

    DMRPRXSM

    DPCSSXSM

    DPCTSXSM

    Not applicable

    DMRPR.DMRSXSM2

    (Statistics Accelerator table—summary–2)

    DMRPRXS2

    DPCSSXS2

    DPCTSXS2

    Not applicable

    DMRPR.DMRSTAT

    (Statistics table—detail)

    DMRPRTSS

    DPCSSTDT

    DPCTSTDT

    STxxxxxx

    DMRPR.DMRSTSUM

    (Statistics table—summary)

    DMRPRTTS

    DPCSSTSM

    DPCTSTSM

    SSxxxxxx

    DMRPR.DMRSTSM2

    (Statistics table—summary–2)

    DMRPRTT2

    DPCSSTS2

    DPCTSTS2

    SSxxxxx

    DMRPR.DMRSTATA

    (Statistics A table—Detail)

    Warning

    Some content is unavailable due to permissions.

    DMRPRSAD

    DPCSSTAD

    DPCTSTAD

    Not Applicable

    DMRPR.DMRSTASM

    (Statistics A table—Summary)

    Warning

    Some content is unavailable due to permissions.

    DMRPRSAS

    DPCSSTAS

    DPCTSTAS

    Not Applicable

    DMRPR.DMRSTAS2

    (Statistics A table—Summary 2)

    Warning

    Some content is unavailable due to permissions.

    DMRPRSA2

    DPCSSTA2

    DPCTSTA2

    Not Applicable

    DMRPR.DMRSTATB

    (Statistics B table—Detail)

    Warning

    Some content is unavailable due to permissions.

    DMRPRSBD

    DPCSSTBD

    DPCTSTBD

    Not Applicable

    DMRPR.DMRSTBSM

    (Statistics B table—Summary)

    Warning

    Some content is unavailable due to permissions.

    DMRPRSBS

    DPCSSTBS

    DPCTSTBS

    Not Applicable

    DMRPR.DMRSTBS2

    (Statistics B table—Summary 2)

    Warning

    Some content is unavailable due to permissions.

    DMRPRSB2

    DPCSSTB2

    DPCTSTB2

    Not Applicable

    DMRPR.DMRSYDTL

    (Simulated bufferpool detail table)

    DMRPRSYM

    DPCSSYDT

    DPCTSYDT

    Not Applicable

    DMRPR.DMRSYSUM

    (Simulated bufferpool summary table)

    DMRPRSYS

    DPCSSYSM

    DPCTSYSM

    Not Applicable

    DMRPR.DMRSYSM2

    (Simulated bufferpool summary 2 table)

    DMRPRSY2

    DPCSSYS2

    DPCTSYS2

    Not Applicable

    DMRPR.DMRSTADT

    (Storage address space table)

    DMRSTADT

    DPCSSADT

    DPCTSADT

    Not applicable

    DMRPR.DMRSTSDT

    (Storage system table)

    DMRSTSDT

    DPCSSSDT

    DPCTSSDT

    Not applicable

    DMRPR.DMRDGPDT

    (Group bufferpool attributes)

    DMRDGPDT

    DPCSDGDT

    DPCTDGDT

    Not applicable

    Audit tables

    DMRPR.DMRAUCMD

    (Audit command table)

    DMRPRAUC

    DPCSAUCM

    DPCTAUCM

    Not Applicable

    DMRPR.DMRAUGRV

    (Authorization control—GRANTs/REVOKEs table)

    DMRPRAUG

    DPCSAUGR

    DPCTAUGR

    AUDGRV

    DMRPR.DMRAUFAL

    (Authorization failures table)

    DMRPRAUF

    DPCSAUFL

    DPCTAUFL

    AUFAIL

    DMRPR.DMRAUCHG

    (Authorization ID change table)

    DMRPRAUC

    DPCSAUCH

    DPCTAUCH

    AUCHNG

    DMRPR.DMRAURLS

    (Remote location statistics table)

    DMRPRALS

    DPCSAULS

    DPCTAULS

    Not Applicable

    DMRPR.DMRAUDDL

    (DDL access table)

    DMRPRAUD

    DPCSAUDL

    DPCTAUDL

    AUDDL

    DMRPR.DMRAUDML

    (DML access table)

    DMRPRAUM

    DPCSAUDM

    DPCTAUDM

    AUDML

    DMRPR.DMRAUUTL

    (Utility access table)

    DMRPRAUU

    DPCSAUUT

    DPCTAUUT

    AUUTIL

    DMRPR.DMRAUSUM

    (Audit summary table)

    DMRPRAUS

    DPCSAUSM

    DPCTAUSM

    AUSUM

    AUDTL

    DMRPR.DMRAUADM

    (Audit admin table)

    DMRPRAAA

    DPCSAUAA

    DPCTAUAA

    Not Applicable

    DMRPR.DMRAUTRC

    (Audit trace table)

    DMRPRATR

    DPCSAUTR

    DPCTAUTR

    Not Applicable

    DMRPR.DMRAUDMB

    (DML at BIND table)

    DMRPRAUB

    DPCSAUDB

    DPCTAUDB

    AUDMLB

    DMRPR.DMRAUIFE

    (Incompatible function table)

    DMRPRAIC

    DPCSAUIC

    DPCTAUIC

    Not Applicable

    DMRPR.DMRAUFTB

    (Fast index traversal table)

    DMRPRAFI

    DPCSAUFI

    DPCTAUFI

    Not Applicable

  2.  Edit member DPJCREAT and run it on the same Db2 system where the objects are to be created-DPJCREAT is a multi-step allocation, bind, and grant job.

    The first step allocates the spin files that are required by the DPRSMF job, which extracts Db2 SMF records and loads the data into the Performance Reporter tables.
    The second and third steps define the database, table spaces, tables, and indexes used to store the performance data.
    The fourth and fifth steps bind and grant access to the Performance Reporter packages and plans.
    If you did not use DMRPRJCL or DZPRUJCL to configure the Performance Reporter Jobs, then perform the following steps:

    1. Verify the job statement.
    2. Change the product high-level qualifier parameters to the high-level qualifier of your BMC Software product libraries.
    3. Verify the DB2LOAD and DB2RUNL libraries.
    4. Specify the UNIT and VOL parameters. These parameters are used to allocate a small permanent data set used by the SMF extractor.
    5. Submit the job.
    Warning

    Important

    The Performance Reporter DDL is set up to use STOGROUP DMRPRSG1. Sample job DMRPRJCL updates the DMRPRSG1 to SYSDEFLT.  If you do not want to use SYSDEFLT or you are not using DMRPRJCL to configure Performance Reporter, you must create STOGROUP DMRPRSG1 in the Db2 subsystem that will host your Performance Reporter database. When using DMRPRJCL, you may change SYSDEFLT to some other existing STOGROUP. You may uncomment the contents of member DPCSTOW to create a STOGROUP when Performance Reporter is configured. For more information see DPCSTOW.

    You cannot migrate data from an earlier version of Performance Reporter into the newly created tables. If you want to use existing Performance Reporter tables, see To update existing Performance Reporter tables to a newer version.

To update existing Performance Reporter tables to a newer version

  1. Verify that the maintenance for the previous version of Performance Reporter is up to date.

    Warning

    Important

    If you want to update tables to a newer version, consider the following information:

    • The DPJALTER job should not be used to mass apply maintenance. It should only be used to update the tables to the new release level from one release level back.

      WarningSome content is unavailable due to permissions.

    • You cannot skip release levels. That is, you can only update tables to the new release level from one release level back.
    • Before updating tables to a newer version, Performance Reporter maintenance for the previous version must be fully up to date.
  2. Run the DPJALTER job to change the DMRTABLEVERSION, and any other structure changes that might have been updated due to maintenance.
  3. You must run the DPJREPAR job one time after you run the DPJALTER job.

    WarningSome content is unavailable due to permissions.

  4. Run the DPJBIND job to bind the plan that processes all Performance Reporter data.

    WarningSome content is unavailable due to permissions.


You are provided with a populated set of Performance Reporter tables that you can maintain with the newer version of DPRDSMF.

 

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

BMC AMI Ops Monitor for Db2 13.1