home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC92740 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 / 970 - 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 9.7 Fix Pack 9                        * 
****************************************************************
Local-Fix:
avoid invalid ALTER TABLESPACE command where possible
verfügbare FixPacks:
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

Lösung
Problem first fixed in DB2 Version 9.7 Fix Pack 9
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC95388 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.06.2013
18.12.2013
18.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList