DB2 might crash during online table reorg.
Symptoms will show the sqldDecrementReservedSpace
function reporting 'Free space values invalid' for a
row-organized table data object page. Here are the db2diag.log
entries that would point to the issue:
2014-04-01-19.14.16.723796+120 I3087032A494 LEVEL:
Severe
PID : 21246 TID : 4397132146960 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-21699 APPID: *LOCAL.DB2.140401171308
AUTHID : DB2INST1 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: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-21699 APPID: *LOCAL.DB2.140401171308
AUTHID : DB2INST1 HOSTNAME: db2test
EDUID : 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 : 21246 TID : 4397132146960 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-21699 APPID: *LOCAL.DB2.140401171308
AUTHID : DB2INST1 HOSTNAME: db2test
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
"". |
