db2rfpen - Set rollforward pending state command

This command prepares the database for recovery after restoring an offline file system backup of the database (for example, split mirror file system backup), by putting the database into rollforward pending state. This allows ROLLFORWARD DATABASE command to be issued on this database. If the offline file system backup is taken from a high availability disaster recovery (HADR) primary database, this tool also changes the database role from primary to standard. This allows the database to be initialized as HADR standby, via the START HADR AS STANDBY command.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramdb2rfpenONdatabase_alias-pathglobal_log_control_files_dir

Command parameters

database_alias
Specifies the name of the database to be placed in rollforward pending state. If you are using high availability disaster recovery (HADR), the database is reset to a standard database.
-path global_log_control_files_dir
Specifies the full path to the directory where the global log control files, SQLOGCTL.GLFH.1 and its mirror copy SQLOGCTL.GLFH.2, reside.

Usage notes

Attention: The file system copy must be done after a clean database shutdown. A clean database shutdown means that the database is not in a crash recovery pending state.

The following steps must be completed if at some later time you need to restore a file system copy, and want to apply log files to roll forward the database or initialize the database as HADR standby.

  1. Restore the file system copy of the database.
  2. Run the db2rfpen tool to put the database into a rollforward pending state.
  3. Issue the ROLLFORWARD DATABASE command to apply the log files, or the START HADR AS STANDBY command to become HADR standby.