Previous Topic: Distributed ActivityNext Topic: Exceptions


EDM Pool

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

Cursor Table Load (%)

Displays the ratio of how many member subsystem load requests required no I/O during the last polling interval. The requested resource was already being loaded.

DBD Load (%)

Displays the ratio of how many member subsystem load requests for the database descriptor (DBD) pages required no I/O during the last polling interval. The requested resource was already being loaded.

DBD Pool Free Pages

Displays the total number of free pages in the DBD pool free chains of member subsystems.

DBD Pool Full Failures

Displays the total number of DBD pool full failures that member subsystems detected during the last polling interval.

DBD Pool Pages

Displays the total number of pages that are allocated to the DBD pools of member subsystems.

DBD Pool Pages Available (%)

Displays the percentage of DBD pool pages from member subsystems that are free for use by other applications.

DBD Used Pages

Displays the number of DBD pool pages from member subsystems that are allocated to DBDs.

Dynamic Statement Load (%)

Displays the percentage of how many requests from the member subsystems the dynamic statement cache satisfies during the last polling interval.

EDM Pool Full Failures

Displays the number of times that member subsystems were unable to find or replace pages in the EDM pool during the last polling interval. All pages were in use.

Package Table Load (%)

Displays the ratio of how many member subsystem load requests for package table pages required no I/O during the last polling interval. The requested resource was already being loaded.

Skeleton Cursor Table Pages

Displays the total number of EDM pool pages from member subsystems that are allocated to skeleton cursor tables (SKCTs).

Skeleton Package Table Pages

Displays the total number of EDM pool pages from member subsystems that are allocated to skeleton package tables (SKPTs).

Skeleton Package Table Pages Available (%)

Displays the percentage of SKPT pages from member subsystems that are free for use by other applications.

Statement Pool Free Pages

Displays the total number of free pages in the EDM statement pools of member subsystems.

Statement Pool Full Failures

Displays the total number of EDM statement pool full failures that member subsystems detected during the last polling interval.

Statement Pool Pages

Displays the total number of pages in the EDM statement pools of member subsystems.

Statement Pool Used Pages

Displays the total number of pages that are used in the EDM statement pools of member subsystems.