IFCID 224 - Select Procedure Bypassed

This topic shows detailed information about Record Trace - IFCID 224 - Select Procedure Bypassed.

This record is written at the end of a unit of work. It records the total columns for which an invalid select procedure was encountered. Invalid select procedures are bypassed by Db2 and can cause performance degradation.

Record trace - IFCID 224 - Select Procedure Bypassed

The field labels shown in the following sample layout of Record Trace - IFCID 224 - Select Procedure Bypassed are described in the following section.


SPROC BYPASSED 'BLANK'
NETWORKID:  DEIBMIPS  LUNAME:  IPSAR721  LUWSEQ:     1
PACKAGE   : PLANNAM2
COLLECTION: COLLECTIONNAME0002
COLUMNS   :        128

COLUMNS

The select procedure bypass column count. This is the total number of columns (rows * columns) for which a select procedure was bypassed because the select procedure was invalidated by applying service to Db2.

Field Name: QW0224CL

PACKAGE

Package name.

Field Name: QW0224PN

COLLECTION ID

Collection identifier.

Field Name: QW0224CI