Show TOC

rs_repl_offLocate this document in the navigation structure

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

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