Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

SMF extract and table update (DPRSMFA and DPRSMF)


This section describes the process of extracting SMF data and loading the extracted data into the detail performance data tables.

You can use one of the following job streams to complete the process:

Job stream

Description

DPRSMFA

(Recommended method)

Extracts SMF data and submits jobs to load the extracted data to the tables by type ( statistics, accounting, audit, and storage). You can submit the jobs in parallel or sequentially.

For more information, see DPRSMFA-job-control-statements.

DPRSMF

Extracts SMF data and sequentially loads the extracted data to the tables by type (statistics, accounting, audit, and storage)

For more information, see DPRSMF-job-control-statements.

The SMF data set and control statements describing the Db2 tables to be loaded are the input to this procedure. The output of this process is the extracted data added to the detail performance data tables and, optionally, extract files.

You can use the following methods to load the Db2 tables:

  • The IBM LOAD method, which uses the IBM DSNUTILB utility
  • The BMC AMI Load method, which uses the BMC AMI Load for Db2 (BMC AMI Load) product

Note

BMC AMI Load is the preferred BMC table load utility.

As part of the MVDB2/DC archive data set creation process, sample JCL members are provided to execute the DPRSMF or DPRSMFA job stream. These members are provided in BBSAMP as DPRARC (IBM LOAD method) and DPRARCNL (BMC AMI Load method). For more information, see Customizing-after-installation .

This section contains the following topics:

 

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