|
Problem IC69885
|
Status: Closed |
On Windows platforms, LOAD with CPU_PARALLELISM more than 1 may leak message queue memory |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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" |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users running large amount of load operations in *
* cumulativefashion under windows platform *
****************************************************************
* PROBLEM DESCRIPTION: *
* In windows platform, users who need to run large amount *
* ofDB2 load operations concurrently can experiencea memory *
* leak situation from message queue memory resource.This is *
* applicable when cpu_parallelism is greater than 1. *
****************************************************************
* RECOMMENDATION: *
* Customer should upgrade to DB2 V9.5 fix pak 7 to *
* avoidexperiencing this defect.Also, the guidelines mentioned *
* under LOCAL FIX of thisAPAR could be followed to avoid *
* this issue. *
**************************************************************** |
| Local Fix: |
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) |
| available fix packs: |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 Version V9.5 fix pak 7
With this fix in place customer will be able to run large number
of load operations simultaneously under windows platform. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC71348 IC71349
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.07.2010
25.10.2010
25.10.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
