DB2® High Availability Disaster Recovery (HADR) uses database logs to replicate data from the primary database to the standby database. Non-logged operations are allowed on the primary database, but not replicated to the standby database. If you want non-logged operations, such as updates to the history file, to be reflected in the standby database, you must take extra steps to cause this to happen.
RESTORE DB KELLY REPLACE HISTORY FILE
After
HADR is initialized and subsequent backup activities take place on
the primary database, the history file on the standby database will
become out of date. However, a copy of the history file is stored
in each backup image. You can update the history file on the standby
by extracting the history file from a backup image using the following
command: RESTORE DB KELLY HISTORY FILE
Do
not use regular operating system commands to copy the history file
in the database directory from the primary database to the standby
database. The history file can become corrupted if the primary is
updating the files when the copy is made.If a takeover operation occurs and the standby database has an up-to-date history file, backup and restore operations on the new primary will generate new records in the history file and blend seamlessly with the records generated on the original primary. If the history file is out of date or has missing entries, an automatic incremental restore might not be possible; instead, a manual incremental restore operation will be required.