DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

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

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.

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
 

As of DB2 9.7 FP4, global snapshots will not consume a large 
 
number of FCM buffers.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC75870 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

07.06.2010
25.04.2011
25.04.2011

9.7.FP4,
9.7.FP4