home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList