Utility Phases
This block shows the utility phases for each object performed by the event. Its layout depends on whether the utility produces parallel tasks.
Note: You can process up to 40 utility phases for each object.
Phases Workload Block Example without Parallel Tasks
Here is an example of the phases workload block without parallel tasks. An example of the phases
workload block with parallel tasks is shown in Phases Workload Block Example with Parallel Tasks.
LOCATION: PMODA22 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-1
GROUP: N/P UTILITY ACTIVITY TRACE REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA22 ACTUAL FROM: 05/31/15 09:01:18.84
DB2 VERSION: V10 PAGE DATE: 05/31/15
WORKLOAD(PHASE)
IDENTIFIED BY PRIMAUTH/PLANNAME
PRIMAUTH START TIME ELAPSED TIME UTILITY-ID JOB NAME SHRLEVEL
PLANNAME SUBTASKS CPU TIME ACTIVITY TYPE DATABASE.PAGESET STEP TOT. ZIIP
SORT: DF DB2 DATA INDEX OTHER SORT CPU SORT ZIIP
--------------------- ----------- ------------ ----------------------- -----------------------------------------------------------
WER
DSNUTIL 23:59:28.26 8.369076 UTILITY FUA8U114.STEP2 LOAD_THE_FIRST
N/A N/A 0.761910 LOAD DSNDB04 .TSA81401
DSNDB04 .IUA81401
DSNDB04 .IUA81403
DSNDB04 .IUA81402
DSNDB04 .IUA81404
--- UTILITY PHASES -----------------------------------------------------------------
PHASE DATABASE PAGESET PARTNO TYPE COUNT ELAPSED TIME CPU TIME
UTILINIT / UTILTERM 0.171218 0.034901
RELOAD DSNDB04 TSA81401 0 R 16 2.640100 0.093036
SORT DSNDB04 TSA81401 0 IF 42 0.852126 0.103900
BUILD DSNDB04 IUA81401 0 I 42 0.807582 0.043772
DSNDB04 IUA81403 0 I 42
DSNDB04 IUA81402 0 I 42
DSNDB04 IUA81404 0 I 30
INDEXVAL DSNDB04 TSA81401 0 I 2 0.525681 0.032609
ENFORCE DSNDB04 TSA81401 0 I 2 0.761700 0.079493
DISCARD DSNDB04 TSA81401 0 I 4 1.755469 0.259094
REPORT DSNDB04 TSA81401 0 R 6 0.855201 0.115105
** MAIN TASK TOTAL ** 8.369077 0.761910Phases Workload Block Example with Parallel Tasks
Here is an example of the phases workload block with
parallel tasks.
WORKLOAD(PHASE)
IDENTIFIED BY PRIMAUTH/PLANNAME
PRIMAUTH START TIME ELAPSED TIME UTILITY-ID JOB NAME SHRLEVEL
PLANNAME SUBTASKS CPU TIME ACTIVITY TYPE DATABASE.PAGESET STEP TOT. ZIIP
SORT: DF DB2 DATA INDEX OTHER SORT CPU SORT ZIIP
--------------------- ----------- ------------ ----------------------- -----------------------------------------------------------
WER
DSNUTIL 23:59:38.33 12.141981 UTILITY FUA8U114.STEP2 LOAD_THE_SECON
2 0 0 0.930925 LOAD DSNDB04 .TSA81401
DSNDB04 .IUA81401
DSNDB04 .IUA81403
DSNDB04 .IUA81402
DSNDB04 .IUA81404
--- UTILITY PHASES ----------------------------------------------------------------------------------------------------------
PHASE DATABASE PAGESET PARTNO TYPE COUNT ELAPSED TIME CPU TIME
UTILINIT / UTILTERM 0.119844 0.036723
RELOAD DSNDB04 TSA81401 0 R 16 3.253289 0.137179
SORT DSNDB04 TSA81401 0 IF 42 0.776951 0.105233
BUILD DSNDB04 IUA81401 0 I 42 0.820962 0.047176
DSNDB04 IUA81403 0 I 42
DSNDB04 IUA81402 0 I 42
DSNDB04 IUA81404 0 I 30
INDEXVAL DSNDB04 TSA81401 0 I 2 2.837690 0.032817
ENFORCE DSNDB04 TSA81401 0 I 2 0.754517 0.079850
DISCARD DSNDB04 TSA81401 0 I 4 2.618391 0.264064
REPORT DSNDB04 TSA81401 0 R 6 0.960336 0.117006
** MAIN TASK TOTAL ** 12.141980 0.820048
>SUBTASK 0.000386 0.000316
COPY DSNDB04 TSA81401 0 FK 6 2.125070 0.000864
** SUBTASK TOTAL ** 2.125456 0.001180
SUBTASK 0.003410 0.000389
RUNSTATS DSNDB04 TSA81401 0 R 12 2.271970 0.033347
** SUBTASK TOTAL ** 2.275380 0.033736
SUBTASK 0.000262 0.000182
RUNSTATS DSNDB04 TSA81401 0 R 10 2.880952 0.075779
< ** SUBTASK TOTAL ** 2.881214 0.075961Note:
- In LOAD and REORG utility parallelism, the calculation of the elapsed and CPU times for the SORT phase only takes into account the parallel sort, not the originating task.
- Although not a phase of the LOAD or REORG utility, COPY is reported as a phase when a concurrent COPY was requested for the LOAD or REORG.
- If the utility runs on several objects or partitions, a TOTAL is shown for each phase.