Previous Topic: Log ActivityNext Topic: Workload


Misc

These miscellaneous metrics are reported for each monitored DB2 Data Sharing Group:

Current Starjoin Pool Size

Displays the combined size of starjoin pools (in MB) across all member subsystems.

Current Starjoin Pool Used (%)

Displays the combined percentage of starjoin pool space currently in use across all member subsystems.

RID Pool Failures

Displays the combined number of times the RID list processing failed during the last polling interval across all member subsystems. The following reasons are possible:

Starjoin Pool Allocation Requests

Displays the combined number of starjoin pool allocation requests made during the last polling interval across all member subsystems.

Starjoin Pool Failures

Displays the combined number of failures because of a full starjoin pool during the last polling interval across all member subsystems.

Workfile Shortage 32K

Displays the combined number of times the following conditions occurred during the last polling interval across all member subsystems: Space in a 4-KB tablespace was used because space in a 32-KB tablespace was not available.

Workfile Shortage 4K

Displays the combined number of times the following conditions occurred during the last polling interval across all member subsystems: Space in a 32-KB tablespace was used because space in a 4-KB tablespace was not available.