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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.