DB2 - Problem description
| Problem IT02373 | Status: Closed |
SQLD_BADPAGE in sqldDecrementReservedSpace during inplace table reorg | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
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
"". | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 10.5 fix pack 5 * **************************************************************** | |
| Local Fix: | |
| Solution | |
First fixed in version 10.5 fix pack 5 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.06.2014 16.03.2015 16.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 |
|