DB2 SRM EDM Attributes

Use the DB2 SRM EDM attributes to create situations to monitor the Environmental Descriptor Manager (EDM) pool activity connected with DB2.

Available Pages The total number of EDM pages currently available. It is zero for DB2 9 or later.

Available Percentage The percentage of EDM that is currently available. Valid entry ranges from 0.0 to 100.0. It is zero for DB2 9 or later.

Cursor Table Load Rate The number of Cursor Table loads from DASD per second.

Cursor Table Request Rate The number of Cursor Table requests per second.

Cursor Table Pages The total number of EDM pages currently in use for Cursor Tables. It is zero for DB2 10 or later.

Cursor Table Percentage The percentage of EDM that is currently in use for Cursor Tables. Valid entry ranges from 0.0 to 100.0. It is zero for DB2 10 or later.

Database Descriptor Pages The total number of EDM pages currently in use for database descriptors.

Database Descriptor Percentage The percentage of EDM that is currently in use for database descriptors. Valid entry ranges from 0.0 to 100.0.

DB2 Version The version of the DB2 system.

DBD Load Rate The number of database descriptor loads from DASD per second.

DBD Request Rate The number of database descriptor requests per second.

Delta Cursor Table Loads The Cursor Table loads from DASD during the last interval.

Delta Cursor Table Requests The Cursor Table requests during the last interval.

Delta DBD Loads The DBD loads from DASD during the last interval.

Delta DBD Requests The database descriptor requests during the last interval.

Delta Dynamic SQL Loads The dynamic SQL loads from DASD during the last interval.

Delta Dynamic SQL Requests The dynamic SQL requests during the last interval.

Delta Failures EDM Full The total number of failures because the EDM pool was full during the last interval.

Delta Percent Cursor Table Loads The percentage of Cursor Table loads from DASD over last interval. Valid entry ranges from 0.0 to 100.0.

Delta Percent DBD Loads The percentage of DBD loads from DASD over last interval. Valid entry ranges from 0.0 to 100.0.

Delta Percent Dynamic SQL Loads The percentage of Dynamic SQL loads from DASD over last interval. Valid entry ranges from 0.0 to 100.0.

Delta Percent Package Table Loads The percentage of Package Table loads from DASD over last interval. Valid entry ranges from 0.0 to 100.0.

Delta Package Table Loads The Package Table loads from DASD during the last interval.

Delta Package Table Requests The Package Table requests during the last interval.

Dynamic SQL Cache The total number of EDM pages currently used for dynamic SQL cache.

Dynamic SQL Cache Percentage The percentage of EDM that is currently used for Dynamic SQL caching. Valid entry ranges from 0.0 to 100.0.

Dynamic SQL Load Rate The number of Dynamic SQL loads from DASD per second.

Dynamic SQL Request Rate The number of Dynamic SQL requests per second.

Failure Rate The number of failures per second because the EDM pool is full.

Free Pages The total number of EDM pages (DB2 9 or below) or DBD pages (DB2 10 or later) that are currently on the free queue.

Free Percentage The percentage of EDM (DB2 9 or below) or DBD (DB2 10 or later) that is currently on the free queue. Valid entry ranges from 0.0 to 100.0.

Interval Time The number of seconds since last sample.

In Use Pages The total number of EDM pages (DB2 9 or below) or DBD pages (DB2 10 or later) that are currently in use.

In Use Percentage The percentage of EDM (DB2 9 or below) or DBD (DB2 10 or later) that is currently in use. Valid entry ranges from 0.0 to 100.0.

Originating System ID The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Package Table Load Rate The number of Package Table loads from DASD per second.

Package Table Pages The total number of EDM pages currently in use for Package Table. It is zero for DB2 10 or later.

Package Table Percentage The percentage of EDM that is currently in use for Package Table. Valid entry ranges from 0.0 to 100.0. It is zero for DB2 10 or later.

Package Table Request Rate The number of Package Table requests per second.

Skeleton Cursor Table Pages The total number of EDM pages currently used for skeleton cursor tables.

Skeleton Cursor Table Percentage The percentage of EDM that is currently used for skeleton cursor tables. Valid entry ranges from 0.0 to 100.0.

Skeleton Package Table Pages The total number of EDM pages currently used for skeleton package tables.

Skeleton Package Table Percentage The percentage of EDM that is currently used for skeleton package tables. Valid entry ranges from 0.0 to 100.0.

Time The date and time, as set on the monitored system, indicating the instance when the agent collects information.

Total Cursor Table Loads The total number of Cursor Table loads from DASD.

Total Cursor Table Requests The total number of Cursor Table requests.

Total DBD Loads The total number of database descriptor loads from DASD.

Total DBD Requests The total number of database descriptor requests.

Total Dynamic SQL Loads The total number of Dynamic SQL loads from DASD.

Total Dynamic SQL Requests The total number of Dynamic SQL requests.

Total Failures EDM Full The total number of failures because the EDM pool is full.

Total Pages The total number of pages assigned to EDM pool (DB2 9 or below) or DBD pool (DB2 10 or later).

Total Percent Cursor Table Loads The percentage of all Cursor Table loads from DASD. Valid entry ranges from 0.0 to 100.0.

Total Percent DBD Loads The percentage of all DBD loads from DASD. Valid entry ranges from 0.0 to 100.0.

Total Percent Dynamic SQL Loads The percentage of all Dynamic SQL loads from DASD. Valid entry ranges from 0.0 to 100.0.

Total Percent Package Table Loads The percentage of all Package Table loads from DASD. Valid entry ranges from 0.0 to 100.0.

Total Package Table Loads The total number of Package Table loads from DASD.

Total Package Table Requests The total number of Package Table requests.