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.

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’

Note: 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.

For details about the commands discussed, see the Replication Server Reference Manual.

Version Requirements

You can use dsi_non_blocking_commit only with Adaptive Server 15.0 and later, and Oracle 10g v2 and later. Replication Server disables the dsi_non_blocking_commit configuration parameter for the connection for unsupported versions of Adaptive Server, Oracle, or other databases.