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 | |
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 |