PI70006: UNICODE INSTEAD OF EBCDIC SPECIFIED IN THE LOAD STATEMENT GENERATED WITH LOADDDN OPTION RUN IN NATIVE MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An irrelevant encoding specification (UNICODE instead of EBCDIC)
  is specified in the LOAD statement generated (LOADDDN option) if
  the following conditions are fulfilled:
  
  - the unload is run in native mode
  - the DB2 subsystem is a non mixed one
  - the table to be unloaded belong to:
      - a database UNICODE non SBCS (
     i.e. DBCS ou MIXED) CCSID specified
      - a tablespace defined with EBCDIC encoding scheme
        the output encoding scheme ASIS is requested
        (either by specifying in the UNLOAD command or
        by default through the "Default scheme for
        UNLOAD TABLESPACE" (VUU023/UNLSCHEM) set to ASIS).
  
  PB46838
  

Local fix

• Request an EBCDIC output encoding scheme.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An irrelevant encoding specification    *
  *                      (UNICODE instead of EBCDIC) is          *
  *                      specified in the LOAD statement         *
  *                      generated (LOADDDN option) if the       *
  *                      following conditions are fulfilled:     *
  *                      - the DB2 subsystem is a non mixed one  *
  *                      - the table to be unloaded belongs to : *
  *                       - a database UNICODE non SBCS (i.e.    *
  *                        DBCS or MIXED) CCSID specified        *
  *                       - a tablespace defined with EBCDIC     *
  *                        encoding scheme the output encoding   *
  *                        scheme ASIS is requested (either by   *
  *                        specifying in the UNLOAD command or   *
  *                        by default through the "Default       *
  *                        scheme for UNLOAD TABLESPACE"         *
  *                        (VUU023/UNLSCHEM) set to ASIS).       *
  *                      pb46838                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The osysibm module was changed.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

• ×**** PE16/11/07 FIX IN ERROR. SEE APAR PI71885  FOR DESCRIPTION
  

APAR Information

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

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

  UI42179 UI42180

Modules/Macros

•    INZQRYV8 INZQUERY INZTPMEM INZUTILK INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI42179

     UP16/11/05 P F611

• R430 PSY UI42180

     UP16/11/05 P F611

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.