PH14248: ABENDS0C4 WHEN UNLOADING FROM DB2 CATALOG TABLE IN NATIVE MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU can terminate in abend 0c4 when the following conditions are
  fullfilled:
  - unloading a table from the Db2 catalog
  - the unloaded tablespace contains RID related to Db2 catalog
    intern relation which no longer exists in DB2 V10NFM.
  ABENDS0C4 with the following traceback
  4 osysibmDetermineColPad
    +0000016C 3250 INZUTIL
  5 inzpabfFillVirtualEct
    +00000160 3480 INZUTIL
  6 _inzpabBuildEct
    +0000095E 3038 INZUTIL
  7 _inzpabBuildZpcts
    +00000B2C 3777 INZUTIL
  8 inzpabBuild +00000098 4301 INZUTIL
  9 inzrunRunHpu+000008D2 545 INZUTIL
  
  can occur when running an unload against a table from the Db2
  catalog when the following conditions are fullfilled:
  - the unload is performed in native mode (etiher from the table
    space or from an image copy)
  - the unloaded catalog table belonged to a multi-table
    tablespace in Db2 version prior to V10 and currently belong to
    a single table table space
  - the unloaded tablespace contains RID related to Db2 catalog
    intern relation which no longer exists in DB2 V10NFM .
  PB57964
  

Local fix

• run the unload in SQL mode by specifying Db2 FORCE
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU can terminate in abend 0c4 when     *
  *                      the following conditions are            *
  *                      fullfilled:                             *
  *                      - unloading a table from the Db2        *
  *                        catalog                               *
  *                      - the unloaded tablespace contains      *
  *                        RID related to Db2 catalog intern     *
  *                        relation which no longer exists in    *
  *                        DB2 V10NFM.                           *
  *                      ABENDS0C4 with the following traceback  *
  *                      4 osysibmDetermineColPad                *
  *                        +0000016C 3250 INZUTIL                *
  *                      5 inzpabfFillVirtualEct                 *
  *                        +00000160 3480 INZUTIL                *
  *                      6 _inzpabBuildEct                       *
  *                        +0000095E 3038 INZUTIL                *
  *                      7 _inzpabBuildZpcts                     *
  *                        +00000B2C 3777 INZUTIL                *
  *                      8 inzpabBuild +00000098 4301 INZUTIL    *
  *                      9 inzrunRunHpu+000008D2 545 INZUTIL     *
  *                      can occur when running an unload        *
  *                      against a table from the Db2 catalog    *
  *                      when the following conditions are       *
  *                      fullfilled:                             *
  *                      - the unload is performed in native     *
  *                        mode (either from the table space     *
  *                        or from an image copy)                *
  *                      - the unloaded catalog table belonged   *
  *                        to a multi-table tablespace in Db2    *
  *                        version prior to V10 and currently    *
  *                        belong to a single table table space  *
  *                      - the unloaded tablespace contains RID  *
  *                        related to Db2 catalog intern         *
  *                        relation which no longer exists in    *
  *                        DB2 V10NFM.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem.
  

Problem conclusion

• Apply the PTF.
  Workaround: run the unload in SQL mode by specifying Db2 FORCE
  

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:

  UI64706

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI64706

     UP19/08/16 P F908

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.