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 Total number of EDM pages currently available. Valid entry is an integer of up to four digits.

Available Percentage Percent of EDM that is currently available. Valid entry ranges from 0.0 to 100.0.

CT Load Rate Number of Cursor Table loads from DASD per second. Valid entry is an integer of up to four digits.

CT Request Rate Number of Cursor Table requests per second. Valid entry is an integer of up to four digits.

Cursor Table Pages Total number of EDM pages currently in use for Cursor Tables. Valid entry is an integer of up to four digits.

Cursor Table Percentage Percent of EDM that is currently in use for Cursor Tables. Valid entry ranges from 0.0 to 100.0.

Database Descriptor Pages Total number of EDM pages currently in use for database descriptors. Valid entry is an integer of up to four digits.

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

DBD Load Rate Number of database descriptor loads from DASD per second. Valid entry is an integer of up to four digits.

DBD Request Rate Number of database descriptor requests per second. Valid entry is an integer of up to four digits.

Delta CT Loads Cursor Table loads from DASD during the last interval. Valid entry is an integer of up to four digits.

Delta CT Requests Cursor Table requests during the last interval. Valid entry is an integer of up to four digits.

Delta DBD Loads DBD loads from DASD during the last interval. Valid entry is an integer of up to four digits.

Delta DBD Requests Database descriptor requests during the last interval. Valid entry is an integer of up to four digits.

Delta Dynamic SQL Loads Dynamic SQL loads from DASD during the last interval. Valid entry is an integer of up to four digits.

Delta Dynamic SQL Requests Dynamic SQL requests during the last interval. Valid entry is an integer of up to four digits.

Delta Failures EDM Full Total number of failures due to the EDM pool being full during the last interval. Valid entry is an integer of up to four digits.

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

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

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

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

Delta PT Loads Package Table loads from DASD during the last interval. Valid entry is an integer of up to four digits.

Delta PT Requests Package Table requests during the last interval. Valid entry is an integer of up to four digits.

Dynamic SQL Cache Total number of EDM pages currently used for dynamic SQL cache. Valid entry is an integer of up to four digits.

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

Dynamic SQL Load Rate Number of Dynamic SQL loads from DASD per second. Valid entry is an integer of up to four digits.

Dynamic SQL Request Rate Number of Dynamic SQL requests per second. Valid entry is an integer of up to four digits.

Failure Rate Number of failures per second due to the EDM pool being full. Valid entry is an integer of up to four digits.

Free Pages Total number of EDM pages currently on free queue. Valid entry is an integer of up to four digits.

Free Percentage Percent of EDM that is currently on the free queue. Valid entry ranges from 0.0 to 100.0.

Interval Time Number of seconds since last sample. Valid entry is an integer of up to four digits.

InUse Pages Total number of EDM pages currently in use. Valid entry is an integer of up to four digits.

InUse Percentage Percent of EDM that is currently in use. Valid entry ranges from 0.0 to 100.0.

Originnode Node name of the DB2 system. Valid entry is an alphanumeric text string, with a maximum length of 32 characters.

Package Table Pages Total number of EDM pages currently in use for Package Table. Valid entry is an integer of up to four digits.

Package Table Percentage Percent of EDM that is currently in use for Package Table. Valid entry ranges from 0.0 to 100.0.

PT Load Rate Number of Package Table loads from DASD per second. Valid entry is an integer of up to four digits.

PT Request Rate Number of Package Table requests per second. Valid entry is an integer of up to four digits.

Skeleton Cursor Table Pages Total number of EDM pages currently used for skeleton cursor tables. Valid entry is an integer of up to four digits.

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

Skeleton Package Table Pages Total number of EDM pages currently used for skeleton package tables. Valid entry is an integer of up to four digits.

Skeleton Package Table Percentage Percent 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. The timestamp format for SCAN and STR functions is CYYMMDDHHMMSSmmm (as in 1020315064501000 for 03/15/02 06:45:01) where:

C = Century (0 for 20th, 1 for 21st)

Y = Year

M = Month

D = Day

H = Hour

M = Minute

S = Second

m = millisecond

Total CT Loads Total number of Cursor Table loads from DASD. Valid entry is an integer of up to four digits.

Total CT Requests Total number of Cursor Table requests. Valid entry is an integer of up to four digits.

Total DBD Loads Total number of database descriptor loads from DASD. Valid entry is an integer of up to four digits.

Total DBD Requests Total number of database descriptor requests. Valid entry is an integer of up to four digits.

Total Dynamic SQL Loads Total number of Dynamic SQL loads from DASD. Valid entry is an integer of up to four digits.

Total Dynamic SQL Requests Total number of Dynamic SQL requests. Valid entry is an integer of up to four digits.

Total Failures EDM Full Total number of failures due to the EDM pool being full. Valid entry is an integer of up to four digits.

Total Pages Total number of pages assigned to EDM pool. Valid entry is an integer of up to four digits.

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

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

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

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

Total PT Loads Total number of Package Table loads from DASD. Valid entry is an integer of up to four digits.

Total PT Requests Total number of Package Table requests. Valid entry is an integer of up to four digits.


Questions or comments? Let us know at userdoc@candle.com.
Copyright © 2002 Candle Corporation. All rights reserved. International rights secured.