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 .

BBPARM data set members

The following table lists sample members in BBPARM that can be used to define product default parameters, initiate background processing, and generate predefined Performance Reporter accounting and statistics reports

BBPARM member name

Description

ACxxxxxx

Performance Reporter SQL to generate accounting reports

SAxxxxxx

Performance Reporter SQL to generate summary accounting reports

STxxxxxx

Performance Reporter SQL to generate statistics reports

SSxxxxxx

Performance Reporter SQL to generate summary statistics reports

BLKDMRW

Contains a sample set of multiple timer-driven service requests

The member name is specified with the BLK parameter in BBPARM member BBIISP00 to activate the requested services when the BBI-SS PAS starts.

BBPTWK00

Contains Db2 application workload definitions

DMRBEXxx

Defines various parameters per Db2 target subsystem (TARGET):

  • You can log all Db2 messages that are issued to the system console from that Db2 subsystem to the BBI-SS PAS journal (LOG)
  • Background sampler exceptions:
    • You can direct exception messages can to the BBI-SS PAS journal (default), to the system console (BMSGWTO for all messages, WTO for an individual message), or to a TSO ID (BMSGTSO for all messages, MTSO for individual messages).
    • You can deactivate (ACTIVE) or control (CYCLES) specific messages.
    • You can set thresholds for individual runaway messages per attach type to determine if a thread is a runaway transaction.

  • Application trace options

    You can set the following application trace options:

    • Trace storage (STORAGE)
    • Size (TRLIM)
    • Duration (TRTIME)
    • Date format (DATEFMT) (For details, see Requesting-a-RECTRACE-report.)
    • Trace LTRAC records (LLIM)
    • Trace package records (PLIM)

    In addition, you can specify the size (TRSIZE) and number (TRBUF) of the detail trace buffers, and several trace logging options.

  • LOCKOUT records

    With the LOCKOUTS parameter, you can limit the number of records kept for the lockout history display. Valid values are from 100 (default) through 4000.

  • Db2 accounting classes

    With the ACCTG keyword, you can specify the accounting classes for data collection.

  • Dynamic targets

Tip

You can specify system symbols for DMRBEXxx parameters that use character string data (such as TARGET, CDC, and TRPREFIX). For more information, seeSystem symbols.

Example 1

Specifying the following entry:

TARGET=<&SYSNAME><&DB2SSID>

Where <&SYSNAME>= SJSC and <&DB2SSID>=DEEO 

Converts the string to the following ALIAS:

TARGET=SJSCDEEO
Example 2

Specifying the following entry:

TRPREFIX=DMRC1.SJS<&SYSCLONE>(2:1)

Where <&SYSCLONE>=(2:1)=C

The string is converted to the following TLDS prefix:

TRPREFIX=DMRC1.SJSC
Example 3

Specifying the following entry:

CDC=DC<&SUFFIX>

Where <&SUFFIX>= C1 

The string is converted to the following CDC SSID:

CDC=DCC1

 

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