IFCID 366 - Incompatible Functions Executed

The IFCID 366 record block provides detailed statistics about incompatible functions that have executed..

Record trace - IFCID 366 - Incompatible Functions Executed


                                          INCOMPATIBLE FUNCTIONS EXECUTED                                                 
                                                                                                                          
COLLECTION ID    :  DSNTEP3                                                                                               
PROGRAM NAME     :  DSNTEP3                                                                                               
TYPE             :                    1  REASON        : V9 SYSIBM.CHAR(DECIMAL-EXPR) FUNCTION                            
STMT NBR QUERY   :                 2819  SECTION       :          1            PLAN NAME QUERY: DSNTEP3                   
STMT ID          :                    2  STMT TYPE     : DYNAMIC               CONTOKEN (TS)  : X'18CD6DAF04C72605'       
VERSION LENGTH   :                    8  VERSION       : VERSION1                                                         
.........................................................................................................................

The fields shown in this record block are described below. Db2 field names are shown in brackets next to each report field.

COLLECTION ID [QW0366PC]

The package collection ID.

PROGRAM NAME [QW0366PN]

The program name.

TYPE [QW0366FN]

The change indicator is incompatible. Valid values are:

1: V9 SYSIBM.CHAR(decimal-expr) function
2: V9 SYSIBM.VARCHAR(decimal-expr) function. CAST (decimal as VARCHAR or CHAR)
3: Unsupported character string representation of a timestamp
1101: Insert into an XML column without XMLDOCUMENT function
1102: XPath evaluation error
1103: RLF governing
1104: Long CLIENT_ACCTNG Special Reg value
1105: Long CLIENT_APPLNAME Special Reg value
1106: Long CLIENT_USERID Special Reg value
1107: Long CLIENT_WRKSTNNAME Special Reg value
1108: Long client Special Reg value for RLF
1109: CAST(string AS TIMESTAMP)
1110: SPACE integer argument greater than 32764
1111: VARCHAR int argument greater than 32764

Note: REASON shows the description of the incompatible change indicator according to the Db2 macro. If the indicator is not known, N/A is shown in the report.

REASON [QW0366FN]

The change indicator is incompatible. It can have the following values:

1: V9 SYSIBM.CHAR(decimal-expr) function
2: V9 SYSIBM.VARCHAR(decimal-expr) function. CAST (decimal as VARCHAR or CHAR)
3: Unsupported character string representation of a timestamp
1101: Insert into an XML column without XMLDOCUMENT function
1102: XPath evaluation error
1103: RLF governing
1104: Long CLIENT_ACCTNG Special Reg value
1105: Long CLIENT_APPLNAME Special Reg value
1106: Long CLIENT_USERID Special Reg value
1107: Long CLIENT_WRKSTNNAME Special Reg value
1108: Long client Special Reg value for RLF
1109: CAST(string AS TIMESTAMP)
1110: SPACE integer argument greater than 32764
1111: VARCHAR int argument greater than 32764

Note: REASON shows the description of the incompatible change indicator according to the Db2 macro. If the indicator is not known, N/A is shown in the report.

STMT NBR QUERY [QW0366SN]

The statement number of the query.

SECTION [QW0366SE]

The section number.

PLAN NAME QUERY [QW0366PL]

The plan name of the query.

STMT ID [QW0366SI]

The statement identifier.

STMT TYPE [QW0366TY]

The statement information. Valid values are DYNAMIC or STATIC.

CONTOKEN (TS) [QW0366TS]

The consistency token is shown in hexadecimal format.

VERSION LENGTH [QW0366VL]

The version length.

VERSION [QW0366VN]

The version.