SAP Knowledge Base Article - Preview

2325959 - Inplace table reorg DB crash: Free space values invalid

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

SAP Solution Manager 7.1

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.