IFCID 025 - Utility End
This topic shows detailed information about Record Trace - IFCID 025 - Utility End
.
Record Trace - IFCID 025 - Utility End
The field labels shown in the following sample layout of Record Trace - IFCID 025 - Utility End
are described in the following section.
DB2 VERSION: V10 PAGE DATE: 05/31/13
PRIMAUTH CONNECT INSTANCE END_USER WS_NAME TRANSACT
ORIGAUTH CORRNAME CONNTYPE RECORD TIME DESTNO ACE IFC DESCRIPTION DATA
PLANNAME CORRNMBR TCB CPU TIME ID
-------- -------- ----------- ----------------- ------ --- --- -------------- ------------------------------------------------------
09:01:19.05114383 568 1 25 UTILITY <-- BBED
0.04901157 END NETWORKID: DEIBMIPS LUNAME: IPSARA22 LUWSEQ: 15
DBID TESTDB UTILITY NAME REORG
OBID EMPLOYEE UTILITY PHASE UTILTERM
ITEMS 0 UTILITY ID BBE.BBED
JOBNAME : BBED STEPNAME : UNLD0 ELAPSED TIME: 0.208941 SUBTASKS : 0
DFSORT : YES DB2SORT : NO DATA SORTS : 1 INDEX SORTS : 0
OTHER SORTS : 0 SHRLEVEL : N CPU TIME : 0.038269 ZIIP TIME : 0.000109
IMP DEC POINT: NO SORT CPU : 0.000000 SORT ZIIP : 0.000000
SORT OPTMODE: CPU ZIIP ONLINE : NO
- DBID
-
The database ID. Deduced from the Db2 fields QW0025DB, QW0105DN or QW0107DN.
When present, the database name is shown, otherwise the decimal identifier from QW0025DB is shown, or N/A when this value is 0.
Field Name: RT0025DB
- UTILITY NAME
-
The utility name.
Field Name: QW0025NM
- OBID
-
The object ID. Deduced from the Db2 fields QW0025PD, QW0105TN or QW0107TN.
When present, the name of the object is shown, otherwise the decimal identifier from QW0025OB is shown, or N/A when this value is 0.
Field Name: RT0025OB
- UTILITY PHASE
-
The phase name of the utility.
Field Name: QW0025PH
- ITEMS
-
The phase name of the utility.
Field Name: QW0025DN
- UTILITY ID
-
The identifier of the utility.
Field Name: QW0025ID
- JOBNAME
-
The job name of the utility.
Field Name: QW0025JN
- STEPNAME
-
The step name of the utility job.
Field Name: QW0025JS
- ELAPSED TIME
-
The utility elapsed time at termination. This field and the following time fields are in time-of-day format. If this field contains binary zeroes, no data is available for this field or for the following time fields. For example, this is the case for subphase termination records.
Field Name: QW0025UE
- SUBTASKS
-
The final subtask count.
Field Name: QW0025R1
- DFSORT
-
DFSORT was invoked at least once. Possible values are Y or N.
Field Name: QW0025DF
- DB2SORT
-
Db2 SORT was invoked at least once. Possible values are Y or N.
Field Name: QW0025DS
- DATA SORTS
-
The number of parallel data sorts.
Field Name: QW0025DA
- INDEX SORTS
-
The number of parallel index sorts.
Field Name: QW0025IX
- OTHER SORTS
-
The number of other sorts.
Field Name: QW0025OS
- SHRLEVEL
-
The SHRLEVEL value of the utility. Possible values are: NONE, REFERENCE, CHANGE, or N/A.
Field Name: QW0025SL
- CPU TIME
-
The CPU time of the utility.
Field Name: QW0025UC
- ZIIP TIME
-
The total utility ZIIP time (if Accounting class 1 trace is activated).
Field Name: QW0025UZ
- SORT CPU
-
The Sort CPU time.
Field Name: QW0025SC
- SORT ZIIP
-
The Sort ZIIP time (if provided by the Sort program).
Field Name: QW0025SZ
- ZIIP ONLINE
-
Specifies whether IBM zIIPs are online.
Field Name: QW0025ZIIP
- SORT OPTMODE
-
Specifies Optimization mode for Db2 Sort. BALANCE provides the best mix of CPU and elapsed time performance by balancing utilization of central storage and disk space. CPU optimizes to minimize CPU time without any consideration for elapsed time, maximizing disk space usage. ELAP optimizes to minimize elapsed time while significantly reducing CPU time, favoring central storage over disk space usage.
Field Name: QW0025OPT
- IMP DEC POINT
-
Specifies whether implied decimal point has been detected.
Field Name: QW0025IM