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

DB2 CRASHES WHEN ITS CAN'T RESERVE SPACE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
During a load DB2 can crash if it its this message: 
 
2014-08-12-08.11.04.333474-300 I61214E717            LEVEL: 
Error 
PID     : 2798                 TID : 140677581104896 PROC : 
db2sysc 0 
INSTANCE: db2inst2             NODE : 000            DB   : 
PATDWDEV 
APPHDL  : 0-10718              APPID: 
10.62.7.245.54683.140812123520 
AUTHID  : DB2INST2             HOSTNAME: CHICKASAW 
EDUID   : 1804                 EDUNAME: db2agent (PATDWDEV) 0 
FUNCTION: DB2 UDB, data protection services, sqlpReserveSpace, 
probe:10 
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic 
Error" 
          DIA8526C A fatal error occurred in data protection 
services. 
DATA #1 : String, 52 bytes 
Cannot reserve space when transaction is committing. 
DATA #2 : unsigned integer, 8 bytes 
368 
 
With the following stack: 
 
DB2ErrorException 
LogRecordReserver::reserveLogSpaceInternal 
LogRecordReserver::resvFixedLogSpace 
TableWriter::ColumnGroupWriteState::reserveLogSpaceForOncePerFlu 
shChanges 
TableWriter::ColumnGroupWriteState::initializeInsertLogRecord 
TableWriter::ColumnGroupWriteState::initPageBufferFromLastPage 
TableWriter::insertTupleToColumnGroupBuffered 
TableWriter::insertTupleBuffered 
TableWriter::writeSynopsisTuple 
TableWriter::flushBufferedInserts 
InsertRange::commit 
InsertRangeList::prepareForEndOfTransaction 
CDEApplication::prepareForEndOfTransaction 
CDEApplicationInterface::prepareForEndOfTransaction 
sqlpxcm1 
sqlrrcom_dp 
sqlrrcom 
sqlrr_commit
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 CRASHES WHEN IT CAN'T RESERVE SPACE                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please move to fix pack 5 of v10.5                           * 
****************************************************************
Local-Fix:
N/A
Lösung
Problem is first fixed in DB2 UDB Version 10.5 fix pack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.08.2014
26.03.2015
26.03.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList