The dsi_non_blocking_commit configuration parameter extends the period of time Replication Server saves messages after a commit.
Extending the save period requires a larger stable queue. See “Stable queues,” in Chapter 2, “Replication Server Technical Overview” in the Replication Server Administration Guide Volume 1.
Use alter connection to configure dsi_non_blocking_commit for a database connection:
alter connection to data_server.database set dsi_non_blocking_commit to ‘value’
You cannot use this parameter with alter connection to
configure an active database connection in a standby environment.
Use configure replication server to configure dsi_non_blocking_commit as a server default:
configure replication server set dsi_non_blocking_commit to ‘value’
where value is the number of minutes, to a maximum of 60, to extend the save period. The default is zero, which disables non-blocking commit.
Use admin config to check the current value of dsi_non_blocking_commit.
