PI22291: CONVERSION ROUTINE ERROR MESSAGE (* 226 *) ISSUED IF TRIM YES OPTIONS REQUESTED AND LOGICAL UNLOAD IS PROCESSED IN SQL MODE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CONVERSION ROUTINE ERROR message (* 226 *) are unduly issued and
  records are discarded and/or incorrect output is produced for an
  unload where the following conditions are fullfilled:
  - the logical unload involved is processed in SQL mode
  - the table involved by the unload statement has a
    non-EBCDIC ENCODING_SCHEME
  - either of the following is requested
    * the TRIM YES option
    * a conversion from a char data type to a timestamp or
      numeric data type
  
  For example, with the following logical UNLOAD:
  UNLOAD TABLESPACE
  DB2 FORCE
  SELECT
        TBCREATOR
  FROM SYSIBM.SYSINDEXES
  OUTDDN(SYSREC1)
  FORMAT DSNTIAUL
  OPTIONS TRIM YES
  
  messages such as the following are issued
  * 226 * CONVERSION ROUTINE ERROR           * SYSREC1 * TBCREATOR
  
  PB12402
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: CONVERSION ROUTINE ERROR message        *
  *                      (* 226 *) are unduly issued and         *
  *                      records are discarded and/or incorrect  *
  *                      output is produced for an unload where  *
  *                      the following conditions are            *
  *                      fullfilled:                             *
  *                      - the logical unload involved is        *
  *                       processed in SQL mode                  *
  *                      - the table involved by the unload      *
  *                       statement has a non-EBCDIC             *
  *                       ENCODING_SCHEME                        *
  *                      - either of the following is requested  *
  *                        * the TRIM YES option                 *
  *                        * a conversion from a char data type  *
  *                         to a timestamp or numeric data type  *
  *                      For example, with the following logical *
  *                       UNLOAD:                                *
  *                      UNLOAD TABLESPACE                       *
  *                      DB2 FORCE                               *
  *                      SELECT                                  *
  *                            TBCREATOR                         *
  *                      FROM SYSIBM.SYSINDEXES                  *
  *                      OUTDDN(SYSREC1)                         *
  *                      FORMAT DSNTIAUL                         *
  *                      OPTIONS TRIM YES                        *
  *                      messages such as the following are      *
  *                      issued                                  *
  *                      * 226 * CONVERSION ROUTINE ERROR        *
  *                            * SYSREC1 * TBCREATOR             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzgcxtr  module was changed.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI21116

     UP14/09/06 P F409

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.