Infrequent Conflicting Updates

Set values for the parallel DSI configuration parameters if your transactions conflict with each other only occasionally.

Set these parallel DSI configuration parameters:

  • dsi_isolation_level – set this parameter to isolation level 3 if your replicate data server is Adaptive Server. For non-Sybase data servers, set to the level that corresponds to ANSI standard level 3 through the use of the rs_set_isolation_level custom function string.

    • Oracle and Microsoft SQL Server – SERIALIZABLE level equals the ANSI SQL Isolation Level 3.

    • DB2 – REPEATABLE READ level equals the ANSI SQL Isolation 3.

  • dsi_num_large_xact_threads – set this parameter to 2. If you are configuring parallel DSI in a warm standby application, set the dsi_num_larg_xact_threads parameter for the standby database to one more than the number of simultaneous large transactions executed at the active database.

  • dsi_num_threads – set this parameter to 3 plus the value of the dsi_num_large_xact_threads parameter.

Parent topic: Configuration of Parallel DSI for Optimal Performance
Related concepts
Set Isolation Levels for Non-Sybase Replicate Data Servers