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 V610./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 AI for Db2 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.