IFCID 221 - Parallel Data

This topic shows detailed information about Record Trace - IFCID 221 - Parallel Data.

Record trace - IFCID 221 - Parallel Data

The field labels shown in the following sample layout of Record Trace - IFCID 221 - Parallel Data are described in the following section.


PARALLEL DATA
LOCATION NAME     : 'BLANK'
PKG COLLECTION ID : 'BLANK'
PROGRAM NAME      : 'BLANK'
STMT.NO :        1077952576   QUERYBLOCK NUMBER :      16448           CONS.TOKEN     : X'4040404040404040'
PLANNED(BIND) DEGREE: 16448   REP.SECTION TYPE  : N/P                  PARALL.GROUP NO: 16448
PLANNED(RUN)  DEGREE: 16448   ACTUAL(RUN) DEGREE:      16448           REP.SECTIONS   : 16448
TYPE OF PARALLELISM : X'40'   NUMBER OF MEMBERS : 1077952576           REASON         : X'40'       RECORD 16448 OF 16448
HI/LO PARTITION TYPE: LOGICAL

LOCATION NAME

The location name or RDB name.

Field Name: QW0221LN

PKG COLLECTION ID

The package collection ID.

Field Name: QW0221PC

PROGRAM NAME

The program name.

Field Name: QW0221PN

STMT.NO

The statement number. It is the same as the QUERYNO in the PLAN_TABLE, if the PLAN_TABLE exists.

Field Name: QW0221SN

QUERYBLOCK NUMBER

The query block number. It is the same as the QBLOCKNO in the PLAN_TABLE, if the PLAN_TABLE exists.

Field Name: QW0221QN

CONS.TOKEN

The timestamp (consistency token).

Field Name: QW0221TS

PLANNED(BIND) DEGREE

The planned degree of parallelism at bind time. Parallelism decisions are made at bind time. However, the value in this field is 0 if the statement has host variables, because host variables cause the parallelism decision to be made at run time. See field PLANNED(RUN) DEGREE.

Field Name: QW0221PD

REP.SECTION TYPE

The type of the repeating section.

Field Name: QW0221TP

PARALL.GROUP NO

The parallel group number.

Field Name: QW0221GN

PLANNED(RUN) DEGREE

The planned degree of parallelism at run time. The value in this field is equal to the value in PLANNED(BIND) DEGREE unless the statement contains host variables.

Field Name: QW0221RD

ACTUAL(RUN) DEGREE

The actual degree of parallelism at run time, taking into account only those Db2 members that have enough buffer pool storage.

Field Name: QW0221AD

REP.SECTIONS

The number of repeating sections contained in this record.

Field Name: QW0221N

TYPE OF PARALLELISM

The type of parallelism:

CP: CPU query parallelism
I/O: I/O query parallelism
SYS: Sysplex query parallelism

Field Name: QW0221MO

NUMBER OF MEMBERS

The number of Db2 members on which a query was executed during sysplex query parallel processing.

Field Name: QW0221XC

REASON

The reason for deriving the planned (runtime) degree of parallelism:

NORMAL: The planned runtime degree is derived from the planned bind time degree.
HOSTVAR: Host variable partitioning.
NO ESA: No ESA sort support.
CURSOR: The cursor might be used for an update or deletion.
EMPTY: The parallel group is empty.
MVS/ESA: MVS/ESA enclave services are not available.

Field Name: QW0221RN

RECORD

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

Field Name: QW0221TR

OF

The total number of IFCID 221 records in this series.

Field Name: QW0221NR

HI/LO PARTITION TYPE

Type of partition for low and high pages in the partition range. Possible values are:

LOGICAL: Logical low and high pages.
PHYSICAL: Physical low and high pages.

Field Name: QW0221ZZ