Turns off hibernation mode for the Replication Server and returns it to an active state.
sysadmin hibernate_off [, <string_ID>]
A valid identifier. If <string_ID> was specified with sysadmin hibernate_on, you must specify the same one that was used for sysadmin hibernate_on.
If you forget the <string_ID>, you can find it in the <text >column of the <rs_recovery >system table.
If you need to turn off hibernation mode for a replicate Replication Server after a successful route upgrade or route upgrade recovery, use the Replication Server name for the <string_ID>.
This command turns off the hibernation mode of the Replication Server (TOKYO_RS):
sysadmin hibernate_off, TOKYO_RS
all Data Definition Language (DDL) commands are rejected,
most service threads, such as Data Server Interface (DSI), distributor, and Replication Server Interface (RSI) sender threads, are suspended,
all routes and connections are suspended, and
RSI users are logged off and not allowed to log back into the Replication Server.
You can execute system information (admin) and system administration (sysadmin) type commands while in hibernation mode.
Execute this command at the Replication Server for which you want to turn off hibernation mode.
sysadmin upgrade, “route”, <dest_replication_server>, "recovery"
Occasionally, a destination Replication Server is placed into hibernation mode after a successful route upgrade. Use sysadmin hibernate_off to reactivate the destination Replication Server.
sysadmin hibernate_off requires “sa” permission.