|
Problem IC95388
|
Status: Geschlossen |
EXCESSIVE MEMORY USAGE IN DATABASE HEAP WHEN FAILING ALTER TABLE SPACE COMMANDS ARE ISSUED ACROSS A LARGE NUMBER OF TABLESPACES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All systems *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 3 *
**************************************************************** |
| Local-Fix: |
avoid invalid ALTER TABLESPACE commands where possible |
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
Problem first fixed in DB2 Version 10.5 Fix Pack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.08.2013
27.02.2014
27.02.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
