PH23966: UNDUE ALLOCATION ERROR FOR A NATIVE UNLOAD INVOLVING THE NON YETCREATED LDS OF A TABLE SPACE OR PARTITION CREATED WITH DEFINE NO

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the enhancmeent for PH14986/PB50081 has been applied, Db2
  HPU unduly terminates with return code of 8 after having issued
  the following error messages
  INZI800E ERROR ACCESSING TO A DATASET. ACTION: ALLOCATE RC:
  0x1708 REASON: 0x2
  INZU362E UNLOAD 00001 FROM TABLESPACE dbname.tsname FAILED
  POS(1, 1) RC = 0x58a008
  INZU447E AN ERROR OCCURRED DURING UNLOAD PROCESSING - REFER TO
  PREVIOUS EXPLANATION
  This occurs when the following conditions are fulfilled:
  - the unload is run in native mode
  - the data is unloaded from the online table space (not from an
  an image copy)
  - the table space or partition of table space involved by the
  unload  was created with the DEFINE NO attribute and the related
  LDS has not been created yet
  

Local fix

• Except for a physical unload (UNLDDN option) or a logical unload
  with FORMAT INTERNAL, consider runinng the unload in SQL mode by
  specifying the DB2 FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the enhancement for               *
  *                      PH14986/PB50081 has been applied,       *
  *                      Db2 HPU unduly terminates with return   *
  *                      code of 8 after having issued  the      *
  *                      following error messages                *
  *                      INZI800E ERROR ACCESSING TO A DATASET.  *
  *                      ACTION: ALLOCATE RC: 0x1708 REASON: 0x2 *
  *                      INZU362E UNLOAD 00001 FROM TABLESPACE   *
  *                      dbname.tsname FAILED                    *
  *                      POS(1, 1) RC = 0x58a008                 *
  *                      INZU447E AN ERROR OCCURRED DURING       *
  *                      UNLOAD PROCESSING - REFER TO PREVIOUS   *
  *                      EXPLANATION                             *
  *                                                              *
  *                      This occurs when the following          *
  *                      conditions are fulfilled :              *
  *                      - the unload is run in native mode      *
  *                      - the data is unloaded from the online  *
  *                      table space (not from an an image copy) *
  *                      - the table space or partition of table *
  *                      space involved by the unload was        *
  *                      created with the DEFINE NO attribute    *
  *                      and the related LDS has not been        *
  *                      created yet                             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Undue allocation error for a native unload involving the non yet
  created LDS of a table space or partition created with DEFINE NO
  

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 INZCHECK INZSGEN  INZTDSC  INZTPMEM INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69029

     UP20/04/22 P F004

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.