PH21212: ABENDU1021-REASOND WHEN UNLOADING FROM INLINE IMAGE COPY OF COMPRESSED TABLE SPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only) After the enhancement for PH18085 has been
  applied, an unload of the data from a image copys stops with
  ABENDU1021-reasonD and the message INZU552E is issued when the
  following conditions are fulfilled :
  - the image copy must be sorted (COPYDDN LAST_IC/-integer or
  COPYDDN ddname,CHECK and inline or COPYTOCOPY image copy still
  referred in the Db2 catalog or INLINE, COPYTOCOPY, MERGE_IIC
  option)
  - the image copy contains data from a compressed table space
  - the image copy contains a DICTIONARY that is no longer used
  for the online Db2 object because all rows of the whole table or
  partition have been deleted
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the enhancement for PH18085 has   *
  *                      been applied, an unload of the data     *
  *                      from a image copys stops with           *
  *                      ABENDU1021-reasonD and the message      *
  *                      INZU552E is issued when the following   *
  *                      conditions are fulfilled:               *
  *                      - the image copy must be sorted         *
  *                        (COPYDDN LAST_IC/-integer or COPYDDN  *
  *                        ddname,CHECK and inline or COPYTOCOPY *
  *                        image copy still referred in the Db2  *
  *                        catalog or INLINE, COPYTOCOPY,        *
  *                        MERGE_IIC option)                     *
  *                      - the image copy contains data from a   *
  *                        compressed table space                *
  *                      - the image copy contains a DICTIONARY  *
  *                        that is no longer used for the online *
  *                        Db2 object because all rows of the    *
  *                        whole table or partition have been    *
  *                        deleted                               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  ABENDU1021-reasonD when unloading from inline image copy of
  compressed table space
  

Problem conclusion

• Code has been changed to fix this problem.
  

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

• INZ$$PRM INZTDSC  INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI68215

     UP20/03/18 P F003

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.