If your transactions conflict with each other only occasionally, set the parallel DSI configuration parameters as follows:
dsi_serialization_method – set this parameter to isolation level 3 if you have Adaptive Server or SQL Server version 10.0.x or later.
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.
