DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 will use large the fully confirgured amount of SORT HEAP 
when 0-cardinality is indicated on a SORT operation. 
 
The issue can be identified by examining the query access plan, 
and 
looking for a SORT with a 0 estimated cardinality.  Typically a 
0-cardinality function, table, global temporary table, or 
session temporary table can cause this plan. 
 
In Access plan : 
 3) SORT  : (Sort) 
  Cumulative Total Cost:   22.6971 
  Cumulative CPU Cost:   126925 
  Cumulative I/O Cost:   2.9975 
  Cumulative Re-Total Cost:  0.0097435 
  Cumulative Re-CPU Cost:  34379.9 
  Cumulative Re-I/O Cost:  0 
  Cumulative First Row Cost:  22.6971 
  Estimated Bufferpool Buffers:  2.9975 
 
  Arguments: 
  --------- 
  BUFFSORT: (Sort for Buffering Rows) 
   TRUE 
  DUPLWARN: (Duplicates Warning flag) 
   FALSE 
  NUMROWS : (Estimated number of rows) 
   0 <--------------------------------0 cardinality estimated. 
  ROWWIDTH: (Estimated width of rows) 
   424 
  SORTKEY : (Sort Key column) 
   NONE 
  TEMPSIZE: (Temporary Table Page Size) 
   4096 
  UNIQUE  : (Uniqueness required flag) 
   FALSE

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users with large sort heap configured and 0-cardinality  * 
* tables                                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update the DB2 Linux, Unix, Windows server to Version 9.7    * 
* Fix                                                          * 
* Pack 9 or higher.                                            * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Update the DB2 Linux, Unix, Windows server to Version 9.7 Fix 
Pack 9 or higher.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC97093 IC97099 IT00554 IT00555 IT00556 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.06.2013
24.03.2014
24.03.2014

9.0.,
9.7.