DB2 Rollforward command in HADR environment returns SQL1744N
db2scope 310002R9XW Visits (8909)
In HADR environment, after takeover on Standby, you may find some tablespaces in rollforward pending state.
However, if you attempt to do rollforward on these tablespaces, SQL1744N may be returned.
$ db2 rollforward db sample to end of logs tablespace '(ts1)' online
To resolve the problem, you can either reinitialize the HADR or stop HADR then perform rollforward :
1). Stop HADR on the standby database:
2). Restore the backup image of the primary database to the standby database:
3). After the database is restored to the standby, HADR related configuration parameters(HADR_*) now have the values set as the primary database. These need to be reset to the standby values appropriately.
4). Start HADR on the standby database:
Alternatively, you can stop HADR, then rollforward: