Thread SQL Count attributes

Use these attributes to view the thread SQL count.

DB2 Subsystem The Db2 subsystem ID.

DB2 Version The Db2 version.

Data Sharing Group The Data Sharing Group name.

Data Sharing Member The Data Sharing Group member name.

Field Name The data field name.

Field Value The data value.

Interval Start The start time of this interval.

MVS System ID The MVS identifier.

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.

QW0148AC 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).

QW0148LU 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.

QWHCATYP 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).

QWHCCN 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'.

QWHCCV 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.

QWHCEUID 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.

QWHCEUTX 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.

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

QWHCPLAN 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)

Sequence Number The thread long name descriptions.

QW0148CI: Collection name.
QW0148LN: Location name. The location name contains the name the local location or remote location, depending on where the thread executes a package.
QW0148PN: Package ID.
QWHCEUID: The end user's work station user ID. 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.
QWHCEUTX: The transaction or application name that the end user is running. 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.
QWHCEUWN: The end user's workstation name. This field contains blanks if the client did not supply this information.
QWHCTCXT: Trusted context name.
QWHCROLE: Role name that is associated with the authorization.
QWHCAID: Primary authorization ID from connection or signon.
QWHCOPID: Initial primary authorization ID.
QMDASUFX: Account suffix.
QMDAACCT: The z/OS accounting string associated with the Db2 SQL application's z/OS address space.
QWHCCTKN: Correlation token.
QWHCOAUD: The original application user ID.

UW0148CI The collection name (Field name: UW0148CI).

UW0148LN 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.

UW0148PN The package ID (Field name: UW0148PN).

UWHCAID 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.