DB2 FOR LUW / DB2FORLUW / 970 - DB2

On Windows, LOAD operations with cpu_parallelism greater than 1 
(implicitly or explicitly) can cause message queue memory 
resource leakage.  Even though each LOAD only leaks a small 
amount of memory (typically less than 1 KB), this Queue Memory 
is not growable.  For heavy LOAD users running thousands of 
LOADs cumulatively, the Queue Memory can eventually be 
exhausted, and after that DB2 can experience errors, panics, and 
hangs. 
 
Indicator in db2diag.log is, messages that show: 
 
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message 
Not Sent"

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users running large amount of load operations in cumulative  * 
* fashion under windows platform                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In windows platform, users who need to run large amount of   * 
* DB2 load operations concurrently can experience a memory     * 
* leak situation from message queue memory resource.           * 
* This is applicable when cpu_parallelism is greater than 1.   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Users should upgrade to DB2 V9.7 fix pak 4 to avoid          * 
* experiencing this defect.                                    * 
* Also, the guidelines mentioned  under LOCAL FIX  of this     * 
* APAR  could be followed to avoid this issue.                 * 
****************************************************************

Reduce the load's cpu_parallelism to 1 
 (which will prevent leakage from load); 
 
Increase the queue memory with DB2 registry 
DB2NTMEMSIZE=QUE:<size> 
 (which will delay exhaustion of queue memory)

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
 

First Fixed in DB2 Version V9.7 fix pak 4 
 
With this fix in place users will be able to run large number of 
 load operations simultaneously under windows platform.

keiner bekannt / siehe Local-Fix

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

21.09.2010
28.04.2011
28.04.2011

9.7.