Non-blocking Commit

Replication Server 15.2 includes non-blocking commit, which uses the delayed commit feature in Adaptive Server to improve replication performance.

• Adaptive Server Delayed Commit Feature
  Adaptive Server 15.0 and later includes the delayed commit feature designed to improve performance by delaying the commit phase of a transaction.
• dsi_non_blocking_commit Configuration Parameter
  The dsi_non_blocking_commit configuration parameter extends the period of time Replication Server saves messages after a commit.
• rs_non_blocking_commit System Function
  rs_non_blocking_commit executes every time DSI connects to the replicate data server, if the dsi_non_blocking_commit value is from 1 to 60. If the value of dsi_non_blocking_commit is zero, rs_non_blocking_commit does not execute.
• rs_non_blocking_commit_flush System Function
  rs_non_blocking_commit_flush executes at intervals equal to any number of minutes from 1 to 60 that you specify with dsi_non_blocking_commit. rs_non_blocking_commit_flush does not execute if the value of dsi_non_blocking_commit is zero.
• Non-Adaptive Server Databases Supported
  Replication Server 15.2 with non-blocking commit enabled supports replication into Oracle 10g v2 and later because Oracle 10g v2 supports functionality similar to delayed commit.