Field description - Utility phases

This topic describes the fields of the Utility Phases.

PHASE

The name of the phase used by the utility.

UNLOAD

The unload phase of the maintask or the summary of unload subtasks.

SORT

The sort phase of the maintask or the summary of sort subtasks.

BUILD

The build phase of the maintask or the summary of build subtasks.

DATABASE

The database name of the object.

PAGESET

The table space name or index name of the object.

When the sort or build phase, or both, are running in parallel as part of a subtask, ******** is printed if the number of objects is greater than one.

PARTNO

The number of the partition or data set if the utility is operating on a single partition or data set. Otherwise, the value in this field is 0.

TYPE

The item type for the individual phases.

COUNT

The number of item types processed by the phase for one object.

ELAPSED TIME

The elapsed time of the phase. This is the time between the IFCID 024 (utility change) of the phase and the IFCID 024 of the next phase. For the last phase, this is the time between the IFCID 024 (utility change) of the phase and the IFCID 024 of the UTILTERM.

CPU TIME

The CPU time of the phase. This is the time between the IFCID 024 (utility change) of the phase and the IFCID 024 of the next phase. For the last phase, this is the time between the IFCID 024 (utility change) of the phase and the IFCID 024 of the UTILTERM.

UTILINIT/ UTILTERM

This is the starting and ending time of the utility. This is the sum of the time between the IFCID 023 (Utility start) of the UTILINIT and the IFCID 024 (Utility change) of the first phase and the time between the IFCID 024 and the IFCID 025 (Utility end) of the UTILTERM. This is shown as elapsed time and CPU time.

MAIN TASK TOTAL

The total time spent processing main tasks. This is shown as elapsed time and CPU time.

SUBTASK

For each subtask, the following information is shown:

SUBTASK

The time between the IFCID 023 (utility start) for the subtask and the IFCID 024 (utility change) for the first phase within the subtask. This is shown as elapsed time and CPU time.

Phase

The name of the phase and time information. For a single phase, this is the time between the IFCID 024 (utility change) for the phase and the IFCID (utility end) of the subtask.

When a subtask contains multiple phases, the duration of the first and intermediate phases is measured from the IFCID 024 of the phase to the IFCID 024 of the next phase. For the last phase in the subtask, phase duration is taken from the IFCID 024 (utility change) for the phase to the IFCID 025 (utility end) of the subtask.

This is shown as elapsed time and CPU time.

SUBTASK TOTAL

Total time spent processing the subtask. This is the time between the IFCIDs 23 (utility start) and 25 (utility end) for the subtask. This is shown as elapsed time and CPU time.