Show TOC

sysadmin hibernate_offLocate this document in the navigation structure

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>.

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. Instead, to recover the route upgrade: use
    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.