|
Problem IC79260
|
Status: Closed |
DB2 MAY NOT PERFORM OPTIMALLY ON LARGE 64-BIT WINDOWS ENVIRONMENTS DUE TO USE OF MEM_TOP_DOWN FLAG |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 uses the MEM_TOP_DOWN flag for many memory allocations
(VirtualAlloc API) on the Windows platform. The use of this
flag causes memory allocations to take longer as the number of
allocations gets larger. The MEM_TOP_DOWN flag is used
primarily to avoid address space fragmentation in 32-bit
environments, and is not needed with 64-bit, so its use will be
restricted to 32-bit DB2.
The symptom may be particularly noticable when initializing
large bufferpools.
A workaround exists, that is to set the following internal
registry variable:
db2set DB2_MEMALLOCATE_HIGH=NO
The instance must be recycled with db2stop; db2start |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 running in large Windows environments *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
db2set DB2_MEMALLOCATE_HIGH=NO
The instance must be recycled with db2stop; db2start |
| available fix packs: |
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
|
| Solution |
Problem first fixed in DB2 Version 9.7 Fix Pack 6 |
| Workaround |
See Local Fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84204
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.10.2011
12.06.2012
12.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
