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 IT07434 Status: Geschlossen

SLOW DATABASE DEACTIVATION ON WINDOWS WITH LARGE BUFFERPOOLS AND
DB_MEM_THRESH 100

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
With DB_MEM_THRESH 100 setting (the new default on version 
10.5), all the memory released by freeing bufferpool memory is 
cached.  The structures used to track the freed memory build up, 
resulting in longer and longer traversal time as more memory is 
freed. 
 
For example, deactivating a database with 100GB of bufferpool 
may take 15 minutes.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Large DB2 / Windows systems are vulnerable                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7                       * 
****************************************************************
Local-Fix:
db2 update db cfg for <database> using db_mem_thresh 10 
 
This can be done dynamically after connecting to the database. 
For a quicker database deactivation, it is only important that 
the "10" setting is in place prior to database deactivation (or 
last connection terminates if the database is not explicitly 
activated)  If the default "100" is desired for normal 
operations, it can be set any time before the next activation or 
online (over a connection) after the database next activates. 
 
For extremely large configurations (eg. bufferpools > 100GB), it 
may be necessary to increase the bufferpool allocation size to 
1MB, which will bypass most of the overhead. 
 
   db2set DB2_ALLOCATION_SIZE=1MB 
 
This setting is only effective as of the next instance 
activation (db2start).  This is an deprecated registry setting 
and should only be used as a workaround for this APAR.  Once the 
Fix Pack containing this APAR is applied, this setting should be 
removed.
Lösung
Problem first fixed in DB2 Version 10.5 Fix Pack 7
Workaround
See Local Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.03.2015
18.02.2016
18.02.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList