DB2 Version 9.7 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----------------+-------------><
                 +- -file--log_control_file------+   
                 '- -path--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.
-file log_control_file
Specifies the log control file path and file name.
Important: This option is deprecated and might be removed in a future release because of the usage of mirrored log control files.
-path log_control_files_dir
Specifies the full path to the directory where the log control files, SQLOGCTL.LFH.1 and its mirror copy SQLOGCTL.LFH.2, reside.

Usage notes

With the -file parameter, only the specified log control file, for example either SQLOGCTL.LFH.1 or SQLOGCTL.LFH.2, will be updated. This will cause the two files to be out of synchronization. For this reason, it is recommended that the database_alias or the -path option be used whenever possible, rather than the -file option.