You can set multiple transaction rules for a single connection. For example, applying both origin session ID and origin begin and commit times best approximates the processing environment at the primary database.
When more than one transaction rule is specified, Replication Server applies the rules in the order in which they are entered in the alter connection set dsi_partitioning_rule syntax.
For example, if dsi_partitioning_rule is set to “time, user,” Replication Server checks origin begin and commit times before checking user ID. If no conflict exists for origin begin and commit times, Replication Server checks user ID. If there is a conflict involving begin and commit times, Replication Server applies the time rule without checking the user ID. Thus, two transactions will be assigned to different parallel DSI threads if the origin begin time of the later transaction is earlier than the commit time—even if both transactions have the same user ID.
