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