|
Problem IC66000
|
Status: Closed |
MEMORY LEAK DURING ALTER TABLESPACE MAY LEAD TO SQL0954C, "NOT ENOUGH STORAGE IS AVAILABLE" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
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
|
| Solution |
Problem is first fixed in DB2 Version 9.7 Fix Pack 2 and all
subsequent Fix Packs |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.02.2010
22.04.2010
22.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
