DB2 SRM Subsystem Attributes

Use the DB2 SRM Subsystem attributes to create situations to monitor work-load related information associated with a DB2 subsystem.


Abends EOM Rate Number of abends per second due to an End of Memory condition detected per second over the last sampling period. Valid entry is an integer of up to four digits.

Abends EOT Rate Number of abends per second due to an End of Task condition detected per second over the last sampling period. Valid entry is an integer of up to four digits.

Abort Rate Number of abort requests per second over the last sampling period. Valid entry is an integer of up to four digits.

Background Limit System limit on background connections. Valid entry is an integer of up to four digits.

Background Utilization Percent of available threads being used for background connections. Valid entry ranges from 0.0 to 100.0.

Commit Rate Number of commits per second over the last sampling period. Valid entry is an integer of up to four digits.

Create Thread Wait Rate Number of Create Thread requests per second that had to wait over the last sampling period. Valid entry is an integer of up to four digits.

Create Threads Rate Number of threads created per second over the last sampling period. Valid entry is an integer of up to four digits.

Current Background Current number of background connections. Valid entry is an integer of up to four digits.

Current Foreground Current number of foreground connections. Valid entry is an integer of up to four digits.

Current Threads Current number of active threads. Valid entry is an integer of up to four digits.

Delta Abends EOM Number of abends detected due to End of Memory during the last sampling period. Valid entry is an integer of up to four digits.

Delta Abends EOT Number of abends detected due to End of Task during the last sampling period. Valid entry is an integer of up to four digits.

Delta Aborts Number of abort requests during the last sampling period. Valid entry is an integer of up to four digits.

Delta Commits Number of commits during the last sampling period. Valid entry is an integer of up to four digits.

Delta Create Thread Wait Number of times a Create Thread operation had to wait during the last sampling period. Valid entry is an integer of up to four digits.

Delta Create Threads Number of threads created during the last sampling period. Valid entry is an integer of up to four digits.

Delta Identify Number of Identify requests during the last sampling period. Valid entry is an integer of up to four digits.

Delta InDoubt Number of Unit Of Recovery threads that went InDoubt during the last sampling period. Valid entry is an integer of up to four digits.

Delta InDoubt Resolve Number of Unit Of Recovery threads that were InDoubt and resolved during the last sampling period. Valid entry is an integer of up to four digits.

Delta Phase1 Commits Number of phase 1 commits during the last sampling period. Valid entry is an integer of up to four digits.

Delta Phase2 Commits Number of phase 2 commits during the last sampling period. Valid entry is an integer of up to four digits.

Delta Read Only Commits Number of Read Only commits during the last sampling period. Valid entry is an integer of up to four digits.

Delta Signon Number of signon requests during the last sampling period. Valid entry is an integer of up to four digits.

Delta Single Phase Commits Number of single phase commits during the last sampling period. Valid entry is an integer of up to four digits.

Delta Terminate Thread Number of threads terminated during the last sampling period. Valid entry is an integer of up to four digits.

Foreground Limit System limit on foreground connections. Valid entry is an integer of up to four digits.

Foreground Utilization Percent of available threads being used for foreground connections. Valid entry ranges from 0.0 to 100.0.

Identify Rate Number of identify requests per second over the last sampling period. Valid entry is an integer of up to four digits.

InDoubt Rate Number of Unit Of Recovery threads per second that went InDoubt over the last sampling period. Valid entry is an integer of up to four digits.

InDoubt Resolve Rate Number of Unit Of Recovery threads that were InDoubt and resolved per second over the last sampling period. 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.

Max Threads Allowed Total number of concurrent threads allowed. 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.

Phase1 Commit Rate Number of phase 1 commits per second over the last sampling period. Valid entry is an integer of up to four digits.

Phase2 Commit Rate Number of phase 2 commits per second over the last sampling period. Valid entry is an integer of up to four digits.

Read Only Commit Rate Number of read only commits per second over the last sampling period. Valid entry is an integer of up to four digits.

Signon Rate Number of Signon requests per second over the last sampling period. Valid entry is an integer of up to four digits.

Single Phase Commit Rate Number of single phase commits per second over the last sampling period. Valid entry is an integer of up to four digits.

Terminate Thread Rate Number of Terminate Thread requests per second over the last sampling period. Valid entry is an integer of up to four digits.

Thread Utilization Percent of available threads being used. 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 Abends EOM Total number of abends detected due to End of Memory. Valid entry is an integer of up to four digits.

Total Abends EOT Total number of abends detected due to End of Task. Valid entry is an integer of up to four digits.

Total Aborts Total number of abort requests. Valid entry is an integer of up to four digits.

Total Commits Total number of commit requests. Valid entry is an integer of up to four digits.

Total Create Thread Wait Total number of times a Create Thread operation has to wait. Valid entry is an integer of up to four digits.

Total Create Threads Total number of threads created. Valid entry is an integer of up to four digits.

Total Identify Total number of Identify requests. Valid entry is an integer of up to four digits.

Total InDoubt Total number of Unit Of Recovery threads that went InDoubt. Valid entry is an integer of up to four digits.

Total InDoubt Resolve Total number of Unit Of Recovery threads that were InDoubt that were resolved. Valid entry is an integer of up to four digits.

Total Phase1 Commits Total number of phase 1 commits. Valid entry is an integer of up to four digits.

Total Phase2 Commits Total number of phase 2 commits. Valid entry is an integer of up to four digits.

Total Read Only Commits Total number of read only commits. Valid entry is an integer of up to four digits.

Total Signon Total number of signon requests. Valid entry is an integer of up to four digits.

Total Single Phase Commits Total number of single phase commits. Valid entry is an integer of up to four digits.

Total Terminate Thread Total number of thread terminations. Valid entry is an integer of up to four digits.


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