IFCID 231 - Parallel Group Task Time

Edit online

This topic shows detailed information about Record Trace - IFCID 231 - Parallel Group Task Time.

Place text here

Record trace - IFCID 231 - Parallel Group Task Time

The field labels shown in the following sample layout of Record Trace - IFCID 231 - Parallel Group Task Time are described in the following section. 

STATEMENT NO:       1224  QUERY BLOCK NO:     1  PARALLEL GROUP NO:     1  REPEAT.GRPS:     2    RECORD     1 OF     1
GROUP CREATION: 09/24/08 12:40:57.760418  GROUP TERMINATION: 09/24/08 12:42:11.261163  GROUP ELAPSED:      1:13.500745
QW0231NG           1   QW0231NT          30
.........................................................................................................................
TASK SEQ. NUMBER:          1                TASK TOKEN  : X'6B9C08D0'
TASK CREATION   : 09/24/08 12:40:57.763105  TASK ELAPSED:      1:08.763455
TASK TERMINATION: 09/24/08 12:42:06.526560  CPU TIME    :        38.214432
MEMBER          : Q42Q                      CPU SU CONS :      32074          QW0231AC   311849464
TASK SEQ. NUMBER:          2                TASK TOKEN  : X'6B9C57A0'
TASK CREATION   : 09/24/08 12:40:57.765344  TASK ELAPSED:      1:08.529116
TASK TERMINATION: 09/24/08 12:42:06.294460  CPU TIME    :        37.548378
MEMBER          : Q42Q                      CPU SU CONS :      31515          QW0231AC   311862600
STATEMENT NO

The statement number. If the PLAN_TABLE exists, this is the same as QUERYNO in the PLAN_TABLE.

Field Name: QW0231SN

QUERY BLOCK NO

The query block number. If the PLAN_TABLE exists, this is the same as QBLOCKNO in the PLAN_TABLE.

Field Name: QW0231QN

PARALLEL GROUP NO

The parallel group number. If the PLAN_TABLE exists, this is the same as ACCESS_PGROUP_ID in the PLAN_TABLE.

Field Name: QW0231GN

REPEAT.GRPS

The number of repeat groups in the section.

Field Name: QW0231RN

RECORD

The position of this record in the series of IFCID 222 records.

Field Name: QW0231TR

OF

The total number of IFCID 231 records in this series.

Field Name: QW0231NR

GROUP CREATION

The time of group creation in Db2 timestamp format.

Field Name: QW0231CT

GROUP TERMINATION

The time of group termination in Db2 timestamp format.

Field Name: QW0231ET

GROUP ELAPSED

The elapsed time between group creation and group termination in Db2 timestamp format.

Field Name: RT0231GE

TASK SEQ. NUMBER

The task sequence number.

Field Name: QW0231TQ

TASK TOKEN

The task token.

Field Name: QW0231TK

TASK CREATION

The time of task creation in Db2 timestamp format.

Field Name: QW0231TC

TASK ELAPSED

The elapsed time between task creation and task termination in Db2 timestamp format. If this value is negative, N/C is printed.

Field Name: RT0231EL

TASK TERMINATION

The time of task termination in Db2 timestamp format.

Field Name: QW0231TT

CPU TIME

Task CPU execution time.

Field Name: QW0231TX

MEMBER

The name of the Db2 member on which the task was executed.

Field Name: QW0231TM

CPU SU CONS

The CPU service units that the task consumed.

Field Name: QW0231SU