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 IC81649 Status: Geschlossen

DB2START FAILS WITH SQL10003 ON SOLARIS 10, SPARC T4 PROCESSOR WITH 2GB
PAGE SIZE SUPPORT

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
db2start fails with SQL10003 due to attaching the FMP memory set 
to an invalid address on the Solaris 10 / Sparc T4 processor 
combination with 2GB page size support.  Solaris 10 update 4 
(kernel patch 147440-04) enables 2GB pages by default. 
 
The problem is due to an inconsistency in the way DB2 rounds up 
shared segment sizes and then calculates the attach addresses of 
"fixed address" segments.  With 2GB page sizes available, DB2 
tries to attach a shared memory segment at an address that is in 
use by a previously attached segment.  This is independent of 
the actual backing page size used, it only matters what the 
largest page size is determined to be available on the system 
from the Solaris getpagesizes API. 
 
expected db2diag.log messages: 
 
2012-02-18-13.04.43.276604-360 I8210A728          LEVEL: Severe 
PID     : 17832                TID  : 2           PROC : db2sysc 
INSTANCE: db2inst2             NODE : 000 
EDUID   : 2                    EDUNAME: db2sysc 
FUNCTION: DB2 UDB, routine_infrastructure, sqlerInitFmpHeap, 
probe:60 
MESSAGE : Failed to create the memory segment used for 
communication with 
          fenced routines. If re-starting db2, ensure no db2fmp 
processes were 
          on the instance prior to start. Otherwise, you can 
adjust this value 
          through DB2_FMP_COMM_HEAPSZ db2set value, or by 
decreasing your 
          ASLHEAPSZ setting. 
DATA #1 : Hexdump, 8 bytes 
0xFFFFFFFF603FCDB8 : 0000 0000 015E 8480 
.....^.. 
 
... 
 
2012-02-18-13.04.43.278198-360 I9653A320          LEVEL: Severe 
PID     : 17832                TID  : 2           PROC : db2sysc 
INSTANCE: db2inst2             NODE : 000 
EDUID   : 2                    EDUNAME: db2sysc 
FUNCTION: DB2 UDB, oper system services, sqloWatchDogSetup, 
probe:60 
MESSAGE : ZRC=0xFFFFD8ED=-10003 
 
... 
2012-02-18-13.04.43.288489-360 I10469A906         LEVEL: Error 
PID     : 17827                TID  : 2           PROC : db2wdog 
0 
INSTANCE: db2inst2             NODE : 000 
EDUID   : 2                    EDUNAME: db2wdog 0 
FUNCTION: DB2 UDB, SQO Memory Management, sqlocshr, probe:10 
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid 
memory addr" 
          DIA8561C A invalid memory block was encountered. 
DATA #1 : Pointer, 8 bytes 
0x0000000000000000
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Hardware: SPARC T4                                           * 
* Software: Solaris 10 with 147440-04 patch installed. This    * 
* patch (or any one above) enables 2 GB memory pages.          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 instance cannot be started with error message :          * 
* SQL10003C  There are not enough system                       * 
* resources to process the request.  The request cannot be     * 
* processed.                                                   * 
* SQL1032N  No start database manager command was issued.      * 
* SQLSTATE=57019                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6                        * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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
Problem first fixed in DB2 Version 9.7 Fix Pack 6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC81653 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.02.2012
02.08.2012
07.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList