Distributed Thread Detail Attributes

Use the Distributed Thread Detail attributes to create situations that monitor VTAM APPC conversations and TCP/IP conversations of a distributed (DDF) thread.

Aborts Received The number of rollback requests received from the requesting location (single-phase commit operators only). This value is maintained at the server location.

Aborts Sent The number of rollback requests sent to the server location (single-phase commit operations only). This value is maintained at the requesting location.

Ace Address The ace address.

Agent Address The agent address.

AGNT ASID The address space ID (ASID) of the agent.

Agent TCB Address The Agent TCB address.

Allocations Received The number of create database access thread (DBAT) requests received by the server DBAT from the requester allied agent. This value is maintained by the server DBAT and is always 1.

Allocations Sent The number of successful conversation allocations. All allocation attempts, whether successful or not, are counted in QLACCNVS. The difference between QLACCNVS and QLACCNVA can be used to identify a session resource on resource constraint problem.

Application Directed Access If using application directed access, this is on.

Authorization ID The authorization ID.

Authorization ID (Unicode) The authorization ID.

Backouts Received The number of backout requests received from the coordinator (two-phase commit operations only).

Backouts Received from Coordinator The number of backout responses received from the participant (two-phase commit operations only). This indicates that the participant voted no to the prepare request.

Backouts Sent The number of backout requests sent to the participant (two-phase commit operations only).

Backouts Sent to Coordinator The number of backout responses sent to the coordinator (two-phase commit operations only). This indicates that the participant voted no to the prepare request.

Binds The number of static SQL statements that were bound for remote access (DB2 private protocol only). This value is maintained at the requester location.

Block Mode Switch Count The number of times a switch was made from continuous block mode to limited block mode (DB2 private protocol only).

Blocks Received The number of blocks received using block fetch. This value is maintained at the requester location.

Blocks Sent The number of blocks transmitted using block fetch. This value is maintained at the server location.

Bytes Received The number of bytes of data received from the server location. More bytes of data might be sent from the server location than are received by the requester because of the way SQL statements are processed internally.

Bytes Sent The number of bytes of data sent to the requester location. This value is maintained at the server location.

Collection The package collection ID.

Collection (Unicode) The package collection ID.

Commits Performed The number of commit operations performed with the remote location as the coordinator (two-phase commit operations only).

Commits Received The number of commit requests received from the requester location (single-phase commit operations only). This value is maintained as the server location.

Commits Received Phase 2 The number of commit requests received from the coordinator (two-phase commit operations only).

Commits Sent The number of commit requests sent to the server location (single-phase commit operations only). This value is maintained at the requester location.

Commits Sent Phase 2 The number of commit requests sent to the participant (two-phase commit operations only).

Distributed Thread Detail Attributes Identifies the connection of an application to a DB2 system.

It is an alphanumeric text string, with a maximum length of eight characters.

Distributed Thread Detail Attributes The type of connection associated with the thread.

Conversation ID The conversation ID.

Conversations Allocated The number of successful conversation allocations.

Conversations Deallocated The number of conversations terminated.

Conversations Initiated Location The number of conversations that were initiated from the requester to the server location. This value is updated as the server location.

Conversations Initiated Thread The number of conversations that were initiated from the requester location. This value is maintained at the requester.

Conversations Queued The number of conversation requests queued by DDF that are waiting for allocation. This value is maintained at the requestor location. If the value is a large number, you might want to increase the limit for the number of conversations. See SE for the number of conversations.

Conversation Status The conversation status.

Correlation ID The correlation ID.

DBAT CPU The database access agent CPU time at the serving location.

DBAT Elapsed The elapsed time at the requester. It includes the total of DB2 and network time (DB2 field name: ADDSELRQ).

DB2 ID The DB2 subsystem ID.

End User ID The user ID of the workstation end user. This user ID can be different from the authorization ID used to connect to DB2. This field contains blanks if the client does not supply this information (DB2 field name: QWHCEUID).

Forgets Received The number of forget responses received from the participant (two-phase commit operations only). This indicates that the participant was read only.

Forgets Sent The number of forget responses sent to the coordinator (two-phase commit operations only). This indicates that the participant was read only.

From Location The location from.

Host Name The host name.

Interval Start The start time of this interval.

IP Address The TCP/IP address (prior to DB2 9).

Last Agents Received The number of last agent requests received from the initiator (two-phase commit operations only). This counter is incremented when the DB2 server is receiving a last agent request from its upstream partner.

Last Agents Sent The number of last agent requests sent to the coordinator (two-phase commit operations only).

Last Appc Request The conversation last appc request issued.

Last Appc Qualifier Used The conversation last appc qual issued.

Location The requesting location.

Location (Unicode) The requesting location.

Logical Unit Name The conversation Logical Unit name.

Maximum Conversations The largest number of conversations open at any time.

Message Buffer Rows The number of rows transmitted in message buffers using block fetch. This field is maintained at both the requester and the server locations.

Messages Received The number of messages received from the location. More messages might be sent from the server location than are received by the requester because of the way SQL statements are processed internally. This value is maintained internally.

Messages Sent The number or messages sent to the location. A message, as defined by VTAM, is a group of characters and control IT sequences transferred as an entity. This value is maintained at the location where the messages originated.

MVS ID The MVS system identifer.

Number In Doubt The number of threads that became INDOUBTz with the remote location as the coordinator (two-phase commit operations only). This indicates that communication with the coordinator was lost.

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 DBRM The package DBRM name.

Package DBRM (Unicode) The package DBRM name.

Plan The plan name.

Port The TCP/IP port number.

Prepares Received The number of prepare requests received from the coordinator (two-phase commit operations only).

Prepares Sent The number of prepare requests sent to the participant (two-phase commit operations only).

Product Name Shows the ACCRDB PRID parameter of the DDM command, where "ACCRDB" is the product specific ID of the "access relational database" and "PRID" is the product ID of the requester. The value is zero if the record is written at the application requester location.

Protocol Used The protocol used.

Remote Elapsed Time The remote elapsed time.

Remote Wait Time The time spent waiting for remote response.

Request Commits Received The number of request commit responses received from te participant (two-phase commit operations only).

Request Commits Sent The number of request commit responses sent to the coordinator (two-phase commit operations only).

Rollbacks Remote The number of rollback operations performed with the remote location as the coordinator (two-phase commit operations only).

Row Count The row counter.

Rows Received The number of rows of data retrieved from the server location (the count does not include either the SQLDA or SQLCA if they are transmitted). This value is maintained at the requester location.

Rows Send The number of rows of data sent to the requester location (includes SQLDA). This value is maintained at the server location.

Service Name The EXSCAT SRVNAM parameter.

Session ID The session ID.

Srvclsnm The EXSCAT SRVNAM parameter.

SQL Calls Received The number of SQL statements received from the requester.

SQL Calls Sent The number of SQL statements sent to the server. This value is maintained at the requester location.

System Access System access.

Thread Type The thread type is DBACCESS/ALLIED.

Time Since Last VTAM Request The time since the last VTAM request was issued.

Transaction ID The transaction ID at the workstation.

Uniqueness Value The instance number: When concatenated with the fully qualified network name, it uniquely identifies a distributed thread (DB2 field name: QWHSLUUV).

Uniqueness Value 2 The DB2 thread uniqueness value. For internal use.

VTAM Logmode The VTAM log mode entry name in use by the session.

VTAM Luname The location Logical Unit name.

Workstation ID The workstation ID.