Symptom
During a roll forward, you encounter the following errors:
2018-00-01-00.00.00.024748+120 E298975A655 LEVEL: Severe
PID : 123456 TID : 12345 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-123 APPID: *LOCAL.DB2.180520215010
HOSTNAME: db2hostname
EDUID : 34770 EDUNAME: db2shred (SID) 0
FUNCTION: DB2 UDB, recovery manager, sqlpshrBuildRecord, probe:1040
MESSAGE : ZRC=0x87100027=-2028994521=SQLP_TRECTYPERR
"A record other than those expected has been read during abort"
DIA8536C A bad record type was encountered.
DATA #1 : <preformatted>
Invalid record type in log file S0100000.LOG
2018-00-01-00.00.00.025329+120 E299631A797 LEVEL: Severe
PID : 123456 TID : 12345 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-123 APPID: *LOCAL.DB2.180520215010
HOSTNAME: db2hostname
EDUID : 34770 EDUNAME: db2shred (SID) 0
FUNCTION: DB2 UDB, recovery manager, sqlpshrBuildRecord, probe:1040
MESSAGE : ZRC=0x87100027=-2028994521=SQLP_TRECTYPERR
"A record other than those expected has been read during abort"
DIA8536C A bad record type was encountered.
DATA #1 : SQLP_LRH, PD_TYPE_SQLP_LRH, 64 bytes
recLfs 1461904302336 recLsn 00B833B6836D0E00 lrecsize 44032 lrectype 4E20 lrecflags 0000
backlso 64069927748803840 maps to pso 00E4BD2EFEFF5C33 thistid 0C1D1C75D600
Read more...
Environment
IBM Db2 LUW 10.5
Product
Keywords
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.