Database connection parameters

Table 7-3 describes the new database connection configuration parameters.

Table 7-3: New configuration parameters

Parameter

Description

dsi_commit_check_locks_intrvl

The number of milliseconds (ms) the DSI executor thread waits between executions of the rs_dsi_check_thread_lock function string.Default: 1000ms (1 second) Minimum: 0 Maximum: 86,400,000 ms (24 hours)

dsi_commit_check_locks_max

The maximum number of times a DSI executor thread checks whether it is blocking other transactions in the replicate database before rolling back its transaction and retrying it. Used with parallel DSI.

Default: 200 Minimum: 1 Maximum: 1,000,000

dsi_commit_control

Specifies whether commit control processing is handled internally by Replication Server using internal tables (on) or externally using the rs_threads system table (off).

Default: off

rep_as_standby

When rep_as_standby is on, table subscriptions replicate tables marked by sp_reptostandby.

For rep_as_standby on to succeed, the RepAgent parameters send maint xacts to replicate must be false and send warm standby xacts must be true.

Default: off

Table 7-4 describes changed configuration parameters.

Table 7-4: Changed database configuration parameters

Parameter

Description of enhancements

dsi_partitioning_rule

Provides new options:

  • origin – specifies that transactions with the same origin must be serialized when applied to the replicate database.

  • origin_sessid – specifies that transactions with the same origin and the same process ID must be serialized when applied to the replicate database.

dsi_serialization_method

Provides new options:

  • no_wait – specifies that a transaction can start as soon as it is ready. Replaces the none option.

  • wait_for_start – specifies that a transaction can start as soon as the transaction scheduled to commit immediately before has started.