PH36298: AFTER PH18085, DICTIONARY WITH HPGZLD=NULL NO LONGER TOLERATED AS REPORTED BY INZRE42

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU 5.1 only) After the enhancement PH18085/PB52954,the unload
  stops with completion code of 8 after having issued an INZRE42
  message.
  This occurs when the following conditions are fulfilled :
  - the unload is run in native mode
  - the tablespace contains compressed rows
  - the dictionary is present in the tablespace LDSes but its type
  (field HPGZLD) in the header page is Null (i.e. 0x00).
  This unexpected value should be handled by Db2 HPU as a synonym
  of the 'F' and 'L' values.
  

Local fix

• run the unload in SQL mode or, if using the native mode is
  important, consider reorganizing the tablespace with a Db2
  fully-compliant REORG utility.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the enhancement PH18085/PB52954,  *
  *                      the unload stops with completion code   *
  *                      of 8 after having issued an INZRE42     *
  *                      message.                                *
  *                                                              *
  *                      This occurs when the following          *
  *                      conditions are fulfilled :              *
  *                      - the unload is run in native mode      *
  *                      - the tablespace contains compressed    *
  *                      rows                                    *
  *                      - the dictionary is present in the      *
  *                      tablespace LDSes but its type           *
  *                      (field HPGZLD) in the header page is    *
  *                      Null (i.e. 0x00).                       *
  *                                                              *
  *                      This unexpected value should be handled *
  *                      by Db2 HPU as a synonym of the 'F' and  *
  *                      'L' values.                             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After PH18085, dictionary with HPGZLD=Null no longer tolerated
  as reported by INZRE42.
  

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  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI75101

     UP21/05/07 P F105 {

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.