If your transactions conflict with each other only occasionally, set the parallel DSI configuration parameters as follows:
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.
See “Setting isolation levels for non-Sybase replicate data servers”.
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.
