IFCID 376 - Incompatible Functions Executed

This topic shows detailed information about "Record Trace - IFCID 376 - Incompatible Functions Executed".

This trace record is written once for each unique dynamic cached statement and static statement. It is similar to IFCID 366, however IFCID 366 can be written more frequently.

Record trace - IFCID 376 - Incompatible Functions Executed

The field labels shown in the following sample layout of "Record Trace - IFCID 376 - Incompatible Functions Executed" are described in the following section.

                                          INCOMPATIBLE FUNCTIONS EXECUTED                                                 
                                                                                                                          
COLLECTION ID    :  NULLID                                                                                                
PROGRAM NAME     :  SYSLH200                                                                                              
                                                                                                                          
TYPE             :                 1109  REASON        : CAST(STRING AS TIMESTAMP)                                        
STMT NBR QUERY   :                    0  SECTION       :          1            PLAN NAME QUERY: DISTSERV                  
STMT ID          :                   29  STMT TYPE     : DYNAMIC               CONTOKEN (TS)  : X'5359534C564C3031'       
VERSION LENGTH   :                    0  VERSION       : 'BLANK'                                                          
-------------------------------------------------------------------------------------------------------------------------

COLLECTION ID

The package collection ID.

Field Name: QW0376PC

PROGRAM NAME

The program name.

Field Name: QW0376PN

TYPE

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
9: Ignore time zone in hostvar BIND in TMSTZ data type to TMS
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.

Field Name: QW0376FN

REASON

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
9: Ignore time zone in hostvar BIND in TMSTZ data type to TMS
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.

Field Name: QW0376FN

STMT NBR QUERY

The statement number of the query.

Field Name: QW0376SN

SECTION

The section number.

Field Name: QW0376SE

PLAN NAME QUERY

The plan name of the query.

Field Name: QW0376PL

STMT ID

The statement identifier.

Field Name: QW0376SI

STMT TYPE

The statement information. It can be a DYNAMIC or STATIC statement.

Field Name: QW0376TY

CONTOKEN (TS)

The consistency token is shown in hexadecimal format.

Field Name: QW0376TS

VERSION LENGTH

Length of version field QW0376VE.

Field Name: QW0376VL

VERSION

The version (max. 64-character string).

Field Name: QW0376VN

Feedback