IFCID 363 - Data Section QW0363

This topic shows detailed information about Record Trace - IFCID 363 - Data Section QW0363.

Record trace - IFCID 363 - Data Section QW0363

The field labels shown in the following sample layout of Record Trace - IFCID 363 - Data Section QW0363 are described in the following section.


RECORD      1 OF     1
LOCATION NAME    :  STLEC1
PACKAGE NAME     :  DSNTEP3
PROGRAM NAME     :  DSNTEP3
CONSISTENCY TOKEN: X'1846EC1906E9322D'
STATEMENT NO     :       2189           QUERY BLOCK NO   :          1            PAR. GROUP NO    :          1
PLANNED DEGREE   :          2           PARTITION KIND   : PAGE RANGE            RECORDS ORDER    : N/P
IN MEM WORKFILE  : N                    INPUT RID IN WKF : N                     OUTPUT RID IN WKF: N
TOTAL INPT ELEM #:          4           TOTAL RECORDS #  :                     0 ACTUAL USED WIOEs:          4
PIPE DEGREE      :          2
PIPE CREATION    : 12/02/09 10:59:42.827082
PIPE TERMINATION : 12/02/09 10:59:42.838217
PIPE ELAPSED     :         0.011135

LOCATION NAME

The location name.

Field Name: QW0363LN

PACKAGE NAME

The package name.

Field Name: QW0363PC

PROGRAM NAME

The program name.

Field Name: QW0363PN

CONSISTENCY TOKEN

The time stamp.

Field Name: QW0363TS

STATEMENT NO

The statement number.

Field Name: QW0363SN

QUERY BLOCK NO

The query block number.

Field Name: QW0363QN

PAR. GROUP NO

The parallel group number.

Field Name: QW0363GN

PLANNED DEGREE

The planned (bind time) degree.

Field Name: QW0363BD

PARTITION KIND

The partition kind of the parallel.

Field Name: QW0363RK

RECORDS ORDER

The record order: descending or ascending.

Field Name: QW0363OD

IN MEM WORKFILE

Record in memory work file.

Field Name: QW0363IW

INPUT RID IN WKF

Input RID in work file.

Field Name: QW0363RI

OUTPUT RID IN WKF

Output RID in work file.

Field Name: QW0363RO

TOTAL INPT ELEM #

The total number of elements.

Field Name: QW0363NE

TOTAL RECORDS #

The total number of records.

Field Name: QW0363NR

ACTUAL USED WIOEs

Number of actual elements.

Field Name: QW0363AE

PIPE DEGREE

The pipe degree.

Field Name: QW0363PD

PIPE CREATION

The start time of the pipe.

Field Name: QW0363PS

PIPE TERMINATION

The end time of the pipe.

Field Name: QW0363PT

PIPE ELAPSED

The time elapsed between the start and end time of the pipe.

Field Name: RT0363PE