Default language.

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  method, which uses the  () product

Note

 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 ( 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*