Db2 Thread Exceptions attributes

Use the Db2 Thread Exceptions attributes to create situations to monitor thread-related performance.

Ace Address The Db2 thread ACE address for internal use.

Archive Tape Wait True if waiting for a tape for an archive operation. It is an alphanumeric text string, with a maximum length of one character.

Asynchronous Page Reads The number of asynchronous page reads for prefetch. Valid value is an integer in the range 0 - 2147483647.

Authorization ID The authorization ID of the thread. It is an alphanumeric text string, with a maximum length of eight characters.

Authorization ID (Unicode) The authorization ID of the thread. It is an alphanumeric text string, with a maximum length of eight 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.

Cancel Command The command string needed to cancel a thread. It is an alphanumeric text string, with a maximum length of eight characters.

CICS MVS ID The MVS identifier used for CICS dynamic workspace linking.

Collection ID The collection ID.

Collection ID (Unicode) The collection ID.

Commit Count The number of times the thread successfully completed commit processing. Db2 resets the commit count at Create Thread and Signon. If Signon is not driven, the count is cumulative.

Commit Ratio The ratio of total system page updates to total commits.

Connection ID Identifies the connection of an application to a Db2 system. It is an alphanumeric text string, with a maximum length of eight characters.

Connection Type The type of thread connection.

Valid values are:

Value	Description
Application_Directed	Application directed access
CICS	CICS attach
DB2_CALL_ATTACH	Db2 call attach
DLIBATCH	DL/I batch
DISTRIBUTED	Distributed thread
IMS_BMP	IMS attach BMP
IMS_CTL	IMS control region
IMS_MPP	IMS attach MPP
IMS_TBMP	IMS transaction BMP
IMS	IMS thread
RRSAF	Db2 Resource Recovery Services attachment facility
SYSTEM	System directed access
TSO	TSO foreground and background
UNKNOWN	Unrecognizable connection type
UTILITY	Db2 Utility

Correlation ID The correlation ID for this thread. It is an alphanumeric text string, with a maximum length of 12 characters.

CPU Utilization The rate of CPU consumption during last interval.

CP CPU Time The total amount of central processor CPU time that Db2 has accumulated for a thread.

CP DB2 CPU Used The CP CPU time accumulated in Db2 when the SQL statement exit from Db2.

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

Db2 ID The name of the Db2 system on which this thread is running. It is an alphanumeric text string, with a maximum length of four characters.

Display CPU Time The total amount of CPU time that Db2 has accumulated for a thread.

Display Elapsed Time The total amount of elapsed time since thread creation or Db2 sign-on.

Display Wait Time The total amount of thread wait time. The collection of thread wait time requires activation of Accounting Class 2 in the monitored Db2 subsystem.

Distributed Bytes Received The amount of data received by distributed threads from remote Db2.

Distributed Bytes Received 64 The amount of data received by distributed threads from remote Db2. It has a length of 64 bit to resolve overflow problems.

Distributed Bytes Sent The amount of data sent by distributed threads to remote Db2.

Distributed Bytes Sent 64 The amount of data sent by distributed threads to remote Db2. It has a length of 64 bit to resolve overflow problems.

Distributed CPU Seconds The amount of CPU time being used by a distributed DB access thread (in units that represent milliseconds).

Dynamic Prefetch The number of dynamic prefetch requests. Valid value is an integer in the range 0 - 2147483647.

Elapsed Time The elapsed time for a Db2 thread (in units that represent seconds).

Getpage Count The number of get page operations for this thread during the last interval.

Getpage Ratio The number of Get pages divided by the Read I/O count.

IDNAME An internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID.

Immediate Write I/O The number of synchronous write I/O requests that Db2 issues on behalf of a thread. Valid value is an integer in the range 0 - 2147483647.

In-DB2 IIP CPU Time The IIP CPU time consumed when executing in Db2.

In Doubt If True, the thread is in an INDOUBT status. It is an alphanumeric text string, with a maximum length of one character.

Interval Time The amount of time this thread has existed during the last sampling period (in units that represent seconds).

Job Name The job name connected to a coupling facility structure. It is an alphanumeric text string with a maximum of 8 characters; for example, IRLM.

List Prefetch The number of list prefetch requests that a thread issues. Valid value is an integer in the range 0 - 2147483647.

Lock Percentage The number of locks owned divided by the maximum allowed locks for a thread.

Locks Max The maximum number of locks allowed for a single thread.

Locks Owned The number of locks this thread currently owns.

LUWID The logical unit of work ID (LUWID) for a thread. This value consists of two parts: the logical unit of work ID (luw-id) and a token. The token can be used in place of the luw-id in any Db2® command that accepts luw-id as input. Format:


luw-id=token

The luw-id consists of the network name, the originating VTAM® LUNAME, and a unique identifier (separated by periods). Thus, the Luwid field displays data such as the following:


USCACO01.O2D22A.A1FE8E04B9D4=8

Misc Flag Miscellaneous flag. It is an alphanumeric text string, with a maximum length of one character.

MVS System The name of the MVS image where the Db2 system identified by the DB2ID field is running. It is an alphanumeric text string, with a maximum length of four characters.

Name The name of the Db2 thread. It is an alphanumeric text string, with a maximum length of four 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 DBRM (Unicode) The package DBRM name.

Package Name The name of the package to which this thread belongs.

Page Update Rate The number of page update requests per second made by a thread.

Plan Name The ID of the plan this thread is executing. It is an alphanumeric text string, with a maximum length of eight characters.

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.

Prefetch Count The number of sequential, prefetch operations during the interval.

Prefetch Rate The read sequential, prefetch rate.

Read Count The number of read operations during the interval.

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

Resource Count The total resource count.

Resource Limit The limit on number of resources allowed.

Resource Limit Percent The resource usage divided by resource limit.

Sync Read Count The number of synchronous reads during last interval.

Thread Connection Type The type of thread connection.

Valid values are:

Value	Description
BATCH	Batch job
CICS	CICS attach
DLIBATCH	DL/I batch
Distributed	Distributed Database Access thread
IMS_BMP	IMS attach BMP
IMS_CTL	IMS control region
IMS_MPP	IMS attach MPP
IMS_TBMP	IMS transaction BMP
DistAllied	Distributed Allied thread
RRSAF	Db2 Resource Recovery Services attachment facility
SYSTEM	System directed access
TSO	TSO foreground and background
UNKNOWN	Unrecognizable connection type
UTILITY	Db2 Utility

Thread Create Wait The application waiting for thread creation. It is an alphanumeric text string, with a maximum length of one character.

Thread Group Member Name The name of the member within a data sharing group for a thread.

Thread Group Name The name of a data sharing group for a thread. It is an alphanumeric text string, with a maximum of 8 characters; for example, TDDB241G.

Thread Status The description of the current thread status. It is an alphanumeric text string, with a maximum length of 12 characters. Valid values are:

Status

Description

NOT-AVAIL

The thread is not available.

IN-ABORT

The thread is in abort processing.

IN-ACCEL

The thread is executing on IBM Db2 Analytics Accelerator for z/OS.

IN-AUTO-PROC

The thread is processing an autonomous procedure.

IN-BIND-DYNM

The thread is in dynamic bind processing.

IN-BIND-STAT

The thread is in static bind processing.

IN-COMMAND

Command threads display this status when they are active in Db2 and executing within the Db2 command processor. (This type of thread always has a blank plan name.)

IN-COMMIT

The thread is in Commit processing (applies only to threads that originate from an attachment that does not use two-phase-commit protocol).

IN-COMT-PHS1

The thread is in Commit phase 1 processing.

IN-COMT-PHS2

The thread is in Commit phase 2 processing.

IN-CRTE-THRD

The thread is in Create Thread processing.

IN-DB2

The thread is executing in Db2. A more descriptive status could not be determined.

INDOUBT

The thread is in doubt.

IN-SIGNON

The thread is in signon processing. This status applies only to threads originating from CICS or IMS attachments.

IN-SQL-CALL

The thread is processing an SQL call.

IN-SQL-SORT

The thread is executing an SQL call and is doing the sort processing required to satisfy the call's request.

IN-STOR-PROC

The thread is currently running in a stored procedure.

IN-TERM-THRD

The thread is in termination as a result of allied task termination. This status corresponds to Db2 DISPLAY THREAD=D status.

IN-TRIGGER

The thread is currently running in a trigger.

IN-USER-FUNC

The thread is currently running a user-defined function.

NOT-IN-DB2

The thread is not currently executing in Db2.

SP/UDF-INACT

The thread is trying but not able to run in a stored procedure or user-defined function.

SWAPPED-OUT

The thread is not currently executing in Db2. The thread originating address space is swapped out.

WAIT-ARCHIVE

The thread is waiting for an archive log tape mount necessary during thread abort processing.

WAIT-ARCREAD

The thread is currently waiting for read of archive log from tape.

WAIT-ASYNCRD

The thread is currently waiting for completion of a read I/O that is being done under a thread other than this one (for example, sequential or List Prefetch).

WAIT-ASYNCWR

The thread is currently waiting for completion of Write I/O that is being done under a thread other than this one (for example, Deferred Writes).

WAIT-CONVLIM

The distributed thread is in a synchronous wait because the conversation limit has been reached for its designated logmode.

WAIT-CTHREAD

The thread is queued in Create Thread processing because Db2 reached the CTHREAD value. This status corresponds to Db2 DISPLAY THREAD=QD status.

WAIT-GLBLOCK

The thread is currently waiting for either:

Inter-system communication within the data sharing group to determine if there is lock contention.
A lock held by another subsystem in the data sharing group.

WAIT-LOCK

The thread is waiting for a lock.

WAIT-MSGSEND

The thread is waiting because of inter-system message sending contention.

WAIT-REMREQ

The database access thread is in a synchronous wait (waiting for a response or a request from the originating Db2 subsystem).

WAIT-REMSQL

The distributed allied thread is in a synchronous wait (waiting for a response from the remote Db2 subsystem being accessed).

WAIT-REUSE

The thread is not currently in use and is waiting to be reused. This status applies only to CICS and IMS threads.

WAIT-SERVICE

The thread is currently waiting for completion of a Db2 service. Types of Db2 services include: open/close of a dataset, DFHSM recall of a dataset, SYSLGRNG update or define/extend/delete of a dataset, rollback, and Commit phase 2 for read only threads.

WAIT-SP-STOP

The thread is queued waiting for a stopped stored procedure.

WAIT-TERM-TH

The thread is queued and waiting for thread termination as a result of allied task termination. This status corresponds to Db2 DISPLAY THREAD=QD status.

UTIL-STOP

The Db2 utility was started but not completed because of abnormal termination.

The following status are only available when class 2/3 traces are on:

WAIT-ACCEL: The thread is currently waiting for claimers to be released after acquiring drain lock.
WAIT-CLAIMER: The thread is currently waiting for claimers to be released after acquiring drain lock.
WAIT-CL3LOCK: The thread is currently waiting for the completion of an identify call to the IRLM.
WAIT-COMMIT: The thread is waiting for the FORCE-AT-COMMIT event to complete.
WAIT-DRNLOCK: The thread is currently waiting to acquire drain lock.
WAIT LOB: The thread is currently waiting for TCP/IP to materialize a LOB.
WAIT-LOCKLAT: The thread is waiting for a LOCK-I/O-LATCH.
WAIT-LOCKPIP: The thread is currently waiting for a PIPE suspend.
WAIT-LOCKPQS: The thread is currently suspended for parallel task synchronization.
WAIT-LOGQSCE: The thread is currently suspended because of an ARCHIVE LOG MODE(QUIESCE) command.
WAIT-PGLATCH: The thread is currently waiting for page latch.
WAIT-SP-SCHD: The thread is waiting for a TCB to become available in the stored procedures address space to schedule a stored procedure.
WAIT-SWITCH: The thread is currently waiting for the completion of a synchronous execution switch.
WAIT-SYNC-IO: The thread is currently waiting for completion of a synchronous Read I/O or Write I/O.
Note: This status can indicate that a Db2 resource is not large enough. You can use the OMEGAMON XE for Db2 PE resource manager or object analysis displays to further isolate the problem.

Thread Stored Procedure Name The name of the stored procedure that a thread invokes. It is an alphanumeric text string, with a maximum of 18 characters; for example, SPCALC_TAX.

Thread Token The thread token used as foreign key to DDF, also used for the cancel thread command.

Thread Wait Time The total amount of thread wait time. It is an integer in the range 09 - 99999999 seconds. Note: collection of thread time requires activation of Accounting Class 2 in the Monitored Db2 subsystem.

Time The date and time, as set on the monitored system, indicating the instance when the agent collects information.

Type Indicator Indicates the type of parallel thread.

Valid values are:

Value	Description
Normal	Not a parallel thread
Parent	Parallel thread is a parent
Child	Parallel thread is a child
Autonomous SP	Originating thread which invoked autonomous stored procedures

Unsuccessful Get Page Operation The number of conditional getpage requests that failed. Valid value is an integer in the range 0 - 2147483647.

Update Count The number of update operations during last interval.

Wait Resource The resource being waited on. It is an alphanumeric text string, with a maximum length of six characters.

Wait Time Total class3 wait time for a thread.

Wait Time Distributed Query The time distributed allied thread has been waiting for response - remote SQL (in units that represent milliseconds).

Wait Time Drain Claims The time thread waiting for drain of claims.

Wait Time Drain Lock The time thread waiting for acquisition of drain lock.

Wait Time Global Lock The time thread waiting because of global contention.

Wait Time Log Queue The time thread waiting for ARCHIVE LOG MODE(QUIESCE).

Wait Time Procedure The time thread waiting for a TCB to schedule a stored procedure.

Wait Time Resource The time thread waiting for a resource.

Wait Time Service The time thread waiting for Db2 Service (in units that represent milliseconds).