Thread Accelerator Information attributes

Use these attributes to view thread accelerator information.

ACE Address The agent control element (ACE) (see QWHSACE) of the thread that is reported. The value in QWHSACE is the ACE of the IFI application that requested this trace record (Field name: QW0148AC).

Accel CPU The overall accelerator CPU time (Field name: Q8ACACPU).

Accel ETime The overall accelerator elapsed time (Field name: Q8ACAELA).

Accel WTime The overall accelerator wait time (Field name: Q8ACAWAT).

Accelerator Name The accelerator name (Field name: Q8ACNAME).

Authorization ID The primary authorization ID from connection or signon (Field name: UWHCAID). For z/OS operator commands and Db2 system internal agents, the value is SYSOPR. Secondary authorization IDs might be the RACF groups associated with this primary authorization ID. The SQL ID is initially set to this primary authorization ID. The connection authorization exit and the signon authorization exit can change the primary authorization ID so that it is not the same as the original primary authorization ID (QWHCOPID). Distributed authorization ID translation can also change the primary authorization ID.

Blks Received The number of blocks returned from the accelerator (Field name: Q8ACBLKR).

Blks Sent Number of blocks sent to the accelerator (Field name: Q8ACBLKS).

Bytes Received Number of bytes returned from the accelerator (Field name: Q8ACBYTR).

Bytes Sent Number of bytes sent to the accelerator (Field name: Q8ACBYTS).

Collection Name The collection name (Field name: UW0148CI).

Connection ID The connection name (Field name: QWHCCN). It is not valid on end of memory and reflects the z/OS home address space (ASID) connection name for:
Batch:
'BATCH'
TSO:
'TSO'
QMF
'DB2CALL'
Utility
'UTILITY'
DB2 internal
Db2 subsystem ID
IMS
IMS-ID
CICS
CICS-ID
RRSAF
'RRSAF'
Distributed database access threads:
  • For threads from a Db2 requester, this field contains the connection name of the thread at the requesting location.
  • For threads using the DRDA protocol from a non-Db2 requester, this field contains the constant 'SERVER'.

Connects Number of connections to the accelerator (Db2 field name: Q8ACCONN).

Correlation ID The correlation ID value (Field name: QWHCCV).
  • For batch: JOBNAME
  • For TSO: LOGON-ID
  • For IMS/VS: PST#.PSBNAME
  • For CICS: CONNECTION_TYPE.THREAD_TYPE.THREAD_#.TRAN-ID
  • For RRSAF: CORRELATION-ID value from signon function
  • For threads from a Db2 requester: this field contains the correlation-ID name of the thread at the requesting location.
  • For threads using the DRDA protocol from a non-Db2 requester, this field contains the first 12 characters in the DDM external name (EXTNAM) parameter of the DDM EXCSAT command received as part of the SQL connect.

DB2 Subsystem The Db2 subsystem ID.

DB2 Version The Db2 version.

DSG Member Name The Data Sharing Group (DSG) member name.

Data Sharing Group The Data Sharing Group name.

End User ID The user ID of the end user's workstation (Field name: QWHCEUID). This can be different from the authorization ID used to connect to Db2. This field contains blanks if the client did not supply this information. If QWHCEUID_OFF is not 0, this value is truncated.

Failed Number of failed requests (Field name: Q8ACFAIL).

IP address of accel Accelerator IP address (Field name: Q8ACIPAD).

Interval Start The start time of this interval.

Location Name The location name (Field name: UW0148LN). The location name contains the name of the local location or remote location, depending on where the thread executes a package. The following statements execute locally, regardless of the current package name:
  • COMMIT
  • ROLLBACK
  • SET <HOST VARIABLE> = CURRENT PACKAGE SET
  • SET <HOST VARIABLE> = CURRENT SERVER
For these statements, this field contains the location where the package executes, not the location where the statement executes.
Logical Unit of work ID The logical unit of the work ID (LUWID) as defined for the LU 6.2 interface (Field name: QW0148LU). The LUWID uniquely identifies the thread within the network, and consists of the following:
  • A fully qualified network name (QW0148LM)
  • An LUW instance number (QW0148UV) and an LUW sequence number (see fields below).
It consists of two 8-character fields: QW0148NI and QW0148LM, which together uniquely identify a client system.

MVS System ID The MVS identifier.

Msgs Received Number of messages returned from the accelerator (Field name: Q8ACMSGR).

Msgs Sent Number of messages sent to the accelerator (Field name: QW02542W).

Number Inserts Send The accumulated number of insert statements sent to Analytics Accelerator from Db2 (Field name: Q8ACINSC).

Number Updates Send The accumulated number of update statements sent to Analytics Accelerator from Db2 (Field name: Q8ACUPDC).

Number Deletes Send The accumulated number of delete statements sent to Analytics Accelerator from Db2 (Field name: Q8ACDELC).

Number Drops Send The accumulated number of drop statements sent to Analytics Accelerator from Db2 (Field name: Q8ACDRPC).

Number Creates Send The accumulated number of create statements sent to Analytics Accelerator from Db2 (Field name: Q8ACCRTC).

Number Commits Send The accumulated number of commit statements sent to Analytics Accelerator from Db2 (Field name: Q8ACCMTC).

Number Rollback Send The accumulated number of rollback statements sent to Analytics Accelerator from Db2 (Field name: Q8ACRBKC).

Number Opens Send The accumulated number of open statements sent to Analytics Accelerator from Db2 (Field name: Q8ACOPNC).

Number Row Inserted The accumulated number of rows inserted to Analytics Accelerator from Db2 (Field name: Q8ACROWI).

Number Rows Updated The accumulated number of rows updated on Analytics Accelerator from Db2 (Field name: Q8ACROWU).

Number Rows Deleted The accumulated number of rows deleted on Analytics Accelerator from Db2 (Field name: Q8ACROWD).

Number Row Returned The accumulated number of rows returned by Analytics Accelerator from Db2 (Field name: Q8ACROWC).

Originating System 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 ID The package ID (Field name: UW0148PN).

Plan Name The plan name (Field name: QWHCPLAN). It shows a blank for a Db2 command thread; otherwise:
  • For SPUFI with cursor stability: 'DSNESPCS'
  • For SPUFI with repeatable read: 'DSNESPRR'
  • For TSO: the application plan name
  • For IMS: the application plan name
  • For CICS: application plan name, IMS and CICS commands have a blank plan name.
  • For RRSAF create thread with the collection parameter: '?RRSAF '
  • For QMF: 'DSQPLAN'
  • For Distributed Database Access threads:
    • For threads using the DRDA protocol from a requester, this field contains the plan name that is executed at the requesting location.
    • For threads using the DRDA protocol from a non-Db2 requester or from a Db2 2.3 requester, this field contains the constant 'DISTSERV'.
  • For binding: 'DSNBIND' (system plan)
  • For utility: 'DSNUTIL ' (system plan)
  • For authorization: 'ACT' + X'0000000000' (system plan)
  • For unallocated threads and miscellaneous Db2 system service tasks: 'BCT' + X'0000000000' (system plan)
  • For startup: 'STARTCT' + X'00' (system plan)

Product ID Accelerator product ID. (Field name: Q8ACPRID).

QWACFLGS Flags (Field name: QWACFLGS).

Requests Number of requests to the accelerator (Field name: Q8ACREQ).

Rows Received Number of rows returned from the accelerator (Field name: Q8ACROWR).

Rows Sent Number of rows sent to the accelerator (Field name: Q8ACROWS).

Stmts Expired Delay Prot The accumulated number of statements with wait time for delay protocol expired (Field name: Q8ACNWDP).

SVCS CPU Accelerator services cpu time (Field name: Q8ACSCPU).

SVCS ETime Accelerator services elapsed time (Field name: Q8ACSELA).

TCP/IP CPU Accelerator services TCP/IP CPU time (Field name: Q8ACTCPU).

TCP/IP ETime Accelerator services TCP/IP elapsed time. This elapsed time is a subset of accounting class 3 wait time for accelerator services (Field name: Q8ACTELA).

Thread Type The connecting system type code (in hexadecimal). This field can have a null value. For example, this field contains a null value for some utilities (Field name: QWHCATYP).

Timeout Number of timed-out requests (Field name: Q8ACTOUT).

Transaction Name The transaction or application name that the end user is running (Field name: QWHCEUTX). This identifies the application that is currently running, not the product that is used to run the application. This field contains blanks if the client did not supply this information.

Wait Time Delay Protocol The accumulated time waited for delay protocol (Field name: Q8ACTWDP).

Workstation Name The end user's workstation name. This field contains blanks if the client did not supply this information (Field name: QWHCEUWN).