Database connection parameters

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

Table 3-3: New configuration parameters

Parameter

Description

dsi_ignore_commit_order

Removes restrictions when a transaction is submitted or committed to the replicate database.

dsi_isolation_level

Specifies the isolation level for transactions. ANSI standard and Adaptive Server supported values are:

  • 0 – ensures that data written by one transaction represents the actual data.

  • 1 – prevents dirty reads and ensures that data written by one transaction represents the actual data.

  • 2 – prevents nonrepeatable reads and dirty reads, and ensures that data written by one transaction represents the actual data.

  • 3 – prevents phantom rows, nonrepeatable reads, and dirty reads, and ensures that data written by one transaction represents the actual data.

NoteReplication Server support is not limited to ANSI standard values only.

dsi_replication_ddl

Specifies whether or not to replicate the DDL transactions in the transaction log.

dsi_rs_ticket_report

Specifies whether or not to invoke function string rs_ticket_report.

stats_show_zero_counters

Specifies whether or not to display counters with zero observations since the last reset.

Table 3-4 describes changed database configuration parameter.

Table 3-4: Changed database configuration parameter

Parameter

Description of enhancements

dsi_serialization_method

Option isolation_level_3 is not supported in this version.