With Adaptive Server Enterprise version 15.0, ESD #2, the recovery_foreground configuration parameter is added to the list of parameters for the sp_start_rep_agent system procedure in Chapter 5, “Adaptive Server Commands and System Procedures” in the Reference Manual.
Configuration parameter |
Description |
|---|---|
recovery_foreground |
Starts a RepAgent in recovery mode and displays the recovery progress information on screen without the user having to check the Adaptive Server error log file for the recovery progress. The recovery is complete once the recovery progress information display ends and the command prompt displays. |
For example, to display the recovery progress information for database dbname for which you want to start a RepAgent, where connect_dataserver is the data server used to recover offline logs and connect_database is the database used to recover offline logs, enter:
sp_start_rep_agent dbname, 'recovery_foreground', 'connect_dataserver', 'connect_database'
