DB2 FOR LUW / DB2FORLUW / 970 - DB2

The problem exists only in 'archive logging' mode. It could 
happen when COMMIT statements are submitted too frequently. 
 
When this problem occurs, any COMMIT statement being performed 
by 'db2agent' will be blocked for a short period of time in 
units of seconds, e.g. 1 second or 2 seconds. Corresponding 
applications will be in state of 'Commit Active' during the 
time. 
In most cases the COMMIT statement will be blocked for only 1 
second. In very rare situations where there are too many COMMIT 
statements submitted frequently, it could be blocked for 2 
seconds or even longer. 
 
The COMMIT statement is actually being blocked by EDU 'db2logts' 
which is flushing data from memory to DB2TSCHG.HIS. 
 
To identify the problem, collect 'db2trc' data when 'db2agent' 
is issuing COMMIT statement and see if the function 
sqlpUploadDirtyPoolEntry() costs too much time (e.g. 1 second or 
2 seconds).

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.7 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The problem exists only in 'archive logging' mode. It could  * 
* happen when COMMIT statements are submitted too frequently.  * 
*                                                              * 
* When this problem occurs, any COMMIT statement being         * 
* performed by 'db2agent' will be blocked for a short period   * 
* of time in units of seconds, e.g. 1 second or 2 seconds.     * 
* Correspoding applications will be in state of 'Commit        * 
* Active' during the time.                                     * 
* In most cases the COMMIT statement will be blocked for only  * 
* 1 second. In very rare situations where there are too many   * 
* COMMIT statements submitted frequently, it could be blocked  * 
* for 2 seconds or even longer.                                * 
*                                                              * 
* The COMMIT statement is actually being blocked by EDU        * 
* 'db2logts' which is flushing data from memory to             * 
* DB2TSCHG.HIS.                                                * 
*                                                              * 
* To identify the problem, collect 'db2trc' data when          * 
* 'db2agent' is issuing COMMIT statement and see if the        * 
* function sqlpUploadDirtyPoolEntry() costs too much time      * 
* (e.g. 1 second or 2 seconds).                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 FixPak 5 or higher levels.    * 
****************************************************************

Setting DB2 registry variable DB2_COLLECT_TS_REC_INFO=OFF to 
stop EDU 'db2logts'.

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
 

First fixed in DB2 LUW Version 9.7 FixPak 5.

Setting DB2 registry variable DB2_COLLECT_TS_REC_INFO=OFF to 
stop EDU 'db2logts'.

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

31.03.2011
17.01.2012
17.01.2012

9.7.