Symptom
HADR Standy failed to start with the error:
SQL1767N Start HADR cannot complete. Reason code = "1"
The following information can be found in the db2diag.log of the standby system:
2020-02-13-09.45.09.569188+330 I199800215E554 LEVEL: Info
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:2120
MESSAGE : ADM1605I The database manager is invoking the backward phase of
database rollforward recovery.
2020-02-13-09.45.09.610478+330 I199800770E556 LEVEL: Info
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, recovery manager, sqlpUpdateChainIdForRfwd, probe:2350
MESSAGE : Forward phase of rollforward is completing. New log chain is:
DATA #1 : unsigned integer, 4 bytes
3
2020-02-13-09.45.12.118518+330 E199811392E511 LEVEL: Warning
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8180
MESSAGE : ADM1611W The rollforward recovery phase has been completed.
2020-02-13-09.45.12.118873+330 E199811904E492 LEVEL: Warning
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8181
MESSAGE : The rollforward recovery phase completed.
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
ADM1611W, ADM1605I, Forward phase of rollforward, HADR, standby , 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.