PI61522: MSGINZRE42 AND COMPLETION CODE 8 WHEN ATTEMPTING TO RUN HPU UNLOAD AGAINST THE TABLE SPACE (I.E. IN NATIVE MODE).

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload issues msgINZRE42 ROW AT OFFSET ooo ON PAGE (HEX)
  ppp OF PAGESET tsname IS INVALID and  fails with completion
  code 8 when attempting to run an unload against the table space
  (i.e. in native mode) whiile DB2 does not report any issue with
  the object. This occurs if:
  - the table space is compressed
  - the table contained in the table space has been altered in
    a way that decreases the length of the record
  
  PB45287
  

Local fix

• run a REORG utility against the involved table space
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload         *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGINZRE42 AND COMPLETION CODE 8 WHEN   *
  *                      WHEN ATTEMPTING TO RUN HPU UNLOAD       *
  *                      AGAINST THE TABLE SPACE (I.E. IN        *
  *                      NATIVE MODE).                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The unload issues msgINZRE42 ROW AT OFFSET ooo ON PAGE (HEX) ppp
  of PAGESET tsname IS INVALID and fails with completion code 8
  when attempting to run an unload against the table space (i.e.
  in native mode) while DB2 does not report any issue with the
  object.
  This occurs if:
  - the table space is compressed
  - the table contained in the table spavce has been altered
  in a way that decreases the length of the record
  

Problem conclusion

• The UDBCRRTS was changed.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI39125

     UP16/07/07 P F607

• R430 PSY UI39126

     UP16/07/07 P F607

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.