home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC78581 Status: Closed

DB2_MEMORY_PROTECT MAY CAUSE SPURIOUS ERRORS

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Enabling memory protection via the DB2_MEMORY_PROTECT registry 
variable may cause the DB2 database engine to incorrectly fail 
with spurious memory protection errors. 
 
This type of failure can manifest in many ways, but a common 
signature is a DB2 trap file that shows a SIGSEGV trap with an 
si_code field of hex 34: 
 
Signal #11 (SIGSEGV): si_addr is <some address>, si_code is 
0x00000034 
 
Memory protection is only functional on AIX systems running on 
hardware with memory key support (Power 6 and later).  Other 
platforms are not affected.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 v9.5 or later on AIX systems with hardware that supports * 
* storage keys (Power 6 and later)                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Enabling memory protection via the DB2_MEMORY_PROTECT        * 
* registry variable may cause the DB2 database engine to       * 
* incorrectly fail with spurious memory protection errors.     * 
*                                                              * 
* This type of failure can manifest in many ways, but a common * 
* signature is a DB2 trap file that shows a SIGSEGV trap with  * 
* an si_code field of hex 34:                                  * 
*                                                              * 
* Signal #11 (SIGSEGV): si_addr is <some address>, si_code is  * 
* 0x00000034                                                   * 
*                                                              * 
* Memory protection is only functional on AIX systems running  * 
* on hardware with memory key support (Power 6 and later).     * 
* Other platforms are not affected.                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Do not set the DB2_MEMORY_PROTECT registry variable, or      * 
* explicitly set it to "NO".                                   * 
****************************************************************
Local Fix:
Do not set the DB2_MEMORY_PROTECT registry variable, or 
explicitly set it to "NO".
available fix packs:
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
The DB2_MEMORY_PROTECT registry variable will be ignored in DB2 
v9.7 fp5 and later fixpacks while a comprehensive review is 
performed.  Once the review is complete the function will either 
be rehabilitated or formally deprecated. 
 
As of DB2 v9.5 fp9, the registry variable can still be set (and 
will remain set if set previous).  Regardless of the setting, 
however, the DB2 engine will not enable memory protection.
Workaround
Do not set the DB2_MEMORY_PROTECT registry variable, or 
explicitly set it to "NO".
Comment
Final resolution of this issue will be documented via APAR, 
Technote and/or updates to product documentation as appropriate.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.09.2011
12.03.2012
12.03.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9,
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList