PK34295: HPU UNLOAD FAILS WITH RC=8, BUT NO EXPLANATORY MESSAGE WHEN THE UNLOAD PROCESSES CCSIDS THAT ARE NOT LISTED IN THE UNICODE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU UNLOAD fails with rc=8, but no explanatory message when
  the UNLOAD must process CCSID pairs that are not listed in the
  UNICODE conversion tables.
  ADDITIONAL SYMPTOMS:
  1) MSGINZX133 SW7A0    NO VALID INPUT DDNAME CPYDDNn  FOUND,
     PARTITION n NOT UNLOADED
  

Local fix

• Identify the CCSIDs associated with the data and add them to
  the UNICODE conversion tables. This apar will provide a message
  to identify the CCSIDs needed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU UNLOAD fails with rc=8, but no      *
  *                      explanatory message when the UNLOAD     *
  *                      must process CCSID pairs that are not   *
  *                      listed in the UNICODE conversion        *
  *                      tables.                                 *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1. MSGINZX133 SW7A0    NO VALID INPUT   *
  *                      DDNAME CPYDDNn  FOUND,  PARTITION n     *
  *                      NOT UNLOADED.                           *
  *                      2. Potential abend S0C4 when an         *
  *                      expression containing a function with   *
  *                      a single argument is used in a SELECT   *
  *                      of a WHERE clause in a supported        *
  *                      select processed natively.              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module odb2util was changed to keep the utilid and the SSID in
  SBCS, and the SYSPRINT file is now closed just before the
  DSNUTILB invocation.
  1. Modules inzbabAnalyseNativTask(), inzctrlCheckCopyDdn() and
  inzcontrolCheckDdn() were changed to enforce control made on the
  input ddnames and to check if a FIC is used as input before
  using the GBLPARAL parameter to force parallelism.
  2. Module inzpabfComputeSqlWrkSize() was changed to process
  correctly expressions containing a single argument.
  

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:

  UK20881 UK20882

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK20881

     UP06/12/28 P F612

• R220 PSY UK20882

     UP06/12/28 P F612

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.