DB2 10.5 for Linux, UNIX, and Windows

db2rfpen - Reset rollforward pending state command

Puts a database in rollforward pending state. If you are using high availability disaster recovery (HADR), the database is reset to a standard database.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-db2rfpen--ON--+-database_alias-----------------------+------><
                 '- -path--global_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

If you take file system backups of the database (for example, split mirror file system backups) the db2rfpen tool can be used to put the database into a rollforward pending state. By doing this, you can apply log files with the ROLLFORWARD command when you restore a file system copy.

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:

  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.