Symptom
Database crashes during inplace table reorg and the following errors are found in the db2diag.log at the time of the crash:
2014-04-01-19.14.16.723796+120 I3087032A494 LEVEL:
Severe
PID : xxxxx TID : xxxxxxxxxxxxx PROC :
db2sysc 0
INSTANCE: db2jdoe NODE : 000 DB :
SAMPLE
APPHDL : 0-21699 APPID: *LOCAL.DB2.140401171308
AUTHID : DB2jdoe HOSTNAME: db2test
EDUID : 1879 EDUNAME: db2reorg (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDecrementReservedSpace,
probe:12865
DATA #1 : <preformatted>
Free space values invalid
2014-04-01-19.14.16.740324+120 I3087527A694 LEVEL:
Severe
PID : 21246 TID : 4397132146960 PROC :
db2sysc 0
INSTANCE: db2jdoe NODE : 000 DB :
SAMPLE
APPHDL : 0-21699 APPID: *LOCAL.DB2.140401171308
AUTHID : DB2jdoe HOSTNAME: db2xxx
ID : 1879 EDUNAME: db2reorg (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDecrementReservedSpace,
probe:12867
DATA #1 : String, 15 bytes
Record length:
DATA #2 : unsigned integer, 4 bytes
58
DATA #3 : String, 16 bytes
Space consumed:
DATA #4 : unsigned integer, 4 bytes
58
DATA #5 : String, 20 bytes
Must release space:
DATA #6 : unsigned integer, 8 bytes
1
2014-04-01-19.14.16.793731+120 I3088222A577 LEVEL:
Severe
PID : xxxxx TID : xxxxxxxxxxxxx PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-21699 APPID: *LOCAL.DB2.140401171308
AUTHID : DB2jdoe HOSTNAME: db2xxx
EDUID : 1879 EDUNAME: db2reorg (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDecrementReservedSpace,
probe:12841
RETCODE : ZRC=0x87040001=-2029780991=SQLD_BADPAGE "Bad Data
Page"
DIA8500C A data file error has occurred, record id is "".
Read more...
Environment
- DB2 LUW 10.5
Product
Keywords
sqldDecrementReservedSpace, IT02373, db2support, severe, shutdown, stop , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview