Show TOC

System Administration CommandsLocate this document in the navigation structure

Use these commands to perform system administration tasks, and to troubleshoot problems that follow system failures. You must have “sa” permission to execute these commands.


Many of these commands should be used with caution and only in very restricted circumstances. Please check the associated documentation carefully before you use them.

  • alter queue – specifies the behavior of a stable queue that encounters a large message of greater than 16K bytes. Use only if the Replication Server version is 12.5 or later and the site version is 12.1 or earlier.

  • resume distributor – resumes a suspended distributor thread for a connection to a database.

  • shutdown – shuts down a Replication Server.

  • suspend distributor – suspends the distributor thread for a connection to a database.

  • sysadmin apply_truncate_table – turns the “subscribe to truncate table” option on or off for existing subscriptions to a particular table, enabling or disabling replication of truncate table.

  • sysadmin dropdb – drops references to a database from the ID Server.

  • sysadmin dropldb – drops references to a logical database from the ID Server.

  • sysadmin drop_queue – deletes a stable queue.

  • sysadmin droprs – drops references to a Replication Server from the ID Server.

  • sysadmin dump_file – specifies an alternate log file for use when a stable queue is dumped.

  • sysadmin dump_queue – dumps the contents of a stable queue.

  • sysadmin erssd – allows you to check ERSSD file locations and backup configurations, defragment ERSSD files, move ERSSD files or perform an unscheduled backup of the ERSSD.

  • sysadmin fast_route_upgrade – updates the route version to the site version of the lower of the primary or replicate Replication Server.

  • sysadmin hibernate_off – turns off hibernation mode for the Replication Server and returns it to an active state.

  • sysadmin hibernate_on – turns on hibernation mode for (or suspends) the Replication Server.

  • sysadmin log_first_tran – writes the first transaction in a Data Server Interface (DSI) queue to the exceptions log.

  • sysadmin purge_all_open – purges all open transactions from the inbound queue.

  • sysadmin purge_first_open – purges the first open transaction from the inbound queue.

  • sysadmin purge_route_at_replicate – removes all references to the primary Replication Server from a Replication Server at a replicate site.

  • sysadmin restore_dsi_saved_segments – restores backlogged transactions so that they can be reapplied to the database.

  • sysadmin set_dsi_generation – changes a database generation number in the RSSD to prevent Replication Server from reapplying transactions in the stable queue after a replicate database is restored.

  • sysadmin site_version – sets the site version level.

  • sysadmin sqm_purge_queue – removes all messages from a Replication Server Interface (RSI) stable queue.

  • sysadmin sqm_unzap_command – restores a deleted message in a stable queue.

  • sysadmin sqm_zap_command – deletes a single message in a stable queue.

  • sysadmin sqt_dump_queue – dumps the transaction cache for each inbound or DSI queue.

  • sysadmin system_version – sets the minimum Replication Server version level for the replication system.