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 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