DB2 FOR LUW / DB2FORLUW / 970 - DB2

If many tables exist within a given tablespace, out of memory 
errors may be seen when altering some of the tablespace 
attributes via the ALTER TABLESPACE statement. 
 
The following message will be seen from the ALTER TABLESPACE 
statement: 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0954C  Not enough storage is available in the application 
heap to process 
the statement.  SQLSTATE=57011 
 
The following entries may be seen in the db2diag.log. 
 
2009-08-31-17.28.53.036684-300 I9766A577          LEVEL: Error 
PID     : 233652               TID  : 3343        PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : LN 
APPHDL  : 0-21                 APPID: 
*LOCAL.db2inst1.090831222811 
AUTHID  : DB2INST1 
EDUID   : 3343                 EDUNAME: db2agent (LN) 0 
FUNCTION: DB2 UDB, catalog services, sqlrlField::materializeLOB, 
probe:10 
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
          "No memory available in 'Application Heap'" 
          DIA8301C No memory available in the application heap. 
 
2009-08-31-17.28.53.058716-300 I10344A639         LEVEL: Error 
PID     : 233652               TID  : 3343        PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : LN 
APPHDL  : 0-21                 APPID: 
*LOCAL.db2inst1.090831222811 
AUTHID  : DB2INST1 
EDUID   : 3343                 EDUNAME: db2agent (LN) 0 
FUNCTION: DB2 UDB, catalog services, 
sqlrlDatapartTbspaceUpdates, probe:12849 
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
          "No memory available in 'Application Heap'" 
          DIA8301C No memory available in the application heap. 
MESSAGE : Error performing data partition tbspace updates 
 
2009-08-31-17.28.53.058858-300 I10984A581         LEVEL: Error 
PID     : 233652               TID  : 3343        PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : LN 
APPHDL  : 0-21                 APPID: 
*LOCAL.db2inst1.090831222811 
AUTHID  : DB2INST1 
EDUID   : 3343                 EDUNAME: db2agent (LN) 0 
FUNCTION: DB2 UDB, catalog services, 
sqlrlDatapartTbspaceUpdates, probe:13242 
MESSAGE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
          "No memory available in 'Application Heap'" 
          DIA8301C No memory available in the application heap.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Version 9.7 GA through to Fix Pack 1 servers on      * 
* Linux, Unix and Windows platforms issuing ALTER TABLESPACE   * 
* statements.                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A memory leak in the ALTER TABLESPACE logic results in the   * 
* out of memory error. Typically, out of memory errors will    * 
* occur only if the tablespace contains more than 30,000       * 
* objects in it.  Regardless, the memory leak exists, however, * 
* the leaked memory will be freed when the application         * 
* disconnects from the database.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 Version 9.7 Fix Pack 2.                            * 
****************************************************************

Setting APPLHEAPSZ to a larger value, or to AUTOMATIC will help 
reduce the possibility of running out of memory.  The leaked 
memory from the ALTER TABLESPACE command will be freed when the 
application disconnects.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem is first fixed in DB2 Version 9.7 Fix Pack 2 and all 
subsequent Fix Packs

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.02.2010
22.04.2010
22.04.2010

9.7.FP2