PM34564: V4.1 HPU ' WITH UR ' SUPPORT GENERATES DIFFERENT BEHAVIOR THAN PRIOR HPU RELEASES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• HPU v4.1 now supports the WITH UR clause.  See HPU v4.1 Users
  Guide for details on the new WITH UR clause support.
  
  Unload statements specifying DB2 YES and WITH UR are processed
  in native mode, i.e. outside of DB2, while they used to be
  processed in SQL mode in previous releases.
  
  In some specific cases, this might lead to undesired changes in
  the existing unload steps such as:
  - the generated LOAD statement take the identity columns into
    account (field names for identity columns are different and
    IGNOREFIELDS option is added)
  - performance changes
  - string constants are handled as CHAR instead of VARCHAR
    where FORMAT USER is requested.
  
  This PTF adds support for a new value (BY_SQL_ONLY(WITH UR))
  for VUU030/ULOPTNS to force SQL mode for processing of the
  statements with a "WITH UR" clause.
  
  PB11091
  

Local fix

• To get the same outpout that was produced by previous releases
  of HPU.  Replace the DB2 YES option by DB2 FORCE where the
  unload statement specifies the WITH UR clause.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: From DB2 HPU 4.1 release, unload        *
  *                      statements specifying DB2 YES and WITH  *
  *                      UR are processed in native mode,        *
  *                      i.e. outside of DB2, while they used    *
  *                      to be processed in SQL mode in          *
  *                      previous releases.                      *
  *                      In some specific cases, this might      *
  *                      lead to undesired changes in the        *
  *                      existing unload steps such as:          *
  *                      - the generated LOAD statement take     *
  *                        the identity columns into account     *
  *                        (field names for identity columns     *
  *                        are different and IGNOREFIELDS        *
  *                        option is added)                      *
  *                      - performance changes                   *
  *                      - string constants are handled as CHAR  *
  *                      instead of VARCHAR where FORMAT USER    *
  *                      is requested.                           *
  *                      PB 11091                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzmain  and inzhyacc modules were changed to allow the WITH
  UR clause to be considered as unsupported and thus processed in
  SQL mode.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

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

• R410 PSY UK66639

     UP11/04/19 P F104

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.