PM39636: UNLOAD GENERATES MESSAGE INZZ001S AND ABEND U0027

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• UNLOAD fails during the sort processing when:
  * the unload is run against a partitioned table space
  * one output file per partition is requested
  This only occurs for specific conditions about the list, the
  sequence and data type of the columns to be unloaded.
  PB11190
  

Local fix

• Add the OPTIM_LEVEL 0 option to the GLOBAL block.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The unload fails during the sort        *
  *                      processing or the output data is not    *
  *                      correctly sorted.                       *
  *                      This may occur when:                    *
  *                      * the unload is run against a           *
  *                      partitioned table space                 *
  *                      * one output file per partition is      *
  *                      requested                               *
  *                      It only occurs for specific conditions  *
  *                      about the list, the sequence and data   *
  *                      type of the columns to be unloaded.     *
  *                      PB 11190                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzpab module was changed.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK70403 UK70404

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK70403

     UP11/08/09 P F108

• R410 PSY UK70404

     UP11/08/09 P F108

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.