SAP Knowledge Base Article - Preview

2896126 - DB6: SQL1767N Start HADR cannot complete. Reason code = "1"

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

Search for additional results

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