Skip to Content

Default language.

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 ge rate 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.

  • LLIM parameter behavior in DMRBEXxx member

    • The LLIM parameter controls the maximum number of records shown in the TRLTRAC view.
    • The default value for the LLIM parameter is 25,000.
    • The LLIM value is configured per Db2 instance.
    • Within the DMRBEXxx member:
      • If the LLIM parameter is specified under a target, that value is used for that specific target.
      • If the LLIM parameter is defined before a target, it's treated as a global value and is applied to all targets unless it's overridden under a target.

  • PLIM parameter behavior in DMRBEXxx member

    • The PLIM parameter controls the maximum number of records shown in the PKGLIST view.
    • The default value for the PLIM parameter is 20,000.
    • The PLIM value is configured per Db2 instance.
    • Within the DMRBEXxx member:
      • If the PLIM parameter is specified under a target, that value is used for that specific target.
      • If the PLIM parameter is defined before a target, it's treated as a global value and is applied to all targets unless it's overridden under a target.

  • 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
    • You can activate dynamic targeting. For more information, see Setting-up-dynamic-targets.
    • You can specify an alias name for dynamic targets.

Updating record limits for TRLTRAC and PKGZ views

You can update the record limits for TRLTRAC and PKGZ directly from the command line by following these steps:

  1. Enter the XTSETLIM command on the command line.
  2. In the pop-up window, specify the desired record limit values for TRLTRAC and PKGZ.
  3. Select END to save your changes and exit the panel.
Warning
Important

These changes apply only to the current PAS session. The limits are reset when the PAS is recycled.

Success

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.

Information
Example 1

Specifying the following entry:

TARGET=<&SYSNAME><&DB2SSID>

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

Converts the string to the following ALIAS:

TARGET=SJSCDEEO
Information
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
Information
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*

BMC AMI Ops Monitor for Db2 13.1