PK53410: MSGICE046A SORT CAPACITY EXCEEDED & ABENDU0046 WHEN HPU UNLOADS TS SEGMENTED & COMPRESSED, MULTI-TABLE, & TABLE HAS UNIQUE INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU UNLOAD of a multi-table, segmented and compressed
  TableSpace and the Table has a unique index may receive
  ABENDU0046 and SORT message ICE046A when an ORDER BY is
  coded in the unload. HPU miscalculates the FILSZ passed.
  DFSORT. HPU R310 only.
  PB 9008
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU 310 only: Error in the estimation   *
  *                      of the number of rows for tablespace    *
  *                      created with COMPRESS YES.              *
  *                      Several symptoms are possible:          *
  *                      - SORT error, either abend U1009,       *
  *                       abend U0046 or message ICE046A SORT    *
  *                       CAPACITY EXCEEDED                      *
  *                      - Abend SB37 on output files created    *
  *                       using a TEMPLATE.                      *
  *                      - Abend SB37 on TnnnMG (T001MG, etc.)   *
  *                       or TnnnIN (T001IN, etc.) files when    *
  *                       processing SELECT with ORDER BY on     *
  *                       the order of the clustering index.     *
  *                      PB 9008                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module Oestime was changed to fix the estimation of compressed
  tablespaces.
  

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:

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK30553

     UP07/10/27 P F710

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.