home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC74969 Status: Geschlossen

ABEND DURING LOAD WHEN DB2_MEMORY_PROTECT ENABLED ON AIX WITH STORAGE KEY
SUPPORT

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The DB2_MEMORY_PROTECT registry variable is enabled, and DB2 is 
running on AIX with storage key support, which is one of the 
pre-conditions for DB2_MEMORY_PROTECT to take effect (please 
refer to Information Center for more detail). When these 
conditions are met, the DB2 instance may abend when running the 
LOAD utility. The eyecatcher to identify this problem is the 
presence of the sqlbPurgeAllPagesCommon routine in the trap 
file, while the sqlbPurgeOrFlushEMPs routine is NOT present: 
 
EDU name     : db2agent (SAMPLE) 
Signal #11 
 
sqlbSlotIsInPageDecreaseArea 
sqlbAddToHateList_IUO 
sqlbAddToAlternateHateList 
sqlbPurgeAllPagesCommon 
sqlbPurgeAllPagesMultipleObjects 
sqlbPurgeMultipleObjects 
zFlushAndPurgeObjects 
sqluRegisterLoadStart 
 
This problem only exists in DB2 UDB 9.7 FixPak 3 or newer.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ABEND DURING LOAD WHEN DB2_MEMORY_PROTECT ENABLED ON AIX     * 
* WITH                                                         * 
* STORAGE KEY SUPPORT                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The DB2_MEMORY_PROTECT registry variable is enabled, and DB2 * 
* is                                                           * 
* running on AIX with storage key support, which is one of the * 
* pre-conditions for DB2_MEMORY_PROTECT to take effect (please * 
* refer to Information Center for more detail). When these     * 
* conditions are met, the DB2 instance may abend when running  * 
* the                                                          * 
* LOAD utility. The eyecatcher to identify this problem is the * 
* presence of the sqlbPurgeAllPagesCommon routine in the trap  * 
* file, while the sqlbPurgeOrFlushEMPs routine is NOT present: * 
*                                                              * 
* EDU name    : db2agent (SAMPLE)                              * 
* Signal #11                                                   * 
*                                                              * 
* sqlbSlotIsInPageDecreaseArea                                 * 
* sqlbAddToHateList_IUO                                        * 
* sqlbAddToAlternateHateList                                   * 
* sqlbPurgeAllPagesCommon                                      * 
* sqlbPurgeAllPagesMultipleObjects                             * 
* sqlbPurgeMultipleObjects                                     * 
* zFlushAndPurgeObjects                                        * 
* sqluRegisterLoadStart                                        * 
*                                                              * 
* This problem only exists in DB2 UDB 9.7 FixPak 3 or newer.   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FixPak 5.                                 * 
****************************************************************
Local-Fix:
Disable DB2_MEMORY_PROTECT.
verfügbare FixPacks:
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

Lösung
See APAR description
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.03.2011
23.12.2011
23.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.5 FixList