DSNH902I U csect-name SEVERE INTERNAL PRECOMPILER OR DB2 COPROCESSOR ERROR IN CONVERSION FROM CCSID ccsid-1 TO CCSID ccsid-2, REASON reason-number

Explanation

Db2 parses SQL statements in Unicode UTF-8 (CCSID 1208). The Db2 precompiler or coprocessor will convert the application program internally (not externally) from the application source EBCDIC CCSID to UTF-8 for processing. In some cases, Db2 also converts portions from UTF-8 back to the source EBCDIC CCSID. This message indicates that a severe error has occurred in the internal conversion.

csect-name

The name of the control section that issued the message.

ccsid-1

The original CCSID.

ccsid-2

The converted CCSID.

reason-number

The reason for the message, indicated by one of the following values:

001

The buffer used as part of the interface between the Db2 coprocessor and the host language compiler is too small for the conversion. This reason code can be returned when certain special registers are referenced in your query, and Db2 converts them in this buffer, such as CURRENT SERVER and CURRENT PACKAGESET. If the problem is encountered because of references to a special register, try assigning the value of the special register to a host variable and then replace references to the special register in your query with a reference to the host variable. For example:

1. SET :HV = CURRENT SERVER
2. Update your query to replace references to CURRENT SERVER with :HV

002

An invalid code point was found during conversion.

003

The string being converted does not conform to the rules for valid data.

004

A miscellaneous error occurred on conversion.