This method is identical to wait_for_start except that it specifies transaction isolation level 3 for the DSI /E session in the replicate database. This type of locking prevents “non-repeatable reads” and “phantoms” from occurring by applying an index page or table lock until the end of the transaction.
Select this serialization method if you are using triggers to enforce referential integrity of data across a database. It prevents phantom rows from occurring in a table while a trigger is being executed.
Replication Server uses the rs_set_isolation_level_3 system function to turn on transaction isolation_level_3. This system function is executed every time the DSI connects to the replicate data server.
Use this method only when wait_for_start does not introduce inordinate contention and the replciated transaction must performa a repeatable read, or the replicate database is using row-level locking.
Replication Server automatically creates a function
string for the rs_set_isolation_level3 function
in function-string classes in which Replication Server generates
default function strings. For other function-string classes, you must
create rs_set_isolation_level3 function
strings before you can use the parallel DSI feature.
