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

GLOBAL SNAPSHOTS MAY CONSUME A LARGE AMOUNT OF FCM BUFFERS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In a multipartition environment, a large amount of FCM buffers 
can be consumed by large global snapshots. One example of such 
large global snapshots is, "db2 get 
snapshot for locks on <dbname> global" when there are many 
locks currently being held in the database. 
 
db2pd -fcm hwm output would show a single application 
consuming a lot of buffers
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF environments                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Global snapshots collect monitoring information from all     * 
* database partitions and aggregate the result at the          * 
* coordinating partition. FCM buffers are required to send and * 
* receive the monitoring information. The coordinating         * 
* partition can consume a large number of FCM buffers          * 
* equivalent to the size of the entire snapshot result.  If    * 
* the database manager runs out of FCM buffers then node       * 
* failure is invoked to remedy the situation. This could lead  * 
* to applications receiving -1229 errors or losing connection  * 
* to the database.                                             * 
*                                                              * 
* Note that monitoring tools like db2top issue global          * 
* snapshots.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP4 or later                              * 
****************************************************************
Local-Fix:
The work around of setting DB2_MAX_GLOBAL_SNAPSHOT_SIZE should 
help to prevent a single snapshot from consuming all FCM 
buffers. Multiple concurrent large snapshots would still be a 
problem though.
verfügbare FixPacks:
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 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
As of DB2 9.7 FP4, global snapshots will not consume a large 
 
number of FCM buffers.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC75870 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
07.06.2010
25.04.2011
25.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4,
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList