All Threads attributes

Use the All Threads attributes to create situations to monitor thread activity including Db2 thread activity that originates from connected IMS or CICS subsystems.

Aborts The number of abort requests.

Ace Address The Db2 thread ACE address for internal use.

Agent Address The address of the agent in Db2 associates all processes that are involved in a Db2 unit of work.

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

Agent TCB Address The z/OS Task Control Block that is associated with this Db2 thread.

Authorization ID The primary authorization ID from connection or sign-on that identifies the execution privileges an application has to a Db2 object or service. It is an alphanumeric text string with a maximum of 8 characters.

Authorization ID (Unicode) The primary authorization ID from connection or sign-on that identifies the execution privileges an application has to a Db2 object or service. It is an alphanumeric text string with a maximum of 8 characters.

Begin Time Beginning store clock value (STCK) for the period covered by this accounting record. You can determine the elapsed time of the application by subtracting this field from QWACESC (ending store clock value). Threads that do not terminate (such as CICS primed threads and ims wait-for-input message regions) can have an ending clock value that includes the time the thread was inactive and waiting to perform work.

Bytes Sent The number of bytes of data sent to the requester location.

Cancel Command The command string needed to cancel a thread. You can use Take Action with this attribute to cancel a thread: The format is "src CANCEL THREAD(nnnnnn)", where src is the subsystem recognition character and nnnnnn is the thread token.

CICS MVS ID The CICS MVS ID.

Collection ID This field is blank for DBRM. It is an alphanumeric text string, with a maximum of 18 characters.

Collection ID (Unicode) The collection ID. This field is blank for DBRM. It is an alphanumeric text string, with a maximum of 128 characters.

Commits The number of successful phase 2 or single-phase commit (sync) requests. Valid value is an integer in the range 0-999 commits.

All Thread Attributes Identifies the connection of an application to a Db2 system.

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

All Thread Attributes The type of connection associated with the thread.

Conversations The number of conversations that were initiated from the requester location.

Correlation ID The correlation between an application and the connection to a Db2 system. It is an alphanumeric text string, with a maximum of 12 characters. For example: DLKEX212.

CP CPU Rate The central processor CPU rate.

Current Period The service class period number in goal mode.

Database Access CPU The database access agent CPU time. This value is calculated by accumulating the amount of CPU time spent by the database access thread at the Db2 server each time a request message is processed.

Database Access Time The timestamp of last send or receive in distributed database access.

Db2 ID The Db2 subsystem ID.

Db2 Status The current Db2 status of the thread. It is an alphanumeric text string, with a maximum length of 12 characters.

Valid values are:

Distributed Allied Elapsed Time The elapsed time for this thread executing on distributed host.

Elapsed Time The total amount of elapsed time since thread creation or Db2 sign-on. Valid value is an integer in the range 0-99999999 seconds.

Elapsed Per Commit The average amount of elapsed time for each database commit performed.

Enclave CP CPU Time The central processor CPU time used by each thread that is associated with an enclave token.

Enclave CPU Time The enclave CPU time.

Enclave Token The ID assigned by the z/OS workload manager for this enclave. A z/OS enclave lets each thread have its own performance objective. Using z/OS workload management (WLM) support, you can establish z/OS performance objectives for individual DDF server threads.

Enclave Token Unused This field is unused.

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 (Field name: QWHCEUID).

Get Page The number of getpage requests.  This field counts successful requests for pages for queries that are processed in parallel and both successful and unsuccessful requests for pages for queries that are not processed in parallel. Valid value is an integer in the range 0-99999 pages.

Get Page 64 The number of getpage requests.  This field counts successful requests for pages for queries that are processed in parallel and both successful and unsuccessful requests for pages for queries that are not processed in parallel. Valid value is an integer in the range 0-999999999 pages.

Get Page Per Read The ratio of requested pages that resulted in actual I/O versus being found in a buffer. The read I/O count divided by Get Page count.

Get Page Per Read 64 The ratio of requested pages that resulted in actual I/O versus being found in a buffer. The read I/O count divided by Get Page count.

IIP CPU The accumulated CPU time consumed while executing on an IBM zIIP in all environments.

IIP In-Db2 CPU The amount of time that the In Db2 CPU has been running on a zIIP processor.

In Db2 IIP CPU The total amount of CPU time that Db2 has accumulated for a thread in the zIIP processor. Valid value is an integer in the range 0-99999999 seconds.

In Db2 CP CPU Time The CP CPU time accumulated in Db2 when the SQL statement exit from Db2.

In Db2 Per Commit The average amount of in-Db2 CPU time used between each commit.

In Db2 Time The elapsed time accumulated in Db2 when the SQL statement exit from Db2.

Interval Start The start time of the interval.

Job Name The job name that is associated with a thread.

Local Elapsed Time The elapsed time, in tenths of a second, for local thread (in units that represent tenths of seconds).

Location The requesting location.

Location (Unicode) The requesting location.

Logical Unit Name The LUNAME of the connection to the remote Db2 system.

Messages Sent The number of messages sent to remote location.

MVSID The MVS system identifier.

Original Authorization ID The Db2 original Authorization ID of the thread. It is an alphanumeric text string, with a maximum length of 8 characters.

Original Authorization ID (Unicode) The Db2 original Authorization ID of the thread. It is an alphanumeric text string, with a maximum length of 8 characters.

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 Name Identifies the package name with which a thread is associated. It is an alphanumeric text string, with a maximum of 8 characters.

Package Name (Unicode) Identifies the package name with which a thread is associated. It is an alphanumeric text string, with a maximum of 8 characters.

Parallel Indicator The thread parallelism indicator.

Parent Ace The token used to correlate parallel task or utility subtask records with the records of the originating task or main utility task. For a record that is issues from a parallel task or utility subtask this field contains a token that is equal to the agent control element (ACE) of the originating task or main utility task. Otherwise, the value in this field is zero.

Performance Index This field is related to the z/OS Workload manager. A Performance Index less than one is an indication that the goal for this service class period is being exceeded. The service class period may be considered as a "donor", giving up CPU or pageable storage for other more important service class periods on the system. A Performance Index greater than one is an indication that the goal for this service class period is not being met. Depending on the importance, this Service class period may be considered for additional services to meet the defined goal.

Plan The name of an application plan that Db2 produces during the bind process and uses for processing SQL statements during execution. It is an alphanumeric text string, with a maximum of 8 characters. For example, PLANLCK2 is the name of an application plan. *SYSTEM* indicates Db2 subsystem-generated threads that own or are waiting on a lock.

Prefetch Requests The number of prefetch requests issued per second over the last interval.

Remote CPU The database access agent CPU time at the remote location.

Remote Elapsed The elapsed database access agent time at the remote location.

Request Type The request type for a ALL THREAD related workspaces. Internal use only.

Rows Sent The number of rows of data sent to the requester location.

Service Class The service class name associated with this address space.

SQL Calls Sent The number of SQL statement sent to the server.

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

Sync Reads The number of synchronous reads per second for the database or space name. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.2.

Synchronous Read I/O Rate The thread synchronous read I/O rate.

Thread Status The current status of a thread.

Valid values are:

Thread Token The thread token uniquely identifies a specific thread.

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 (Field name: QWHSLUUV).

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

Updates The number of Db2 page updates made by the thread since thread creation. This value is incremented each time a row in a page is updated, not just once for each page that is updated. Db2 might update pages when it creates intermediate result tables because of a qualified SELECT statement, even though SELECT statements are generally thought of as read only operations. Pages that have been updated are written asynchronously by Db2, according to Db2 internal Deferred Write algorithm, not immediately after update or commit. Db2 resets the page update count at Create Thread and Signon. If Signon is not driven, the page update count is cumulative.

Wait Time Total class 3 wait time for a thread.

Workstation ID The end user's workstation name. This field contains blanks if this information was not supplied by the client.