Use the commands provided in the replication command language (RCL) to
manage the replication environment.
abort switch
Aborts the switch active command, unless Replication Server has gone too far in the active switch process to abort it. The switch active command changes the active database in a warm standby application.
activate subscription
For a subscription to a replication definition or a publication, starts the distribution of updates from the primary to the replicate database and sets the subscription status to ACTIVE. The activate subscription command is part of the bulk materialization process, or part of the process of refreshing a publication subscription.
add partition
Makes a partition available to Replication Server. A partition can be a disk partition or an operating system file.
admin auto_part_path
Displays information on automatically resizable Replication Server partitions.
admin config
Displays all Replication Server configuration parameters.
admin disk_space
Displays use of each disk partition accessed by the Replication Server.
admin echo
Returns the string entered by the user.
admin pid
Displays the process ID of the Replication Server.
admin quiesce_check
Determines if the queues in the Replication Server have been quiesced.
admin quiesce_force_rsi
Determines whether a Replication Server is quiescent and forces it to deliver and obtain acknowledgments for messages in RSI queues.
admin rssd_name
Displays the names of the data server and database for the RSSD.
admin schedule
Displays information on task schedules in Replication Server.
admin security_property
Displays information about supported network-based security mechanisms and security services.
admin security_setting
Displays network-based security parameters and values for the Replication Server.
admin set_log_name
Closes the existing Replication Server log file and opens a new log file.
admin show_connection_profiles
Lists the profile name, version, and comments for each profile defined in SAP Replication Server.
admin show_connections
Displays information about all connections from the Replication Server to data servers and to other Replication Servers.
admin show_function_classes
Displays the names of existing function-string classes and their parent classes, and indicates the number of levels of inheritance.
admin show_route_versions
Displays the version number of routes that originate at the Replication Server and routes that terminate at the Replication Server.
admin sqm_process_time
Displays an estimate of the time Replication Server requires to process the remaining data in queues.
admin sqm_readers
Displays the read and delete points of the threads that are reading a stable queue.
admin stats
Displays information and statistics about Replication Server operations.
admin stats, backlog
Reports the volume of replicated transactions awaiting distribution in the inbound and outbound queues in terms of segments and blocks.
admin stats, cancel
Cancels the currently running asynchronous command. For multiple observation intervals, data already saved at the time of cancel is not deleted.
admin time
Displays the current time of Replication Server.
admin translate
Performs a datatype translation on a value, displaying the results in delimited literal format.
admin verify_repserver_cmd
Verifies that Replication Server can successfully execute a replication definition request.
admin version
Displays the version number of the Replication Server software.
admin version, "connection"
Lists the upgrade status of user databases and identifies user databases that you must upgrade after you upgrade Replication Server.
admin version, route
Reports the route to upgrade from the current Replication Server to the destination Replication Server, or from a source Replication Server to the current Replication Server, and checks the status of the route upgrade.
admin who
Displays information about threads running in the SAP Replication Server.
admin who_is_down
Displays information about Replication Server threads that are not running.
admin who_is_up
Displays information about Replication Server threads that are running.
allow connections
Places Replication Server in recovery mode for specified databases.
alter auto partition path
Changes the partition file size and the maximum size that you allow for a automatically resizable Replication Server partition.
alter connection
Changes the attributes of a database connection.
alter connector
Changes the attributes of a database connector.
alter error class
Changes an existing error class by copying error actions from another error class.
alter function
Adds parameters to a user-defined function.
alter function replication definition
Changes an existing function replication definition created by the create function replication definition command.
alter function string class
Alters a function-string class, specifying whether it should be a base class or a derived class.
alter logical connection
Disables or enables the Distributor thread for a logical connection, changes attributes of a logical connection, and enables or disables replication of truncate table to the standby database.
alter route
Changes the attributes of a route from the current Replication Server to a remote Replication Server.
alter schedule
Enables or disables a schedule that executes commands.
alter subscription
Moves a subscription between replicate connections of the same replicate database that use the same Replication Server, without the need to rematerialize. The subscription may be for a database replication definition, table replication definition, function replication definition, or publication.
assign action
Assigns Replication Server error-handling actions to data server or Replication Server errors received by the DSI thread.
check publication
Finds the status of a publication and the number of articles the publication contains.
check schema map
(Only if the replicate datatbase is SAP HANA database) Displays all the primary and replicate schema maps defined in Replication Server.
check subscription
Finds the materialization status of a subscription to a replication definition or a publication.
configure replication server
Sets characteristics of the SAP Replication Server, including network-based security, and configures the ERSSD.
configure route
Changes the attributes of a route from the current Replication Server to a remote Replication Server.
connect
Transforms the Replication Server into a gateway to its RSSD, ID server, to a remote Replication Server, or to a remote data server.
create alternate connection
Adds an alternate primary or replicate connection, or an alternate active or standby connection, and sets configuration parameters for the connection.
create alternate logical connection
Adds an alternate logical connection to the default logical connection. Replication Server uses logical connections to manage warm standby applications.
create applied function replication definition
Creates an applied function replication definition and a user-defined function for a stored procedure that is to be replicated. The applied function is applied at the replicate database by the maintenance user.
create article
Creates an article for a table or function replication definition and specifies the publication that is to contain the article.
create connection
Adds a database to the replication system and sets configuration parameters for the connection. To create a connection for an Adaptive Server database, use rs_init. To create a connection for a non-Adaptive Server database, see create connection using profile command.
create connection using profile
create connection using profile clause uses predefined information to configure the connection between Replication Server and a non-Adaptive Server database, and, if needed, to modify the RSSD and the named data_server.database. To create a connection to Adaptive Server, see create connection.
create function replication definition
Creates a function replication definition and user-defined function for a stored procedure that is to be replicated.
create function string
Adds a function string to a function-string class. Replication Server uses function strings to generate instructions for data servers.
create logical connection
Creates a logical connection. Replication Server uses logical connections to manage warm standby applications.
create partition
Makes a partition available to Replication Server. A partition can be a disk partition or an operating system file.
create publication
Creates a publication for tables or stored procedures that are to be replicated as a group to one or more subscribing replicate databases.
create request function replication definition
Creates a request function replication definition and a user-defined function for a stored procedure that is to be replicated. The request function is applied at the replicate database by the same user who executes the stored procedure at the primary database.
create route
Designates the route to use for a connection from the current Replication Server to a remote Replication Server.
create schedule
Creates a schedule to execute shell commands at a time you specify.
create subscription
Creates and initializes a subscription and materializes subscription data. The subscription may be for a database replication definition, table replication definition, function replication definition, or publication.
create user
Adds a new user login name to a Replication Server.
define subscription
Adds a subscription to the Replication Server system tables, but does not materialize or activate the subscription. The subscription may be for a database replication definition, a table replication definition, a function replication definition, or for a publication. This command begins the process of bulk subscription materialization, or the process of refreshing a publication subscription.
drop route
Closes the route to another Replication Server.
drop schedule
Drops a schedule that executes commands.
drop subscription
Drops a subscription to a database replication definition, table replication definition, function replication definition, article, or publication.
drop user
Drops a Replication Server user login name.
resume distributor
Resumes a suspended Distributor thread for a connection to a database.
resume log transfer
Allows the RepAgent to connect to the Replication Server.
resume queue
Restarts a stable queue stopped after being passed a message larger than 16K bytes. Applicable only when the Replication Server version is 12.5 or later and the site version has not been similarly upgraded.
suspend distributor
Suspends the Distributor thread for a connection to a primary database.
suspend log transfer
Disconnects a RepAgent from a Replication Server and prevents a RepAgent from connecting.
suspend route
Suspends a route to another Replication Server.
switch active
Changes the active database in a warm standby application.
sysadmin apply_truncate_table
Turns on or off the “subscribe to truncate table” option for all existing subscriptions to a particular table, enabling or disabling replication of truncate table.
sysadmin cdb
Administers the net-change database in real-time loading (RTL) replication to SAP IQ and high volume adaptive replication (HVAR) into Adaptive Server.
sysadmin dump_tran
Dumps the statements of a specific stable queue transaction into a log file.
sysadmin erssd
Allows you to check ERSSD file locations and backup configurations, 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 issue_ticket
Injects an rs_ticket marker into an inbound or an outbound queue.
sysadmin ldap
Configures or lists an LDAP URL, specifies the access accounts for LDAP user authentication, or verifies an LDAP URL or login-related parameters.
sysadmin lmconfig
Configures and shows license management-related information in Replication Server.
sysadmin log_first_tran
Writes the first transaction in a DSI queue into the exceptions log.
sysadmin principal_users[,reload]
Reloads or shows principal name of all Replication Servers stored in the rs_principal_users.cfg configuration file.
sysadmin purge_all_open
Purges all open transactions from an inbound queue of a Replication Server.
sysadmin purge_first_open
Purges the first open transaction from the inbound queue of a Replication Server.
sysadmin set_dsi_generation
Changes a database generation number in the Replication Server to prevent the application of transactions in the DSI stable queue after a replicate database is restored.
sysadmin site_version
Sets the site version number for the SAP Replication Server. This lets you use the software features in the corresponding version, and prevents you from downgrading to an earlier version. If the SAP Replication Server uses ERSSD, this command also shuts down the ERSSD, upgrades its database file and restarts ERSSD.
sysadmin skip_bad_repserver_cmd
Instructs Replication Server to skip a failed replication definition request the next time Replication Agent starts.
sysadmin system_version
Displays or sets the system-wide version number for the replication system, allowing you to use the software features in the corresponding release level.
sysadmin upgrade, route
Upgrades route from the current Replication Server to the destination Replication Server, and recover any failed upgrade routes.
validate publication
Sets the status of a publication to VALID, allowing new subscriptions to be created for the publication.
validate subscription
For a subscription to a replication definition or a publication, sets the subscription status to VALID.
wait for create standby
A blocking command that allows a client session in the Replication Server to wait for the standby database creation process to complete.
wait for delay
Specifies a time interval at which this command is blocked.
wait for switch
A blocking command that allows a client session in the Replication Server to wait for the switch to the new active database to complete.
wait for time
Specifies a time of day at which to unblock this command.
Created April 14, 2014. Send feedback on this help topic to Technical Publications:
pubs@sap.com