Previous Topic: Log ActivityNext Topic: Subsystem CPU


Misc

These miscellaneous metrics are reported for each monitored DB2 subsystem.

Current Starjoin Pool Size

Displays the current size of the starjoin pool in MB.

Current Starjoin Pool Used (%)

Displays the percentage of the starjoin pool currently in use.

DDF Status

Indicates whether the Distributed Data Facility (DDF) is started (ACTIVE) or not (INACTIVE).

DDF Status Value

Indicates whether the Distributed Data Facility (DDF) is started (1) or not (0).

Dataset Open (%)

Displays the current number of database data sets open as a percentage of the DSMAX DSNZPARM parameter.

Maximum Starjoin Pool Size

Displays the maximum size of the starjoin pool in MB.

Maximum Starjoin Pool Used (%)

Displays the highest percentage of the starjoin pool that is used since DB2 was last started.

RID Pool Failures

Displays the number of times RID list processing failed due to either the lack of RID storage, the lack of RIDs, or too many concurrent processes during the last polling interval.

RLF Status

Indicates whether the resource limit facility (RLF) is started (ACTIVE) or not (INACTIVE).

RLF Status Value

Indicates whether the resource limit facility (RLF) is started (1) or not (0).

Starjoin Pool Allocation Requests

Displays the number of allocation requests in the starjoin pool that are issued during the last polling interval.

Starjoin Pool Failures

Displays the number of failures that a full starjoin pool causes during the last polling interval.

Workfile Shortage 32K

Displays the number of times that space in a 4-KB tablespace was used because space in a 32-KB tablespace was not available during the last polling interval.

Workfile Shortage 4K

Displays the number of times that space in a 32-KB tablespace was used because space in a 4-KB tablespace was not available during the last polling interval.