rs_repl_off

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

Examples

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.

Related reference
create connection
create function string