Database connection parameters

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

**Table 9-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 9-4 describes changed configuration parameters.

**Table 9-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.