|
Problem IC92740
|
Status: Closed |
EXCESSIVE MEMORY USAGE IN DATABASE HEAP WHEN FAILING ALTER TABLE SPACE COMMANDS ARE ISSUED ACROSS A LARGE NUMBER OF TABLESPACES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A 256K database heap allocation required for certain alter
tablespace commands is unintentionally cached when no internal
action is required. The memory is cached per tablespace and
will be reused for any subsequent alter tablespace command on
the same tablespace (and may be freed as part of that
operation).
Commands known to miss freeing the buffer:
1. ALTER TABLESPACE ... REDUCE where the reduce operation
cannot proceed. This will be accompanied by a db2diag.log
message:
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:15
MESSAGE : ADM1534W Table space "USERSPACE1" could not be
reduced in size
because there are used pages at the end of the table
space.
2. ALTER TABLESPACE ... REBALANCE where the rebalance operation
is not required.
The additional cached memory is rarely significant, reused per
tablespace, and freed at database deactivation. Systems with a
very large number of tablespaces where the above commands are
regularly issued may experience symptoms associated with
abnormally high memory usage. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all systems *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 Fix Pack 9 *
**************************************************************** |
| Local Fix: |
avoid invalid ALTER TABLESPACE command where possible |
| available fix packs: |
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
|
| Solution |
Problem first fixed in DB2 Version 9.7 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95388
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.06.2013
18.12.2013
18.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
