IFCID 360 - Incrementally Rebound Queries

This topic shows detailed information about Record Trace - IFCID 360 - Incrementally Rebound Queries.

IFCID 360 records information about queries that are incrementally rebound, because parallelism was chosen in packages that were created before Db2 10. This record is written when performance trace class 3 or 10 is on.

PLAN NAME .......: PLNAPPLX              QUERY STMT NUMBER:                  212  QUERY SECT NUMBER:                    2
COLLECTION NAME .: PARA                                                                                                  
PACKAGE NAME ....: APPLX                                                                                                 
PKG CONSIST TOKEN: X'ABCDEFFFFFFFFFFF'                                                                            

PLAN NAME

The name of the plan.

Field Name: QW0360PLAN

QUERY STMT NUMBER

The query statement number.

Field Name: QW0360STMTNO

QUERY SECT NUMBER

The query section number.

Field Name: QW0360SECTN

COLLECTION NAME

The name of the package collection ID.

Field Name: QW0360COLLIDN

PACKAGE NAME

The name of the package.

Field Name: QW0360PKGIDN

PKG CONSIST TOKEN

The package consistency token.

Field Name: QW0360CONTK