|
Problem IC62926
|
Status: Closed |
MEMORY LEAK CAN OCCUR WHILE RUNNING REORG ON A TABLE WITH A COMPRESSED XDA OBJECT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In DB2 v9.7 a small amount of memory from the database heap may
be leaked during a REORG. For the leak to occur, the
reorganized table must be compressed and must contain at least
one XML column. Some of the XML documents must be stored in the
XML storage object and be compressed.
Symptoms of this memory leak include:
- Continuous increase of memory usage both inside the DB2
process and on the system overall
- Out-of-memory errors reported by the database manager
- Side effects such as the inability to connect to DB2 databases
- System memory or paging space exhaustion
This memory is allocated from the database heap, and will be
reported by DB2 memory monitoring tools (db2pd, db2mtrk,
snapshot). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Any *
****************************************************************
* PROBLEM DESCRIPTION: *
* MEMORY LEAK CAN OCCUR WHILE RUNNING REORG ON A TABLE WITH A *
* COMPRESSED XDA OBJECT *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.7 FP1 *
**************************************************************** |
| Local Fix: |
Increasing the size of the database heap via the 'dbheap' memory
configuration parameter may help prevent the symptoms of this
memory leak. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.09.2009
04.02.2010
04.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
