CA APM Cross-Enterprise Metrics › DB2 z/OS Subsystems Metrics › EDM Pool

EDM Pool

These EDM pool metrics are reported for each monitored DB2 subsystem.

Cursor Table Load (%)

Displays the ratio of how many load requests resulted in no I/O due to the requested resource already being loaded during the last polling interval.

DBD Load (%)

Displays the ratio of how many load requests for DBD (database descriptor) pages resulted in no I/O due to the resource already being loaded during the last polling interval.

DBD Pool Free Pages

Displays the number of free pages in the DBD pool free chain.

DBD Pool Full Failures

Displays the number of times an application has a DBD loaded into the DBD pool, but was unable to do so because all pages in the DBD pool were in use during the last polling interval.

DBD Pool Pages

Displays the number of pages that are allocated to the DBD pool.

DBD Pool Pages Available (%)

Displays the percentage of DBD Pool pages that are free for use by other applications.

DBD Used Pages

Displays the number of pages of the DBD pool that are allocated to the database descriptors (DBDs).

Dynamic Statement Load (%)

Displays the percentage of how many requests for dynamic statements are satisfied using statements already contained within the dynamic statement cache during the last polling interval.

EDM Pool Full Failures

Displays the number of times that DB2 was unable to find or replace pages in the EDM pool because all pages were in use during the last polling interval.

Package Table Load (%)

Displays the ratio of how many load requests for package table pages resulted in no I/O due to the resource already being loaded during the last polling interval.

Skeleton Cursor Table Pages

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

Skeleton Package Table Pages

Displays the number of pages of the EDM (environmental descriptor manager) pool that are allocated to skeleton package tables (SKPTs).

Skeleton Package Table Pages Available (%)

Displays the percentage of skeleton package table pages that are free for use by other applications.

Statement Pool Free Pages

Displays the number of free pages in the EDM statement pool.

Statement Pool Full Failures

Displays the number of EDM statement pool full failures encountered during the last polling interval.

Statement Pool Pages

Displays the total number of pages in the EDM statement pool.

Statement Pool Used Pages

Displays the number of pages used in the statement pool.