Db2 Thread Status Values

This topic contains a list of all possible values for the status of a Db2 thread. This field is displayed on thread summary and thread detail panels as Status, Db2 Status, or Thread Status.

The following list shows all possible values for the status of a Db2 thread:

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 finish.
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® for Db2 PE resource manager or object analysis displays to further isolate the problem.