Show TOC

rs_set_isolation_levelLocate this document in the navigation structure

Passes the isolation level for transactions to the replicate data server.

Example 1

Creates an instance of an rs_set_isolation_level function string.

 create function string rs_set_isolation_level
 for sqlserver_derived_class
 output language
 'set transaction isolation level?rs_isolation_level!sys_raw?'
  • The rs_set_isolation_level function passes the transaction isolation level to the replicate data server, and executes every time the DSI connects to the replicate data server if a value has been set for dsi_isolation_level. Replication Server does not execute rs_set_isolation_level if the value of dsi_isolation_level is default or has not been set

  • Use alter connection or create connection with the dsi_isolation_level parameter to set the value for the variable <rs_isolation_level>. The supported Adaptive Server values are 0, 1, 2, and 3. Replication Server supports all other isolation level values supported by other data servers.

    If the value for dsi_isolation_level is default or has not been set, Replication Server uses the transaction isolation level of the target data server. See Select Isolation Levels in the Administration Guide Volume 2 for a description of Replication Server support for isolation levels.

  • Replication Server executes rs_set_isolation_level immediately after executing the rs_usedb function-string command.

  • The rs_set_isolation_level function has function-string class scope.

  • Replication Server creates an initial rs_set_isolation_level function string for the Adaptive Server and default function-string classes during installation.

  • If you use a nondefault function-string class and you use the parallel DSI feature, create a function string for the rs_set_isolation_level function. The modified function string must contain the variable <rs_isolation_level>.

  • Create or customize an rs_set_isolation_level function string at the Replication Server that is the primary site for the class.