Use the DB2 System States attributes to create situations to monitor system-level performance and exception alerts.
Active Stored Procedures The number of stored procedures currently executing. Valid entry is an integer of up to four digits.
Active Triggers The number of triggers currently executing. Valid entry is an integer of up to four digits.
Active User Functions The number of user defined functions currently executing. Valid entry is an integer of up to four digits.
Archive Device The CCUU address of the device that is to be used for mounting the tape. Valid entry is an alphanumeric text string, with a maximum length of four characters.
Archive DSN Dataset name of the archive file being waited on. Valid entry is an alphanumeric text string, with a maximum length of 44 characters.
Archive Volser Volser for tape volume being waited on. Valid entry is an alphanumeric text string, with a maximum length of six characters.
ASIDs Stored Procedures The number of unique active threads executing stored procedures. Valid entry is an integer of up to four digits.
ASIDs User Functions The number of ASIDs executing user functions. Valid entry is an integer of up to four digits.
Current Thread Count Current number of active threads. Valid entry is an integer of up to four digits.
DB Wait Percent Percentage of threads that are waiting for database services. Valid entry ranges from 0.0 to 100.0.
Dist DB Inactive State will be true if this DB2 system is not enabled for the Distributed Data Facility (DDF). Valid entry is an alphanumeric text string, with a maximum length of one character.
Dist Receive Rate DDF Receive bytes per second in units of 1,000. Valid entry is an integer of up to four digits.
Dist Send Rate DDF Send bytes per second in units of 1,000. Valid entry is an integer of up to four digits.
EDM Current Pages Current number of EDM pages that are being used. Valid entry is an integer of up to four digits.
EDM Total Pages Total number of pages allocated for the EDM pool. Valid entry is an integer of up to four digits.
EDM Utilization Current EDM pages divided by total EDM pages. Valid entry is an integer of up to four digits.
Global Trace Active State will be true if this DB2 system currently has the global tracing active. Valid entry is an alphanumeric text string, with a maximum length of one character.
Indoubt Threads Number of threads that are in an INDOUBT status. Valid entry is an integer of up to four digits.
Interval Time Number of seconds since last sample. Valid entry is an integer of up to four digits.
Originnode Node name of the DB2 system. Valid entry is an alphanumeric text string, with a maximum length of 32 characters.
Spare Enumeration Used right now for alignment only. Valid entry is an alphanumeric text string, with a maximum length of one character.
Thread Wait Limit Number of threads waiting because the system thread limit (MAXDBAT) has been reached. Valid entry is an integer of up to four digits.
Thread Wait Lock Number of threads in a suspend state because they are waiting to obtain a lock. Valid entry is an integer of up to four digits.
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
Trigger Depth The depth of the largest trigger stack. Valid entry is an integer of up to four digits.
User Waiting Threads Count of users waiting for threads. Valid entry is an integer of up to four digits.
Wait Tape Mount State will be true if the DB2 system is waiting on a tape mount to recover from an archive log. Valid entry is an alphanumeric text string, with a maximum length of one character.
Questions or comments? Let us know at userdoc@candle.com.
Copyright © 2002 Candle Corporation. All rights reserved. International
rights secured.