Data Sharing Thread Detail Attributes
Use Data Sharing Thread Detail attributes to create situations that monitor thread activity for an entire data sharing group.
Ace Address The Db2 thread ACE address for internal use.
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.
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.
Collection ID The 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.
Data Sharing Thread Detail Attributes Identifies the connection of an application to a Db2 system.
It is an alphanumeric text string, with a maximum length of eight characters.
Thread Detail Attributes (Data Sharing) The type of Db2 connection.
| Value | Description |
|---|---|
| BATCH | Batch job. |
| CICS | CICS attach |
| DB2CAF | Db2 call attach |
| DLIBATCH | DL/I batch |
| Distributed or DBAccess | 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 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 Time The central processor CPU time.
Db2 ID The name of a Db2 subsystem.
Display CPU Time The total amount of CPU time that Db2 has accumulated for a thread.
Valid format is HH:MM:SS:mmm, where: HH = Hour, MM = Minute, SS = Second, mmm = Millisecond. If the time goes over 24 hours, the format is DD-HH:MM where: DD = Day, HH = Hour, MM = Minute. For example, 00:14:59 indicates that the display CPU time is 14 minutes and 59 seconds.
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.
IDNAME An internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID.
In Db2 Elapsed Time The elapsed time accumulated in Db2.
LUWID The logical unit name (LUNAME) of the connection to the remote Db2 system.
MVS System The MVS System Management Facility (SMF) ID. It is an alphanumeric text string with a maximum of 4 characters; for example SP11.
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 Identifies the package name with which a thread is associated. It is an alphanumeric text string, with a maximum of 8 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.
Plan Name The name of an application plan that Db2 produces during the bind process and uses for processing SQL statements during execution. Valid format is alphanumeric, 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.
Thread 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.
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 current status of a thread.
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.
- 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 uniquely identifies a specific thread.
Data Sharing Thread Detail Attributes The type of thread.
| 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 Wait Time The total amount of thread wait time. Valid format 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 Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.