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 Apptune for Db2 13.1.

DOMBRPT1 utility

The DOMBRPT1 utility is the Data Collector utility that produces printed reports from a batch job.

Note

In certain DOMBRPT1 statement types you can use wildcards to represent multiple statement values. However, wildcards are permitted only at the end of a string.

DOMBRPT1 uses archived data sets, active data sets, or both (SPE2006 applied) as input. An external sort utility named SORT is required. If no program is named SORT in the z/OS LINKLIST, you might need to add a DD statement to your STEPLIB that identifies the load library that contains the sort utility. When processing large amounts of data, your sort utility might need additional SORTWK nn DD statements. (Consult your sort utility documentation for details.)

Member #ASQRPRT in the hlq.llqSAMP data set contains sample JCL to run the batch report utility. For details, see the code example in DOMBRPT1 JCL.

DOMBRPT1 JCL

The following figure is an example of DOMBRPT1 JCL. 

Example
//DOMRPT1      JOB  (ACCT),'BATCH REPORT',        <== MODIFY
 //             MSGCLASS=X,                        <== CHECK
 //             class="A"                            <== CHECK
 //*
 //*Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z
 //*
 //DOMRPT1      JOB  (ACCT),'BATCH REPORT',        <== MODIFY
 //             MSGCLASS=X,                        <== CHECK
 //             class="A"                            <== CHECK
 //*
 //*Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z
 //*
 //*  DOMBRPT1 -- GENERATE BATCH REPORTS
 //*
 //*Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z/Z
 //*
 //REPORTS  EXEC PGM=DOMBRPT1,REGION=2048K
 //*
 //STEPLIB  DD DISP=SHR,DSN=?BMC-HLQ?.BBLINK
 //*
 //DOMCUST   DD DISP=SHR,DSN=?BMC-HLQ?.BBCUST
 //DOMPROF   DD DISP=SHR,DSN=?BMC-HLQ?.PROFILE
 //DOMAUTH   DD DISP=SHR,DSN=?BMC-HLQ?.SECURITY
 //DOMHELP   DD DISP=SHR,DSN=?BMC-HLQ?.BBHELP
 //*
 //SYSPRINT DD SYSOUT=*                 ** MESSAGES            **
 //REPORT   DD SYSOUT=*                 ** REPORT OUTPUT       **
 //*
 //DOMBARC  DD DISP=SHR,DSN=?BMC-HLQ?.COPYDIR
 //TRACEIN DD DISP=SHR,DSN=?TRACEDSN? ** SOURCE DATA FOR REPORTS **
 //*
 //TRACEWRK DD DISP=(NEW,PASS),         ** STAGED SORT OUTPUT.IF **
 //            UNIT=3380,               ** DD DUMMY,IT IS ASSUMED **
 //            SPACE=(CYL,(5,5),RLSE),  ** THAT INPUT DATA IS PRE-**
 //            DCB=(RECFM=VBS,LRECL=32760,BLKSIZE=8192) ** SORTED **
 //*
 //*
 //* SORT WORK FILES - ADJUST SIZE RELATIVE TO THE AMOUNT OF INPUT DATA
 //*
 //SORTWK01 DD DISP=(NEW,PASS),UNIT=3380,SPACE=(CYL,(10,10),RLSE)
 //SORTWK02 DD DISP=(NEW,PASS),UNIT=3380,SPACE=(CYL,(10,10),RLSE)
 //SORTWK03 DD DISP=(NEW,PASS),UNIT=3380,SPACE=(CYL,(10,10),RLSE)
 //SORTWK04 DD DISP=(NEW,PASS),UNIT=3380,SPACE=(CYL,(10,10),RLSE)
 //*
 //SYSOUT   DD SYSOUT=*                 ** SORT MESSAGES             **
 //*
 //*SRCTRACE DD SYSOUT=*
 //*
 //*R0001VFL DD DISP=(NEW,PASS),UNIT=3380,SPACE=(CYL,(10,10),RLSE)
 //*R0001VFG DD DISP=(NEW,PASS),UNIT=3380,SPACE=(CYL,(10,10),RLSE)
 //*
 //SYSIN    DD *
//*-------------------------------------------------------------------*
//* REPORT_DD (DDDDDDDD)        - GLOBAL (DEFAULT) REPORT DDNAME
//*-------------------------------------------------------------------*
//* INTERVAL(                   - GLOBAL (DEFAULT) INTERVAL
//*   START(MM/DD/YY,HH:MM:SS)  - INTERVAL STARTING DATE/TIME
//*     END(MM/DD/YY,HH:MM:SS)  - INTERVAL ENDING   DATE/TIME
//*     FOR(DDD,HH:MM:SS)       - INTERVAL DURATION (IF END NOT
//*                                               SPECIFIED
//*      BY(DDD,HH:MM:SS)       - SUB-INTERVAL (PERIOD) DURATIONS
//*     )                       - END OF INTERVAL KEYWORDS
//*-------------------------------------------------------------------*


DOMBRPT1 data sets

The following table describes the data sets that DOMBRPT1 processes.

DDNAME

Description

DCB Attributes

DB2LOAD

Db2 load format data is written to this data set, which can be passed to the #DOMLOAD utility in another step to load the data.

  • RECFM=VB
  • LRECL = 32752
  • BLKSIZE = 32756

DOMAUTH

VSAM data set containing the user profile security values

not applicable

DOMBARC

The VSAM data set that stores the names of the archived trace data sets for use by the archive directory

not applicable

DOMCUST

Sequential data set containing the report customization elements

not applicable

DOMHELP

VSAM data set that contains help members

not applicable

DOMPROF

VSAM data set containing the user profiles

not applicable

R0001VFG (optional)

Data set used to store group records for each report if there are too many records to fit in the internal buffers

You can adjust this value according to the number of selected records and the degree to which the data is reduced.

Example

A report containing accounting information grouped by hour requires fewer group records than a report containing the same information grouped by thread.

If not specified, the file is dynamically allocated by using the space allocation that is specified in your User Profile and the unit that is specified in your installation options.1

not applicable

R0001VFL (optional)

Data set used to hold selected records for each report if there are too many records to fit in the internal buffers

This value can be adjusted according to the number of selected records. If not specified, the file is dynamically allocated by using the space allocation that is specified in your User Profile and the unit that is specified in your installation options.1

not applicable

REPORT

DOMBRPT1 report output

  • RECFM = FBA
  • LRECL = 133
  • BLKSIZE = any multiple of LRECL

SORTWK nn (optional)

Interim data sets for the Sort utility working storage

This data set might be required by a sort program if large amounts of data are being processed. Refer to your site’s sort program documentation for details about the specification of this DD statement.

not applicable

SRCTRACE (optional)

Data set containing a listing of all records found in the TRACEIN file

A single line is generated for each valid record, including an indication of whether the record is used by a report.

  • RECFM = FBA
  • LRECL = 121
  • BLKSIZE = any multiple of LRECL

STEPLIB

Data Collector load library

not applicable

SYSIN

DOMBRPT1 control statements

not applicable

SYSOUT

SORT messages

not applicable

SYSPRINT

DOMBRPT1 messages and statistics

  • RECFM = FBA
  • LRECL = 121
  • BLKSIZE = any multiple of LRECL

TRACEIN

Trace input data sets

The input data sets can be any of the following data sets: trace data set archives, DOMBARC data sets or EXPORT data sets.

not applicable

TRACEWRK

Interim data set for holding the records that were selected and sorted for reporting

The amount of required space increases as the amount of selected data increases. Data is selected if any report requires the record, based on IFCID type, date and time, and qualifiers.

  • RECFM = VBS
  • LRECL = 32760
  • BLKSIZE = 8192

1 Default values are generally sufficient, but can be customized in the Data Collector administration panels. To size the data set:

a Multiply 32 KB (maximum size of each record) by the number of records. The result is a total size of the input records.

b Adjust this figure to the track size and approximate sizes of the initial allocation.

Report generation requires that input data is sorted by Db2 subsystem ID (QHSSSID) and internal timestamp (QWHSSTCK). These fields are located in the standard header section of Db2 records.

The batch report program expects to read input data from DD TRACEIN, sort it appropriately, and stage it to DD TRACEWRK for subsequent input to each requested report.

When the data source is a data set and you expect to run multiple report jobs against the same data, you can avoid repeating the pre-sort process by making the TRACEWRK DD a permanent file and using it as the TRACEIN DD on subsequent runs. Where the TRACEIN file is pre-sorted, omit the TRACEWRK DD or code it as DD DUMMY.

When the data source is the active Data Collector, the TRACEWRK file is not used (that is, there is no I/O operation to the TRACEWRK file). When the data source is the active Data Collector, you must specify the Data Collector as the data source for each of the reports.

If you try to process data that is not in the proper order, and no TRACEWRK file is specified, message BMC24636 is issued (Normalization processing error, input data not in sequence), and report output is not produced.

Note

A batch execution with TRACEWRK missing or dummied does not produce output on the SRCTRACE DD, because the SRCTRACE output is produced during the processing that is eliminated. If you want SRCTRACE output, produce it on the initial run when the TRACEWRK DD is specified and pointing to an actual data set.

This section covers the following statements and parameters:


 

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