DPRSMFA job control statements


This section describes the DPRSMFA job stream and the associated job control statements.

Overview of DPRSMFA

The DPRSMFA job stream extracts data from your SMF files and loads the extracted data into performance data tables by submitting jobs for each data type (statistics, accounting, audit, and storage). You can specify to submit the jobs in parallel or sequentially.

SMF data extraction is a multi-step batch execution procedure.  You can run this procedure on its own against the SMF files, or you can incorporate it into an existing job that also processes this data. You can break the procedure down into its component parts. You can also use generation data groups or other permanent data set types to store and pass the data between runs of the various steps. If required, you can delay some steps, such as the table load, until end-of-day processing.

After extracting data from SMF files, DPRSMFA submits four parallel jobs to load the extracted data into the performance database. By submitting parallel jobs, the elapsed time is significantly reduced compared with the DPRSMF method.

Each job loads a logical set of tables in the performance database. As each job completes, it performs a repair on the affected table spaces to remove COPYPEND restrictions. However, only the table spaces that are loaded (in restricted state) are repaired. These jobs can run and end in any order. For a sample of the job control statements, see Sample-DPRSMFA-JCL.

DPRSMFA job stream

The following diagram shows the DPRSMFA job stream:

DPRSMF JCL flow_2.png

The following table describes each step in the job stream:

Step

Description

1

Extracts the Db2 statistics, accounting, and audit records from the input SMF file, creating temporary statistics, accounting, and audit files

Control statements allow the selection of data of only certain specified record types or from specific Db2 subsystems.

For more information, see Step-1-DPRSMFA-SMF-extract-and-file-creation.

2

Creates discrete interval records from the cumulative statistics records

To consolidate any statistics intervals that span an SMF tape, this step maintains a spin file which resolves issues caused by processing the SMF tape out of sequence.

For more information, see Step-2-DPRSMFA-Statistics-consolidation.

3

Submits the following jobs in parallel or sequentially with Internal Reader:

  • DPRSMFST
  • DPRSMFAC
  • DPRSMFAU
  • DPRSMFSG 

For more information, see Step-3-DPRSMFA-Job-submission-for-parallel-processing .

Notes

Consider the following information:

  • You can specify procedure symbolics to disable either the summarization/load steps or the report steps.
  • The accounting and statistics extract files can be temporary or kept for additional reporting later.


 

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