DB2 DDF STAT Attributes

Use the DB2 DDF STAT attributes to create situations to monitor Distributed Database Facility statistics.


Aborts Received Number of aborts received from remote location. Valid entry is an integer of up to four digits.

Aborts Sent Number of aborts sent to remote location. Valid entry is an integer of up to four digits.

Agent Elapsed Time Elapsed time at the local site spent processing for the remote site. Valid entry is an integer of up to four digits, in units that represent tenths of seconds.

Block Mode Switches Count of block mode switches performed. Valid entry is an integer of up to four digits.

Blocks Received Blocks received from remote location. Valid entry is an integer of up to four digits.

Blocks Sent Blocks sent to remote location. Valid entry is an integer of up to four digits.

Commits Received Number of commits received from remote location. Valid entry is an integer of up to four digits.

Commits Sent Number of commits sent to remote location. Valid entry is an integer of up to four digits.

Conv Initiated Local Number of conversations initiated by local side of connection. Valid entry is an integer of up to four digits.

Conv Initiated Remote Number of conversations initiated by remote side of connection. Valid entry is an integer of up to four digits.

Conversations Allocated Conversations allocated. Valid entry is an integer of up to four digits.

Conversations DeAllocated Conversations deallocated. Valid entry is an integer of up to four digits.

Conversations Queued Number of conversations queued. Valid entry is an integer of up to four digits.

Coordinator Backouts Received The number of backout requests received from coordinator (2-phase commit only). Valid entry is an integer of up to four digits.

Coordinator Backouts Sent The number of backout requests sent to the coordinator (2-phase commit only). Valid entry is an integer of up to four digits.

Coordinator Commits Received The number of commit requests received from coordinator (2-phase commit only). Valid entry is an integer of up to four digits.

Coordinator Commits Sent The number of commit requests sent to the coordinator (2-phase commit only). Valid entry is an integer of up to four digits.

Coordinator Forgets Sent The number of forget response requests sent to the coordinator (2-phase commit only). Valid entry is an integer of up to four digits.

Data Bytes Received Number of data bytes received from the remote location. Valid entry is an integer of up to four digits.

Data Bytes Sent Number of data bytes sent to the remote location. Valid entry is an integer of up to four digits.

Data Rows Received Number of data rows received from the remote location. Valid entry is an integer of up to four digits.

Data Rows Sent Number of data rows sent to the remote location. Valid entry is an integer of up to four digits.

DB Access CPU Time Database Access agent CPU time at the remote site. Valid entry is an integer of up to four digits, in units that represent milliseconds.

Directed Access Type of directed access. Valid entry is an integer of up to four digits.

Elapsed DB Access Elapsed database access agent time at the remote site. Valid entry is an integer of up to four digits, in units that represent tenths of seconds.

Interval Time Number of seconds since last sample. Valid entry is an integer of up to four digits, in units that represent seconds.

Last Agent Req Received The number of last agent requests received from initiator (2-phase commit only). Valid entry is an integer of up to four digits.

Last Agent Req Sent The number of last agent requests sent to coordinator (2-phase commit only). Valid entry is an integer of up to four digits.

Local Elapsed Time Elapse time, in tenths of a second, for local thread. Valid entry is an integer of up to four digits, in units that represent tenths of seconds.

Maximum Conversations Maximum conversations allowed. Valid entry is an integer of up to four digits.

Message Buffer Rows Message buffer rows. Valid entry is an integer of up to four digits.

Messages Received Number of messages received from remote location. Valid entry is an integer of up to four digits.

Messages Sent Number of messages sent to remote location. 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.

Participant Backouts Received The number of backout requests received from participant (2-phase commit only). Valid entry is an integer of up to four digits.

Participant Backouts Sent The number of backout requests sent to the participant (2-phase commit only). Valid entry is an integer of up to four digits.

Participant Commits Received The number of commit requests received from participant (2-phase commit only). Valid entry is an integer of up to four digits.

Participant Commits Sent The number of commit requests sent to the participant (2-phase commit only). Valid entry is an integer of up to four digits.

Participant Forgets Received The number of forget requests received from participant (2-phase commit only). Valid entry is an integer of up to four digits.

Prepare Requests Received The number of prepare requests received from participant (2-phase commit only). Valid entry is an integer of up to four digits.

Prepare Requests Sent The number of prepare requests sent to participant (2-phase commit only). Valid entry is an integer of up to four digits.

Protocol Used Protocol used for this conversation. Valid entry is an alphanumeric text string, with a maximum length of 12 characters.

Remote Binds Binds from remote access. Valid entry is an integer of up to four digits.

Remote Commit Operations The number of commit operations performed with the remote location as COORD. Valid entry is an integer of up to four digits.

Remote CPU Time CPU time for remote system in milliseconds. Valid entry is an integer of up to four digits, in units that represent milliseconds.

Remote Elapsed Time Elapse time for remote thread in tenths of a second. Valid entry is an integer of up to four digits, in units that represent tenths of seconds.

Remote Indoubt Threads The number of threads that went indoubt with the the remote location as COORD. Valid entry is an integer of up to four digits.

Remote Location Name Name of the remote system to which this thread is connected. Valid entry is an alphanumeric text string, with a maximum length of 12 characters.

Remote LU Name LUNAME of the connection to the remote DB2 system. Valid entry is an alphanumeric text string, with a maximum length of eight characters.

Remote Product Identifier Remote product identifier. Valid entry is an alphanumeric text string, with a maximum length of eight characters.

Remote Rollback Operations The number of rollback operations performed with the remote location as COORD. Valid entry is an integer of up to four digits.

SQL Calls Received Number of SQL calls received from the remote location. Valid entry is an integer of up to four digits.

SQL Calls Sent Number of SQL calls made to the remote location. Valid entry is an integer of up to four digits.

Thread Token Attribute that ties this entry to the owning thread by using the thread token as a foriegn key. 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

Transactions Received Number of Transactions received from remote location. Valid entry is an integer of up to four digits.

Transactions Sent Number of transactions sent to remote location. 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.