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