Use the All Threads
attributes to create situations to monitor thread activity including
DB2 thread activity that originates from connected IMS or CICS subsystems.
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. Valid format is alphanumeric
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. Valid format is
alphanumeric with a maximum of 8 characters.
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. Valid format
is alphanumeric, with a maximum of 18 characters.
Collection
ID (Unicode) The collection ID. This
field is blank for DBRM. Valid format is alphanumeric, 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.
Connection ID Identifies the connection of an application
to a DB2 system.
Valid values are:
- BATCH
- Batch job
- CICS
- CICS attach
- DB2CALL
- DB2 call facility
- DIST
- Distributed
- IMS
- IMS thread
- TSO/E
- TSO/E foreground and background
- UTILITY
- DB2 utility
Connection Type The type of DB2 connection.
Valid
values are:
- APPLCTN
- Application directed access
- BATCH
- Batch job
- CICS
- CICS attach
- DB2CAF
- DB2 call attach
- DLIBATCH
- DL/I batch
- IMS
- IMS thread
- IMS BMP
- IMS attach BMP
- IMS TBMP
- IMS transaction BMP
- IMS CTL
- IMS control region
- IMS MPP
- IMS attach MPP
- SYSTEM
- System directed access
- TSO/E
- TSO/E foreground and background
- UNKNOWN
- Unrecognizable connection type
- UTILITY
- DB2 utility
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. Valid format is alphanumeric,
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. Valid entry is an alphanumeric text
string, with a maximum length of 12 characters.
Valid values
are:
- Status
- Description
- IN-ABORT
- The thread is in abort processing.
- IN-ACCEL
- The thread is executing in accelerator.
- 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.)
- IN-COMMIT
- The thread is in commit processing. It applies only to threads
that originate from an attachment that does not use a 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 request of the call.
- 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 the DB2 DISPLAY THREAD=D.
- IN-TRIGGER
- The thread is currently running in a trigger.
- IN-USER-FUNC
- The thread is currently running a user-defined function.
- NOT_AVAIL
- The thread is not available
- NOT_IN_DB2
- The thread is currently not running in DB2.
- SP/UDF-INACT
- The thread is trying to but cannot run in a stored procedure or
user-defined function.
- SWAPPED_OUT
- The thread is currently not running 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 done under a thread other than this one (such as sequential
or list prefetch).
- WAIT_ASYNCWR
- The thread is currently waiting for completion of write I/O that
is done under a thread other than this one (such as deferred writes).
- WAIT_CLAIMER
- The thread is currently waiting for claimers to be released after
acquiring DRAIN lock.
- 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_DRNLOCK
- The thread is currently waiting to acquire DRAIN lock.
- WAIT_GLBLOCK
- The thread is currently waiting for one of the following:
- A lock held by another subsystem in the data sharing group.
- Inter-system communication within the data sharing group to determine
if there is lock contention.
- WAIT_LOCK
- The thread is waiting for a lock
- WAIT_LOGQSCE
- The thread is currently suspended because of an ARCHIVE LOG MODE(QUIESCE)
command.
- WAIT_MSGSEND
- The thread is currently waiting because of inter-system message
sending contention.
- WAIT_PGLATCH
- The thread is currently waiting for page latch.
- 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 data set, DFHSM recall
of a data set, SYSLGRNG update, or define/extend/delete of a data
set, rollback, and commit phase 2 for read only threads.
- WAIT_SP_STOP
- The thread is queued waiting for a stopped stored procedure.
- WAIT_SPSCHD
- The thread is waiting for a TCB to become available in the stored
procedures address space to schedule a stored procedure.
- 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.
- WAIT_TERM_TH
- The thread is queued and waiting for thread termination as a result
of allied task termination. This status corresponds to the DB2 DISPLAY
THREAD=QD status.
- UTIL-STOP
- The DB2 utility was started but not completed because of abnormal
termination.
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 (DB2 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. Valid
entry is an alphanumeric text string, with a maximum length of 8 characters.
Original Authorization ID (Unicode) The DB2 original Authorization ID of the thread. Valid
entry is an alphanumeric text string, with a maximum length of 8 characters.
Originating System ID The
managed system name of the agent. Valid format is alphanumeric,
with a maximum of 32 characters; for example, DB91:SYS1:DB2.
Package Name Identifies
the package name with which a thread is associated. Valid format
is alphanumeric, with a maximum of 8 characters.
Package
Name (Unicode) Identifies the package
name with which a thread is associated. Valid format is alphanumeric,
with a maximum of 8 characters.
Parallel Indicator The thread parallelism indicator.
Valid
values are:
- *
- Indicates that this thread is a parallel task initiated for another
(originating) thread to process a query request in parallel.
- O
- Indicates that this thread is the originating thread that invoked
autonomous procedures.
- P
- Indicates that this thread is the parent, or originating thread,
of the parallel tasks created to process a query request in parallel.
The activity performed for this (originating) thread is reflected
under the parallel tasks.
- X
- Indicates that this thread is a parallel task initiated for another
(originating) thread on another DB2 for SYSPLEX parallelism.
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. 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.
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:
- Status
- Description
- IN-ABORT
- The thread is in abort processing.
- IN-ACCEL
- The thread is executing in accelerator.
- 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.)
- IN-COMMIT
- The thread is in commit processing. It applies only to threads
that originate from an attachment that does not use a 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 request of the call.
- 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 the DB2 DISPLAY THREAD=D.
- IN-TRIGGER
- The thread is currently running in a trigger.
- IN-USER-FUNC
- The thread is currently running a user-defined function.
- NOT_AVAIL
- The thread is not available
- NOT_IN_DB2
- The thread is currently not running in DB2.
- SP/UDF-INACT
- The thread is trying to but cannot run in a stored procedure or
user-defined function.
- SWAPPED_OUT
- The thread is currently not running 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 done under a thread other than this one (such as sequential
or list prefetch).
- WAIT_ASYNCWR
- The thread is currently waiting for completion of write I/O that
is done under a thread other than this one (such as deferred writes).
- WAIT_CLAIMER
- The thread is currently waiting for claimers to be released after
acquiring DRAIN lock.
- 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_DRNLOCK
- The thread is currently waiting to acquire DRAIN lock.
- WAIT_GLBLOCK
- The thread is currently waiting for one of the following:
- A lock held by another subsystem in the data sharing group.
- Inter-system communication within the data sharing group to determine
if there is lock contention.
- WAIT_LOCK
- The thread is waiting for a lock
- WAIT_LOGQSCE
- The thread is currently suspended because of an ARCHIVE LOG MODE(QUIESCE)
command.
- WAIT_MSGSEND
- The thread is currently waiting because of inter-system message
sending contention.
- WAIT_PGLATCH
- The thread is currently waiting for page latch.
- 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 data set, DFHSM recall
of a data set, SYSLGRNG update, or define/extend/delete of a data
set, rollback, and commit phase 2 for read only threads.
- WAIT_SP_STOP
- The thread is queued waiting for a stopped stored procedure.
- WAIT_SPSCHD
- The thread is waiting for a TCB to become available in the stored
procedures address space to schedule a stored procedure.
- 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.
- WAIT_TERM_TH
- The thread is queued and waiting for thread termination as a result
of allied task termination. This status corresponds to the DB2 DISPLAY
THREAD=QD status.
- UTIL-STOP
- The DB2 utility was started but not completed because of abnormal
termination.
Thread Type The thread type. It can be:
- A =
- IMS
- B =
- BATCH
- C =
- CICS
- 0 =
- Unknown
- 1 =
- DB_Access
- 3 =
- SYSTEM
- 5 =
- UTILITY
- 6 =
- RRSAF
- 7 =
- TSO
- 9 =
- Allied
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 (DB2 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.
zIIP
Different Speed The setting if the
zIIP processor is at a different speed. Valid values are:
- Yes
- The zIIP processor is set to a different speed.
- No
- The zIIP processor is set to the same speed.
zIIP Processor The setting to confirm that the enclave is
using a zIIP processor.- Yes
- The enclave is using a zIIP processor.
- No
- The enclave is not using a zIIP processor. If No then the other
zIIP related fields will be N/A.