Replication Server Connection Properties

Replication Server connection property sheets contain all the standard data connection tabs, along with the Connection tab, the Database Options tab, the Security tab, and the Transaction Options tab.

Connection Tab

The following properties are available on the Connection tab:

Property

Description

Connection option

Option for a connection: dsi_suspended or log transfer on.

Scripting name: ConnectionOption

Connection profile (v15.2 and higher)

Specifies a connection profile that will create the necessary connection configurations and replicate database object definitions. Select the appropriate profile from the list.

Scripting name: ConnectionProfile

Connection profile version (v15.2 and higher)

Specifies the version of the connection profile to use.

Scripting name: ConnectionProfileVersion

Function string class

Name of the function class.

Scripting name: FunctionClass

Error string class

Name of the error class.

Scripting name: ErrorClass

User name

Maintenance user name.

Scripting name: UserName

Password

Maintenance user password.

Scripting name: Password

Dump marker

If this connection is in a connection group, then it can be flagged as dump marker.

Scripting name: DumpMarker

Database Options tab

The following properties are available on the Database Options tab:

Property Description

Number of commands in log

Specifies the number of commands to write into the exceptions log for a transaction. The value "–1" stands for all commands.

Scripting name: DatabaseParameter_dsi_max_cmds_to_log

Number of bytes in log

Specifies the number of bytes to write into the exceptions log for each rs_writetext function in a failed transaction. Change this parameter to prevent transactions with large text, image or raw object columns from filling the RSSD or its log. The value "-1" means all text, image, or rawobject columns.

Scripting name: DatabaseParameter_dsi_max_text_to_log

Number of transactions in group

Specifies the maximum number of transactions in a group. Larger numbers may improve data latency at the replicate database. Range of values: 1 – 100.

Scripting name: DatabaseParameter_dsi_max_xact_in_group

Number of parallel threads

Specifies the number of parallel DSI threads to be reserved for use with large transactions. The maximum value is one less than the value of dsi_num_threads.

Scripting name: DatabaseParameter_dsi_num_large_xact_threads

Cache size

Specifies the maximum SQT (Stable Queue Transaction interface) cache memory for the database connection, in bytes. The default, "0," means that the current setting of sqt_max_cache_size is used as the maximum cache size for the connection. To confirm the current value of sqt_max_cache_size, execute rs_configure.

Scripting name: DatabaseParameter_dsi_sqt_max_cache_size

Group size

Specifies the maximum number of bytes, including stable queue overhead, to place into one grouped transaction. A grouped transaction is multiple transactions that the DSI applies as a single transaction. A value of -1 means no grouping.

Scripting name: DatabaseParameter_dsi_xact_group_size

Number of commands per timeslide

Specifies the number of LTL commands an LTI or RepAgent Executor thread can possess before it must yield the CPU to other threads.

Scripting name: DatabaseParameter_exec_cmds_per_timeslice

Save interval

Specifies the number of minutes that the Replication Server saves messages after they have been successfully passed to the destination data server.

Scripting name: DatabaseParameter_save_interval

Partitioning rule

Specifies the partitioning rules (one or more) the DSI uses to partition transactions among available parallel DSI threads.

Scripting name: DatabaseParameter_dsi_partitioning_rule

Use batch markers (v15.0 and higher)

Controls the processing of function strings rs_batch_start and rs_batch_end. If use_batch_markers is set to on, the rs_batch_start function string is prepended to each batch of commands and the rs_batch_end function string is appended to each batch of commands. Set use_batch_markers to on only for replicate data servers that require additional SQL to be sent at the beginning or end of a batch of commands that is not contained in the rs_begin function string.

Scripting name: DatabaseParameter_use_batch_markers

Dynamic sql

Specifies the mode (on, off, default) of the connection so that the replication definition allows the execution of dynamic SQL statements . Additional configuration parameters linked to dynamic SQL are only available when the mode is set to "on".

Scripting name: DatabaseParameter_DynamicSQL

Replication

Specifies whether or not transactions applied by the DSI are marked in the transaction log as being replicated.

Scripting name: DatabaseParameter_dsi_replication

Serialization method

Specifies the method used to maintain serial consistency between parallel DSI threads when applying transactions to a replicate data server.

Scripting name: DatabaseParameter_dsi_serialization_method

SQL data style

Formats datatypes (particularly date/time, binary, bit and money) to be compatible with: DB2 ("db2"), Lotus Notes ("notes"), SQL Anywhere, formerly Watcom SQL ("watcom") or SQL Remote ("sqlremote").

Scripting name: DatabaseParameter_dsi_sql_data_style

Text convert multiplier

Changes the length of text datatype columns at the replicate site. Use dsi_text_convert_multiplier when text datatype columns must expand or contract due to character set conversion. Replication Server multiplies the length of primary text data by the value of dsi_text_convert_multiplier to determine the length of text data at the replicate site. Its type is float.

Scripting name: DatabaseParameter_dsi_text_convert_multiplier

Dump load

Enables coordinated dump when set to "on" at replicate sites only.

Scripting name:DatabaseParameter_dump_load

Distributor write request limit

Specifies the amount of memory available to the Distributor for messages waiting to be written to the outbound queue.

Scripting name: DatabaseParameter_md_sqm_write_request_limit

Subscription write request limit

Specifies the memory available to the subscription materialization or dematerialization thread for messages waiting to be written to the outbound queue.

Scripting name: DatabaseParameter_sub_sqm_write_request_limit

LTI write request limit

Specifies the amount of memory available to the LTI or RepAgent Executor thread for messages waiting to be written to the inbound queue.

Scripting name: DatabaseParameter_exec_sqm_write_request_limit

Parallel DSI

Provides a shorthand method for configuring parallel DSI threads. A setting of "on" configures these values: dsi_num_threads to 5 dsi_num_large_xact_threads to 2 dsi_serialization_method to "wait_for_commit" dsi_sqt_max_cache_size to 1 million bytes A setting of "off" configures these parallel DSI values to their defaults.

Scripting name: DatabaseParameter_parallel_dsi

Replication DDL (v15.0 and higher)

Specifies whether or not transactions are to be replicated back to the original database to support bidirectional replication. When set to "on", DSI sends set replication off to the replicate database, which instructs it to mark the succeeding DDL transactions available in the system log not to be replicated. Therefore, these DDL transactions are not replicated back to the original database, which enables DDL transaction replication in bidirectional MSA replication environment.

Scripting name: DatabaseParameter_dsi_replication_ddl

Dynamic sql cache management (v15.1 and higher)

Specifies the dynamic SQL cache for a connection. You can choose from one of the following values:
  • mru (default) – specifies that once dynamic_sql_cache_size is reached, the old dynamic SQL prepared statements are deallocated to give room for new statements.
  • fixed – specifies that once the dynamic_sql_cache_size is reached, allocation for new dynamic SQL statements stops.

Scripting name:DatabaseParameter_dynamic_sql_cache_management

Dynamic SQL cache size (v15.1 and higher)

Specifies an estimation of the number of database objects which can be used by SQL for a connection. This can be used to limit resource demand on a data server. Minimum value 1 is and Maximum value is 65,535.

Scripting name: DatabaseParameter_dynamic_sql_cache_size

Security Tab

The following properties are available on the Security tab:

Property Description

Message confidentiality

Specifies whether Replication Server sends and receives encrypted data. If set to "required," outgoing data is encrypted. If set to "not required," Replication Server accepts incoming data that is encrypted or not.

Scripting name: SecurityParameter_msg_confidentiality

Unified login

Specifies how Replication Server seeks to log in to remote data servers and accepts incoming logins.

Scripting name: SecurityParameter_unified_login

Use security services

Specifies whether Replication Server can use security services. If use_security_services is "off," no security features take effect. This parameter can only be set by configuring Replication Server.

Scripting name: SecurityParameter_use_security_services

Message integrity

Specifies whether data is checked for tampering.

Scripting name: SecurityParameter_msg_integrity

Message origin check

Specifies whether the source of data should be verified.

Scripting name: SecurityParameter_msg_origin_check

Message replay detection

Specifies whether data should be checked to make sure it has not been read or intercepted.

Scripting name: SecurityParameter_msg_replay_detection

Message sequence check

Specifies whether data should be checked for interception.

Scripting name: SecurityParameter_msg_sequence_check

Mutual authorization

Requires remote server to provide proof of identify before a connection is established.

Scripting name: SecurityParameter_mutual_auth

Security mechanism

The name of the third-party security mechanism enabled for the pathway.

Scripting name: SecurityParameter_security_mechanism

Transaction Tab

The following properties are available on the Transaction tab:

Property Description

Disk affinity

Specifies an allocation hint for assigning the next partition. Enter the logical name of the partition to which the next segment should be allocated when the current partition is full.

Scripting name: DatabaseParameter_disk_affinity

Packet size

Specifies the maximum size of a network packet. During database communication, the network packet value must be within the range accepted by the database. You may change this value if you have a System 10 or later SQL Server or Adaptive Server that has been reconfigured.

Scripting name: DatabaseParameter_db_packet_size

Batch

Specifies how Replication Server sends commands to data servers. When batch is "on," Replication Server may send multiple commands to the data server as a single command batch. When batch is "off," Replication Server sends commands to the data server one at a time.

Scripting name: DatabaseParameter_batch

Batch begin

Specifies whether a begin transaction can be sent in the same batch as other commands (such as insert, delete, and so on).

Scripting name: DatabaseParameter_batch_begin

Command retry

Specifies the number of times to retry a failed transaction. The value must be greater than or equal to 0.

Scripting name: DatabaseParameter_command_retry

Command batch size

Specifies the maximum number of bytes that Replication Server places into a command batch.

Scripting name: DatabaseParameter_dsi_cmd_batch_size

Command separator

Specifies the character that separates commands in a command batch.

Scripting name: DatabaseParameter_dsi_cmd_separator

Character convert

The specification for handling character-set conversion on data and identifiers between the primary Replication Server and the replicate Replication Server. This parameter applies to all data and identifiers to be applied at the DSI in question.

Scripting name: DatabaseParameter_dsi_charset_convert

Check locks interval

Specifies the number of milliseconds (ms) the DSI executor thread waits between executions of the rs_dsi_check_thread_lock function string. Used with parallel DSI function string. Used with parallel DSI.

Scripting name: DatabaseParameter_dsi_commit_check_locks_intrvl

Stop Unsupported Commands (v15.0 and higher)

When set to on, DIST suspends itself if a command is not supported by downstream Replication Server. When set to off, DIST ignores the unsupported command. Regardless of dist_stop_unsupported_cmd parameter's setting, Replication Server always logs an error message when it sees the first instance of a command that cannot be sent over to a lower-version Replication Server.

Scripting name: DatabaseParameter_dist_stop_unsupported_cmd

DSI dataserver make (v15.5 and higher)

[Non-ASE replicate database connections] Specifies the data server type that contains the replicate database that you want to use RTL for.

Scripting name: ConnectionParameter_dsi_dataserver_make

DSI compile enable (v15.5 and higher)

[Primary database connections] Enables High Volume Adaptive Replication (HVAR), in which Replication Server compiles log-ordered, row-by-row changes to net-row changes.

Scripting name: DatabaseParameter_dsi_compile_enable

DSI bulk copy (v15.1 and higher)

Turns the bulk copy-in feature on or off for a connection. If dynamic_sql and dsi_bulk_copy are both on, DSI applies bulk copy-in. Dynamic SQL is used if bulk copy-in is not used.

Scripting name: DatabaseParameter_dsi_bulk_copy

Check locks times

Specifies the number of times the DSI executor thread executes the rs_dsi_check_thread_lock function string before logging a warning message. Used with parallel DSI.

Scripting name: DatabaseParameter_dsi_commit_check_locks_logs

Max check locks times

Specifies 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.

Scripting name: DatabaseParameter_dsi_commit_check_locks_max

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).

Scripting name: DatabaseParameter_dsi_commit_control

Request stored procedure

Turns on or off request stored procedures at the DSI of the primary Replication Server.

Scripting name: DatabaseParameter_dsi_exec_request_sproc

Fade out time

Specifies the number of seconds of idle time before a DSI connection is closed. A value of "-1" specifies that a connection will not close.

Scripting name: DatabaseParameter_dsi_fadeout_time

Ignore underscore name

When the transaction partitioning rule is set to "name," specifies whether or not Replication Server ignores transaction names that begin with an underscore.

Scripting name: DatabaseParameter_dsi_ignore_underscore_name

Keep triggers

Specifies whether triggers should fire for replicated transactions in the database. Set off to cause Replication Server to set triggers off in the Adaptive Server database, so that triggers do not fire when transactions are executed on the connection. Set on for all databases except standby databases.

Scripting name: DatabaseParameter_dsi_keep_triggers

Number of transactions in log

Specifies the number of commands allowed in a transaction before the transaction is considered to be large.

Scripting name: DatabaseParameter_dsi_large_xact_size

Number of threads

Specifies the number of parallel DSI threads to be used. The maximum value is 255.

Scripting name: DatabaseParameter_dsi_num_threads

DSI isolation level (v15.0 and higher)

Specifies the isolation level for transactions. The 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. NoteData servers supporting other isolation levels are supported as well through the use of the rs_set_isolation_level function string. Replication Server supports all values for replicate data servers. The default value is the current transaction isolation level for the target data server.

Scripting name: DatabaseParameter_dsi_isolation_level

DSI connector type (v15.5 and higher)

[non-ASE replicate database connections] Specifies the connector type used for the connector implementation, such as Open Client, JDBC and ODBC. When multiple connectors are available, RepServer will designate one as the default.

Scripting name: ConnectionParameter_dsi_connector_type

DSI compile max cmds (v15.5 and higher)

Specifies when HVAR replication should finish current transaction grouping and start a new group. If there are no more commands to read, it will finish the current group even if the group has not reached to the maximum number of commands. The default value is 100,000 commands, with a minimum of 100.

Scripting name: DatabaseParameter_dsi_compile_max_cmds

DSI bulk threshold (v15.1 and higher)

Specifies the number of insert commands that, when reached, triggers Replication Server to use bulk copy-in. When Stable Queue Transaction (SQT) encounters a large batch of insert commands, it retains in memory the number of insert commands specified to decide whether to apply bulk copy-in. Because these commands are held in memory, Sybase suggests that you do not configure this value much higher than the configuration value for dsi_large_xact_size. Minimum: 1

Scripting name: DatabaseParameter_dsi_bulk_threshold

Replicate Tables

For Replication Server v15.5 and higher, the Replicate Tables tab is available for connections to replicate databases and lists the tables to replicate (see Replication Server Replicate Table Properties).