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

CONCURRENT INSERT AND REORG RECLAIM EXTENT ON MDC TABLE MAY ABEND SERVER
WITH DIA8737C

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
An INSERT into a MDC table may abend server starting with the 
following messages in the db2diag.log file: 
 
2014-08-25-00.22.23.439952+120 I25944289A609        LEVEL: 
Severe 
PID     : 3735836              TID : 45492          PROC : 
db2sysc 0 
INSTANCE: xxxx               NODE : 000           DB   : yyy 
APPHDL  : 0-100                APPID: 
10.10.0.126.32875.140817082313 
AUTHID  : xxxxx               HOSTNAME: zzzz 
EDUID   : 45492                EDUNAME: db2agent (yyy) 0 
FUNCTION: DB2 UDB, sqldb, sqldb_createNewBlock, probe:217 
RETCODE : ZRC=0x870400CC=-2029780788=SQLDB_PRGERR 
          "Block Management Services program error" 
          DIA8737C A block management services programming error 
occurred. 
 
2014-08-25-00.22.23.450325+120 I25944899A609        LEVEL: 
Severe 
PID     : 3735836              TID : 45492          PROC : 
db2sysc 0 
INSTANCE: xxxx               NODE : 000           DB   : yyy 
APPHDL  : 0-100                APPID: 
10.10.0.126.32875.140817082313 
AUTHID  : xxxxx               HOSTNAME: zzzzz 
EDUID   : 45492                EDUNAME: db2agent (yyy) 0 
FUNCTION: DB2 UDB, sqldb, sqldb_createNewBlock, probe:251 
RETCODE : ZRC=0x870400CC=-2029780788=SQLDB_PRGERR 
          "Block Management Services program error" 
          DIA8737C A block management services programming error 
occurred. 
 
Stack trace for the failing INSERT looks like this: 
0x09000000007CFF54 pthread_kill + 0xD4 
0x0900000011CEEA98 sqloDumpEDU + 0x6C 
0x09000000133E0918 sqleDoForceDBShutdownFODC + 0x27C 
0x09000000121A52F0 ForceDBShutdown + 0x6EC 
0x09000000102C90D0 sqldDumpContext + 0x9C0 
0x090000001220B5D8 sqldb_createNewBlock + 0x3180 
0x09000000124255FC sqldExtendTable + 0x2EF0 
0x09000000146399C4 sqldb_allocateNewBlocki + 0xE4 
0x090000001464DA84 sqldb_findNewBlock + 0x4DC 
0x090000001464C138 sqldb_findNewBlockAndInsert + 0x4A0 
0x090000001464ADB8 sqldb_insertRow + 0x694 
0x0900000011672250 sqldRowInsert + 0x664 
0x090000001144567C sqlrinsr + 0xAC 
0x0900000011445464 sqlriisr + 0x164 
0x09000000114BEBE8 sqlriSectInvoke + 0x30 
... 
 
The following additional conditions need to be true: 
* A REORG RECLAIM EXTENTS needs to be active on the MDC table in 
question 
* The MDC table must have been migrated from DB2 V9.5 or earlier 
to V10.x
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 5.                      * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 Version 10.1 Fix Pack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.09.2014
17.07.2015
17.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList