sysadmin hibernate

Turns off hibernation mode for the Replication Server and returns it to an active state.

Syntax

sysadmin hibernate_off [, string_ID]

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.

Example 1 – This command turns off the hibernation mode of the Replication Server (TOKYO_RS):
```
sysadmin hibernate_off, TOKYO_RS
```

Hibernation mode is a Replication Server state in which:
- 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.
A destination Replication Server might be in hibernation mode when route upgrade fails. Do not use sysadmin hibernate_off to reactivate the Replication Server. Use Replication Manager to recover the route upgrade. For more information, see the Replication Manager online help.
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.