rs_repl_off

Specifies whether transactions executed by the maintenance user in the Adaptive Server database are replicated.

Examples

Example 1

Creates an instance of an rs_repl_off function string.

create function string rs_repl_off
 for sqlserver_derived_class
 output language
 'set replication off'

Usage

rs_repl_off is executed for the DSI connection to a standby database.
rs_repl_off has function-string-class scope.
Replication Server creates an initial rs_repl_off function string for the system-provided function-string classes during installation.
If you use a user-created base function-string class, create a function string for rs_repl_off if you plan to use it in any way other than the default.
Create or customize an rs_repl_off function string at the Replication Server that is the primary site for the class.
Standby database connections always use the system-provided class <rs_default_function_class>, which cannot be modified. Therefore, if you are not using warm standby, you do not need to create a function string for rs_repl_off.
You can use alter connection or configure connection to set the dsi_replication configuration parameter and to specify whether or not to execute the rs_repl_off function when connecting to the standby database. Set dsi_replication to “off” to execute rs_repl_off.
In a warm standby application, Replication Server sets dsi_replication to “on” for the active database and to “off” for the standby database.