PH08630: INZI009E WHEN UNLOADING GRAPHIC DATA FROM A COLUMN Z669

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload run in native mode ends with completion code 8 after
  having issued a message reporting a CCSID conversion failure
  such as:
     INZI009E CUNLCNV ERROR : RC rc, REASON reason
     CONVERSION BETWEEN CCSID 37 AND CCSID dbcs-ccsid
  where dbcs-ccsid is the Db2 subsystem DBCS CCSID.
  This occurs when :
  - the table to unload has versions.
  - the table is encoded in EBCDIC or ASCII.
  - the Db2 subsystem/data sharing group is mixed.
  - the conversion of the blank encoded in CCSID 37 (0x40) into
    the DBCS CCSID of the table space is not allowed by the IBM
    CUNLCNV converter.
  - the "Unicode Conversion Services substitution character mode
    (VZM008/SCUNSUB)" parameter is set to NO
  
  PB55919
  

Local fix

• run the unload in SQL mode by specifying the DB2 FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for z/O *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload run in native mode ends with  *
  *                      completion code 8 after having issued   *
  *                      a message reporting a CCSID conversion  *
  *                      failure such as:                        *
  *                                                              *
  *                       INZI009E CUNLCNV ERROR : RC rc, REASON *
  *                       reason                                 *
  *                       CONVERSION BETWEEN CCSID 37 AND CCSID  *
  *                       dbcs-ccsid                             *
  *                                                              *
  *                       where dbcs-ccsid is the Db2 subsystem  *
  *                       DBCS CCSID.                            *
  *                                                              *
  *                      This occurs when :                      *
  *                       - the table to unload has versions.    *
  *                       - the table is encoded in EBCDIC or    *
  *                         ASCII.                               *
  *                       - the Db2 subsystem/data sharing group *
  *                         is mixed.                            *
  *                       - the conversion services are availabl *
  *                       - the conversion of the blank encoded  *
  *                         in CCSID 37 (0x40) into the DBCS     *
  *                         CCSID of the table space to unload i *
  *                         not allowed by the IBM CUNLCNV       *
  *                         converter.                           *
  *                       - the "Unicode Conversion Services     *
  *                         substitution character mode          *
  *                         (VZM008/SCUNSUB)" parameter is set   *
  *                         to NO                                *
  *                                                              *
  *                      Workaround fix: run the unload in SQL   *
  *                      mode by specifying the DB2 FORCE option *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem
  

Problem conclusion

• Apply the PTF for problem resolution
  

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:

  UI61744

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI61744

     UP19/03/13 P F903

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.