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.