PQ92538: AE PQ91548

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AE PQ91548
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1) Various problems when using the PART *
  *                      option.                                 *
  *                      1- S0C4 ABEND if PART(n:m) with n > m   *
  *                      and the PART option is coded at the     *
  *                      select_block level.                     *
  *                      2- msgINZU154E 154E is issued when      *
  *                      PART(k:l, n:m) and DB2 level is less    *
  *                      than V8                                 *
  *                                                              *
  *                      2)HPU unloads incorrect data for        *
  *                      columns added to a table by:            *
  *                      either ALTER ADD column type WITH       *
  *                      DEFAULT CURRENT SQLID                   *
  *                      or ALTER ADD column type WITH           *
  *                      DEFAULT USER.                           *
  *                                                              *
  *                      This occurs if the table has not been   *
  *                      reaorganized since the ALTER was        *
  *                      performed.                              *
  *                      Instead of unloading the CURRENT SQLID  *
  *                      or USER authorisation ID at the time    *
  *                      of ALTAR (value stored in DEFAULT VALUE *
  *                      columns in SYSIBM.SYSCOLUMS).           *
  *                                                              *
  *                      Detailed description:                   *
  *                                                              *
  *                      * For columns WITH DEFAULT CURRENT      *
  *                      SQLID                                   *
  *                      HPU always unloads the authorization    *
  *                      id of the user running HPU.             *
  *                                                              *
  *                      * For columns WITH DEFAULT USER         *
  *                      HPU unloads data depending on the       *
  *                      UTILID specified withn the PARM field   *
  *                      of the EXEC card.                       *
  *                      - If UTILID is blank, HPU unloads data  *
  *                      such as USER.JOBNAME (where USER is the *
  *                      authorization ID of the user running    *
  *                      HPU and JOBNAME is the name of the job  *
  *                      in which HPU is running. The value      *
  *                      unloaded is actually the left 8         *
  *                      characters of the concatenation.        *
  *                      - If UTILID is not blank, HPU unloads   *
  *                      data such as UTILID up to 8 charaters   *
  *                                                              *
  *                      3) Unpredictable result when unloading  *
  *                      from INLINE copies. S0C4 ABEND or CC=0  *
  *                      with corrupted data may result of using *
  *                      an INLINE image copy as input of HPU    *
  *                      (COPYDDN keyword).                      *
  *                                                              *
  *                      4) The processing of the IN predicate   *
  *                      followed by a list of values may unload *
  *                      a wrong set of rows or no row at all.   *
  *                      This may occurs when the values in the  *
  *                      list end with blank characters.         *
  ****************************************************************
  * RECOMMENDATION: Install this APAR PQ92538.                   *
  ****************************************************************
  

Problem conclusion

• 1) IHYACC, IFYACC, IPYACC and ODB2CMD were modified. This way,
  the parser rejects PART(n:m) with n>m and the routine building
  the DISPLAY command changes partitions ranges into partition
  lists so that the command is valid for any DB2 release.
  2) INZBAB module was changed. For tables having columns which
  DEFAULT in SYSCOLUMNS is 'S' or 'U', HPU now unloads the value
  indicated by the DEFAULTVALUE column if it is NOT NULL
  (meaning an ALTER ADD columns has been performed).
  3) UDBCRTIC was changed to restore the previous way of sorting
  INLINE image copies.
  4) Module UDBSCAND was fixed to process correctly the list of
  values in the IN predicate.
  

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:

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UQ91850

     UP04/08/20 P F408

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.