Utility Summary
This panel provides information about all active utilities and utilities that have been started but have not yet completed because of abnormal termination.
If monitoring a remote DB2, this utility is not supported. The message UTIL
Remote DB2 is not supported for this command is displayed.
________________ ZUTIA VTM O2 V540./C SN11 08/07/13 16:20:09 2
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
> T.H
> Thread Activity: Enter a selection letter on the top line.
> A-All-Idle B-TSO C-CICS D-IMS E-Background F-Dist Allied
> G-Dist DBAC *-Util I-Inact J-Filter K-Functions L-Stored Proc
> M-Triggers N-Sysplex O-Enclaves P-Worksta Q-All+Idle
===============================================================================
> Utility Summary
UTIL
+ Elapsed Utility Utilid Phase Count Status CPU
+ ---------- -------- ---------------- -------- ---------- ------------ -----
+ 00:01:05.8 LOAD A1 RELOAD 7253549 IN-DB2 13.7%
+ 00:00:48.8 LOAD A1 SORTIN 14509999 NOT-IN-DB2 00.0%
=============================================================================== Each row provides information about an individual utility (information such as thread elapsed time, utility phase, and record count).
Highlighting
OMEGAMON® XE for DB2 PE highlights the following fields when any
of the exceptions described below tripped in this cycle:
| Field | Exception | Reason |
|---|---|---|
| Elapsed | ETIM | This thread has reached the Elapsed Time threshold value. This thread address space has excessive CPU utilization. |
| CPU | TCPU | This thread has reached the Elapsed Time threshold value. This thread address space has excessive CPU utilization. |
| Status | UTIS | This utility has been started but has not completed running due to abnormal termination. |
Navigation
For additional
information about
- a particular Db2 utility, move the cursor to the utility information line and press F11 (Zoom).
- A different Db2 subsystem, data sharing group, or member of a data sharing group, enter the name of a Db2 subsystem, group, or member in the topmost row and press Enter.
- related topics, select one of the options on the top of the panel.
Fields
- Elapsed
- The elapsed time since thread creation, or since DB2 signon if the thread is reused. When the elapsed time of the thread exceeds
24 hours, the format is dd-hh:mm.If this thread is involved in parallel processing or if it invoked autonomous procedures, one of the following identifiers is displayed after the elapsed time:
- *
- This thread is a parallel task that is initiated on behalf of another (originating) thread to process a query request in parallel.
- O
- This thread is the originating thread that invoked autonomous procedures.
- P
- This thread is the parent or the originating thread of the parallel tasks that are created to process a query request in parallel. Activity performed for this (originating) thread is reflected under the parallel tasks.
- X
- This thread is a parallel task that is initiated on behalf of another (originating) thread on another Db2 for sysplex parallelism.
When status field displays
UTIL-STOP, this field isN/A(not applicable). - Utility
- The name of the Db2 utility.
- Utilid
- The identifier that defines the utility to DB2. Each utility that has been started and is not yet terminated must have a unique utility ID.
- Phase
- The executing phase of the DB2 utility. If the utility is stopped, you must specify this phase when you restart it.
- Count
- The total number of items (such as records or pages) that have been processed. The type of item depends on the utility and its phase.
- Status
- The status of the Db2 utility. The status is
UTIL-STOPif the Db2 utility has been started but has not yet completed running because of abnormal termination. - CPU
- The current CPU rate of the DB2 utility job. When status field displays
UTIL-STOP, this field is not applicable.