Symptom
You have rebuilt standby server following KBA 3264518
Standby server gets shutdown shortly after it starts up.
In the database log (/db2/<SID>/db2dump/db2diag.log), you find following error messages:
2023-03-06-23.38.15.160991+000 I917087A490 LEVEL: Info
PID : 5702368 TID : 40351 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-3810 APPID: *LOCAL.db2abc.230306233056
AUTHID : DB2abc HOSTNAME: abcde001
EDUID : 40351 EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21152
MESSAGE : HADR Startup has completed.
2023-03-06-23.38.15.201113+000 I918485A460 LEVEL: Info
PID : 5702368 TID : 44463 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-3815 APPID: *LOCAL.DB2.230306233815
HOSTNAME: abcde001
EDUID : 44463 EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, recovery manager, sqlpReplayMaster, probe:300
DATA #1 : <preformatted>
Starting Replay Master on standby.
2023-03-06-23.38.35.449993+000 I953764A570 LEVEL: Info
PID : 5702368 TID : 5880 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
HOSTNAME: abcde001
EDUID : 5880 EDUNAME: db2logmgr (LNR) 0
FUNCTION: DB2 UDB, data protection services, sqpLogMgrEdu::sqlpgRetrieveLogFile, probe:4148
DATA #1 : <preformatted>
Completed retrieve for log file S0011330.LOG on chain 9 to /db2/LNR/log_archive2/db2lnr/LNR/NODE0000/LOGSTREAM0000/LOGSTREAM0000/. The newly retrieved log will be verified.
2023-03-07-00.24.50.529219+000 I1100305A458 LEVEL: Info
PID : 5702368 TID : 7165 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
HOSTNAME: abcde001
EDUID : 7165 EDUNAME: db2logalloc.0 (abc) 0
FUNCTION: DB2 UDB, data protection services, sqlpLogAllocCandidatePool::removeExtraCandidates, probe:10100
DATA #1 : <preformatted>
Delete log extent 11330 from log stream 0.
2023-03-07-02.17.02.384536+000 I1166733A590 LEVEL: Error
PID : 5702368 TID : 6908 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
HOSTNAME: abcde001
EDUID : 6908 EDUNAME: db2lfr.0 (LNR) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrDoScanNext, probe:1100
MESSAGE : hit EOL for hadr
DATA #1 : SQLPLFR_SCAN_ID, PD_TYPE_SQLPLFR_SCAN_ID, 8 bytes
LFR Scan Num = 5
LFR Scan Caller's EDUID = 44670
DATA #2 : Hex integer, 8 bytes
0x0000000004031008
DATA #3 : unsigned integer, 4 bytes
2249129994
2023-03-07-02.17.02.776362+000 I1174575A1088 LEVEL: Info
PID : 5702368 TID : 44463 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-3815 APPID: *LOCAL.DB2.230306233815
HOSTNAME: abcde001
EDUID : 44463 EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, recovery manager, sqlpReplayMaster, probe:2460
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 88 bytes
Replay master encoutered some error. Try to restart standby to handle recoverable error.
DATA #2 : unsigned integer, 8 bytes
0
DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1042 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlpRepl
2023-03-07-02.17.02.778304+000 I1176143A479 LEVEL: Info
PID : 5702368 TID : 41893 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-4111 APPID: *LOCAL.DB2.230307021702
HOSTNAME: abcde001
EDUID : 41893 EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetExplicitStarted, probe:125
MESSAGE : HADR turned database explicitly started OFF.
2023-03-07-02.17.02.779192+000 I1177103A477 LEVEL: Info
PID : 5702368 TID : 44463 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-3815 APPID: *LOCAL.DB2.230306233815
HOSTNAME: abcde001
EDUID : 44463 EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, recovery manager, sqlpReplayMaster, probe:9500
MESSAGE : Stopping replay master on standby
DATA #1 : Boolean, 1 bytes
true
2023-03-07-02.17.04.514512+000 I1178122A454 LEVEL: Info
PID : 5702368 TID : 41893 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-4111 APPID: *LOCAL.DB2.230307021702
HOSTNAME: abcde001
EDUID : 41893 EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduShutdown, probe:29001
MESSAGE : HADR Shutdown has begun.
Read more...
Environment
- SAP on IBM Db2 for Linux, UNIX, and Windows
- Db2 version 11.5.6 and 11.5.7.
Product
Keywords
Replay master, handle recoverable error, hdrSetExplicitStarted, hit EOL for hadr , 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.