DB2 FOR LUW / DB2FORLUW / 950 - DB2

The following is an example testcase for the memory leak on a 
declared global temporary table : 
 
declare global temporary table session.mytemp like 
sysibm.syscolumns ; 
create index session.idx1 on session.mytemp ( name ) collect 
sampled detailed statistics; 
drop table session.mytemp; 
 
The following is an example testcase for the memory leak on a 
range partitioned table : 
 
create table IC.r (c1 int, c2 int) partition by range (c1) 
(starting (1) ending (10), ending (20)); 
create index IC.i on IC.r ( c2 ) collect sampled detailed 
statistics; 
 
 
 
The leak can be shown by examining the output from : 
db2pd -db dbname -memb all

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.5 Fix Pack 9 or later                      * 
****************************************************************

Instead of collecting statistics during index creation, collect 
statistics with a RUNSTATS command after creating the index.

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

Problem first fixed in DB2 V9.5 Fix Pack 9

not known / see Local fix

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

29.07.2011
31.10.2012
31.10.2012

9.5.FP9