IFCID 222 - Parallel Group Elapsed Time

This topic shows detailed information about Record Trace - IFCID 222 - Parallel Group Elapsed Time.

This record contains parallel group elapsed time information.

Record trace - IFCID 222 - Parallel Group Elapsed Time

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


RECORD     1 OF     1
LOCATION: M05EC003          PACKAGE: PRODCOLL            PROGRAM: CSF3SP04            CON.TOKEN: X'15B995940B8DACAA'
STATEMENT NO:    84  QUERY BLOCK NO:     1  PARALLEL GROUP NO:     1  REPEAT.GRPS:     2
PIPE CREATION: 12/18/08 16:35:47.148952  PIPE TERMINATION: 12/18/08 16:35:47.493512  PIPE ELAPSED:         0.344560
QW0222FM      0   QW0222CS      0   QW0222PR         103 QW0222OD      0
.......................................................................................................................
SUB-PIPE CREATION   : 12/18/08 16:35:47.242775  SUB-PIPE ELAPSED:         0.076436
SUB-PIPE TERMINATION: 12/18/08 16:35:47.319211  TASK TOKEN      : X'7B450138'        MEMBER      : 'BLANK'
QW0222SR          21   QW0222OR           0   QW0222CT           0
.......................................................................................................................
SUB-PIPE CREATION   : 12/18/08 16:35:47.319217  SUB-PIPE ELAPSED:         0.059854
SUB-PIPE TERMINATION: 12/18/98 16:35:47.379071  TASK TOKEN      : X'7B45015C'        MEMBER      : 'BLANK'
QW0222SR          82   QW0222OR           0   QW0222CT           0

RECORD

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

Field Name: QW0222TR

OF

The total number of IFCID 222 records in this series.

Field Name: QW0222NR

LOCATION

The location name or RDB name.

Field Name: QW0222LN

PACKAGE

The package collection ID.

Field Name: QW0222PC

PROGRAM

The program name.

Field Name: QW0222PN

CON.TOKEN

The timestamp (consistency token).

Field Name: QW0222TS

STATEMENT NO

The statement number.

Field Name: QW0222SN

QUERY BLOCK NO

The query block number.

Field Name: QW0222QN

PARALLEL GROUP NO

The parallel group number.

Field Name: QW0222GN

REPEAT.GRPS

The number of repeat groups in the section.

Field Name: QW0222RN

PIPE CREATION

The time of pipe creation in DB2 timestamp format.

Field Name: QW0222PS

PIPE TERMINATION

The time of pipe termination in DB2 timestamp format.

The elapsed time between pipe creation and pipe termination in DB2 timestamp format.

Field Name: QW0222PE

SUB-PIPE CREATION

The time of subpipe creation in DB2 timestamp format.

Field Name: QW0222SS

SUB-PIPE ELAPSED

The elapsed time between subpipe creation and subpipe termination in DB2 timestamp format.

The time of subpipe termination in DB2 timestamp format.

Field Name: QW0222SE

TASK TOKEN

The task token associated with the subpipe.

Field Name: QW0222TK

MEMBER

The name of the DB2 member that supplies the data.

Field Name: QW0222SM