DP Thread GlbBuffer Attributes

Use these attributes to view DP thread global buffer information.

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

Asynch Sec GBP Requests The number of asynchronous IXLCACHE requests for the secondary group buffer pool. (Field name: QBGA2H).

Asynch GBP Requests The number of asynchronous IXLCACHE requests for the primary group buffer pool. (Field name: QBGAHS).

Authorization ID The primary authorization ID from connection or signon. (Field name: QWHCAID). For z/OS operator commands and Db2 system internal agents, the value is SYSOPR. Secondary authorization IDs might be the RACF groups that are 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. If QWHCAID_OFF is not 0, this value is truncated.

Changed Pages Written The number of changed pages written to the group buffer pool. (Field name: QBGASW).

Clean Pages Written The number of clean pages written to the group buffer pool. (Field name: QBGAWC). Db2 writes clean pages for page sets and partitions that are defined with GBPCACHE ALL.

Collection Name The collection name. If QW0148CI_OFF is not 0, this value is truncated. (Field name: QW0148CI).

Compl Checks Suspend The number of completion checks for writes to the secondary group buffer pool that were suspended because a write had not yet completed. (Field name: QBGA2S).

Connection ID The connection name. Not valid on end of memory and reflects the z/OS home ASID connection name. (Field name: QWHCCN).
  • For batch: BATCH
  • For TSO: TSO
  • For QMF: DB2CALL
  • For UTILITY: UTILITY
  • For DB2 INTERNAL: DB2 SUBSYSTEM ID
  • For IMS: IMS-ID
  • For CICS: CICS-ID
  • For RRSAF: RRSAF
For 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'.
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.

Data Sharing Group The data sharing group name.

DB2 Subsystem The Db2 subsystem ID.

DB2 Version The Db2 version.

DSG Member Name The data sharing group member name.

End User The end user's work station user ID. (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.

Explicit X-Invalid The number of explicit cross-invalidations. (Field name: QBGAEX).

Filler The pad field. (Field name: FILLER01).

Getpages GBP-dependent getpages. (Field name: QBGAGG). The number of coupling facility READ requests required because the buffer was marked invalid. Data is returned from the group buffer pool.

Group Buffer Pool ID The group buffer pool ID. (Field name: QBGAGN).

Interval Start The start time of this interval.

Location Name The location name. (Field name: QW0148LN). 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. If QW0148LN_OFF is not 0, this value is truncated.
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.

Originating System The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters. For example, DB91:SYS1:DB2.

Package ID The package ID. If QW0148PN_OFF is not 0, this value is truncated. (Field name: QW0148PN).

PG P-Lock Lock Req The number of all page P-lock lock requests. (Field name: ABGAPLR).

PG P-Lock Lock Susp The sum of all page P-lock lock suspensions. (Field name: ABGAPLS).

PG P-Lock Req Data The number of page P-lock lock requests for data pages. (Field name: QBGAP2).

PG P-Lock Req IX L The number of page P-lock lock requests for index leaf pages. (Field name: QBGAP3).

PG P-Lock REQ SP Map The number of page P-lock lock requests for space map pages. (Field name: QBGAP1).

PG P-Lock Susp Data The number of page P-lock lock suspensions for data pages. (Field name: QBGAS2).

PG P-Lock Susp IX The number of page P-lock lock suspensions for index leaf pages. (Field name: QBGAS3).

PG P-Lock SUSP SP The number of page P-lock suspensions for space map pages. (Field name: QBGAS1).

PG P-Lock Unlock Req The number of page P-lock unlock requests. (Field name: QBGAU1).

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)

QWACFLGS Flags. (Field name: QWACFLGS).

Read Hit Percent Read hit percentage. (Field name: TGBPHIT). The percentage of all reads to the group buffer pool for which the needed data was found and returned to the member.

Read to Write Percent Read-to-write percentage. (Field name: TGBPRWP). The ratio of reads to writes, expressed as a percentage, for the group buffer pool.

Read(NF) Data Return The number of coupling facility reads necessary because the requested page was not found in the buffer pool. Data was returned from the coupling facility. (Field name: QBGAMD).

Read(NF) No Data Ret The number of coupling facility reads necessary because the requested page was not found in the buffer pool. Data was not returned from the coupling facility. (Field name: QBGAMR). If a directory entry does not already exist for the page, an entry is created. See QBGAXR and QBGAXN for an explanation of directory entry assignment.

Read(XI) Data Returned The number of coupling facility read requests required because the buffer was marked invalid. Data is returned from the group buffer pool. (Field name: QBGAXD).

Read(XI) No Data Ret The number of coupling facility read requests required because the buffer was marked invalid. (Field name: QBGAXR). Data is not returned from the group buffer pool and a directory entry is created if it does not already exist. This means another Db2 in the group has R/W interest in the page set or partition.

Read Prefetch The number of coupling facility reads necessary because the requested page was not found in the buffer pool. (Field name: QBGAMN). Data was not returned from the coupling facility, and no directory entry was created. See QBGAXR and QBGAXN for an explanation of directory entry assignment.

Susp for cross-inval The number of suspensions of the coupling facility cross-invalidation service (IXLAXISN) that occurred during waits for cross-invalidation operations to complete. (Field name: QBGAAS).

Thread Type The connecting system type code (in hexadecimal). This field can have a null value. (Field name: QWHCATYP). For example, this field contains a null value for some utilities:
  • 1 = TSO FOREGROUND AND BACKGROUND
  • 2 = DB2 CALL ATTACH
  • 3 = DL/I BATCH
  • 4 = CICS ATTACH
  • 5 = IMS ATTACH BMP
  • 6 = IMS ATTACH MPP
  • 8 = DRDA PROTOCOL
  • 9 = IMS CONTROL REGION
  • A = IMS TRANSACTION BMP
  • B = DB2 UTILITIES
  • C = RRSAF

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.

Unregister Page The number of coupling facility requests to unregister a page. (Field name: QBGADG).

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

Write and Register The number of write and register (WAR) requests. (Field name: QBGAWS).

Write & Register Mult The number of write and register multiple (WARM) requests. (Field name: QBGAWM).