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.
SAP Knowledge Base Article - Preview