|
Problem IT03963
|
Status: Closed |
DB2 CRASHES WHEN ITS CAN'T RESERVE SPACE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| Solution |
Problem is first fixed in DB2 UDB Version 10.5 fix pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.08.2014
26.03.2015
26.03.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
