PK95015: HPU UNLOAD GENERATES INCORRECT LOADDN WITH TYPE UNKNOWN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU UNLOAD generates incorrect TYPE UNKNOWN instead of BINARY
  or VARBINARY in LOADDDN    PB 10220
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. For SELECT processed natively, when  *
  *                       a CCSID conversion needs to be done    *
  *                       in a LIKE predicate and the CCSID of   *
  *                       the 'left' expression is not           *
  *                       determined during initialization, the  *
  *                       LIKE predicate is incorrectly          *
  *                       evaluated and generally, no rows is    *
  *                       returned.                              *
  *                      - Identical problem with the LTRIM,     *
  *                       RTRIM and STRIP scalar functions       *
  *                       applied on an expression which CCSID   *
  *                       is not determined during               *
  *                       initialization.                        *
  *                      - Identical problem with the CASE       *
  *                       expression when the WHEN uses a        *
  *                       constant that needs to be converted,   *
  *                       and the THEN uses an expression which  *
  *                       CCSID is not determined during         *
  *                       initialization.                        *
  *                      - Identical problem with the CHAR       *
  *                       scalar function when implicit padding  *
  *                       needs to be done for comparison with   *
  *                       a constant that needs CCSID            *
  *                       conversion, and the CCSID is not       *
  *                       determined during initialization.      *
  *                      PB 10046                                *
  *                      2. On a SELECT processed natively,      *
  *                      when a VARCHAR scalar function is       *
  *                      applied on a GRAPHIC constant, the      *
  *                      result does not contain the shift in    *
  *                      and shift out characters (x'0E' and     *
  *                      x'0F').                                 *
  *                      10201                                   *
  *                      3. Error message                        *
  *                      INZU238E UNEXPECTED UNSUPPORTED SELECT  *
  *                        UTILITY CANNOT SWITCH TO SQL          *
  *                        PROCESSING REASON 0Xc0018/0X12705310  *
  *                      is issued when unloading in EBCDIC an   *
  *                      UNICODE or ASCII table with a WHERE     *
  *                      clause that contains a CHAR or VARCHAR  *
  *                      scalar function applied on a GRAPHIC    *
  *                      or VARGRAPHIC column.                   *
  *                      The same error message can also occur   *
  *                      on an UNICODE or ASCII table when       *
  *                      unloading in EBCDOC and using a single  *
  *                      CASE expression that can return either  *
  *                      a CHAR or a GRAPHIC column.             *
  *                      PB 10216                                *
  *                      4. When unloading some BINARY or        *
  *                      VARBINARY columns, UNKNOWN is generated *
  *                      in the LOADDDN file instead of the      *
  *                      correct data type.                      *
  *                      PB 10220                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module INZNODE: New function inznodeGetCcsid() has been
  created to process correctly the CCSID at time of execution.
  2. Module inzctrl  was changed to remove the optimization done
  on VARCHAR scalar function applied on constants.
  3. Module INZNODE was changed: function inznodeResolveConversion
  was modified to resolve the CCSID conversion when needed.
  4. Module inzrload was changed to support BUNARY and VARBINARY
  types.
  

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:

  UK51771

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK51771

     UP09/11/11 P F911

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.