alter connection

Changes the attributes of a database connection.

Syntax

alter connection to data_server.database {
     [for replicate table named [table_owner.]table_name 
     [set table_param [to] ‘value’]] |
     set function string class [to] function_class |
     set error class [to] error_class |
     set replication server error class [to] rs_error_class |
     set password [to] passwd |
     set dsi_connector_sec_mech [to] hdbuserstore |
     set log transfer [to] {on | off} |
     set database_param [to] 'value' |
     set security_param [to] 'value' |
     set security_services [to] 'default']
     set dataserver and database name [to] new_ds.new_db |
     set trace [to] 'value'}

Parameters

data_server – The data server that holds the database whose connection is to be altered.
database – The database whose connection is to be altered.
for replicate table named – Specifies the name of the table at the replicate database. table_name is a character string of up to 200 characters. table_owner is an optional qualifier for the table name, representing the table owner. Data server operations may fail if actual table owners do not correspond to what you specify in the replication definition.
table_param – The table-level parameter that affects a table you specify with for replicate table name.
Valid values: dsi_compile_enable and dsi_command_convert. See Parameters Affecting Database Connections for descriptions.
function_class – The function-string class to use with the data server. See "Function String Variable Modifiers" for a list of function classes that Replication Server provides for database connections.
error_class – The error class that handles database errors. See "Error and Function Classes" for a list of error classes that Replication Server provides for database connections.
rs_error_class – The error class that handles Replication Server errors for a database. See "Error and Function Classes" for a list of Replication Server error classes.
passwd – The new password to use with the login name for the database connection. You must specify a password if network-based security is not enabled.
dsi_connector_sec_mech – Specifies the DSI connector security mechanism.
log transfer on – Allows the connection to send transactions from a RepAgent to the Replication Server.
log transfer off – Stops the connection from sending transactions from a primary database RepAgent.
database_param – The parameter that affects database connections from the Replication Server.

value – A character string containing a new value for the option.

If you are using the trace option, the syntax for value takes the form “module, condition,[on|off]”, where:

module – specifies the module type. Valid value is econn.
condition – specifies the trace condition to set.
on or off – specifies the state of the condition that is desired.

Note: The trace parameter in the alter connection command allows an empty string. For example:

alter connection to data_server.database 
set trace to ''

An empty string disables ExpressConnect tracing values after the connection or when the Replication Server is restarted.

Parameters Affecting Database Connections
`database_param`	Description and `value`
async_parser	Enables Replication Server to asynchronously parse commands from the RepAgent. Setting async_parser on sets: exec_prs_num_threads to 2 ascii_pack_ibq on cmd_direct_replicate on dist_cmd_direct_replicate on Default: off Note: Before configuring the asynchronous parser, ensure that smp_enable is on, and that the Replication Server host machine can support additional threads for the parsing. You must set the Replication Server site version to 1571 or later before you can set ascii_pack_ibq on. If the site version is earlier than 1571, setting async_parser on only sets exec_prs_num_threads, cmd_direct_replicate, and dist_cmd_direct_replicate.
ascii_pack_ibq	Reduces the stable queue space consumed by packed commands in the inbound queue by using ASCII packing. Default: off Note: You must enable the asynchronous parser for Replication Server to benefit from ASCII packing in the inbound queue. You must set the Replication Server site version to 1571 or later before you set ascii_pack_ibq on.
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. Default: on
batch_begin	Indicates whether a begin transaction can be sent in the same batch as other commands (such as insert, delete, and so on). Default: on
cmd_direct_replicate	Set cmd_direct_replicate on for the Executor thread to send parsed data directly to the Distributor thread along with binary or ascii data. When required, the Distributor thread can retrieve and process data directly from parsed data, and improve replication performance by saving time otherwise spent parsing data again. Default: off
dist_cmd_direct_replicate	Set dist_cmd_direct_replicate on to allow the DIST module to send internal parsed data through an in-memory cache to the DSI. Default: on If you set dist_cmd_direct_replicate off, DIST module sends the data to DSI through the outbound queue.
command_retry	The number of times to retry a failed transaction. The value must be greater than or equal to 0. Default: 3
db_packet_size	The maximum size of a network packet. During database communication, the network packet value must be within the range accepted by the database. Default: 512-byte network packet for all Adaptive Server databases Maximum: 16,384 bytes
deferred_name_resolution	Enable deferred name resolution in Replication Server to support deferred name resolution in Adaptive Server. Deferred name resolution is only supported in Adaptive Server 15.5 and later. You must ensure that deferred name resolution is supported in the replicate Adaptive Server before you enable deferred name resolution support in Replication Server. After you execute deferred_name_resolution with alter connection or alter logical connection, suspend and resume the connection. Default: off
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. Default: off
dist_sqt_max_cache_size	The maximum Stable Queue Transaction (SQT) cache size for the inbound queue. The default, 0, means the current setting of the sqt_max_cache_size parameter is used as the maximum cache size for the connection. Default: 0 For 32-bit Replication Server: Minimum – 0 Maximum – 2147483647 For 64-bit Replication Server: Minimum – 0 Maximum – 2251799813685247
dist_stop_unsupported_cmd	When dist_stop_unsupported_cmd is on, DIST suspends itself if a command is not supported by downstream Replication Server. If it is 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. Default: off
dsi_alt_writetext	Controls how large-object updates are sent to the replicate database. The values are: dcany – generates a writetext command that includes primary key columns. This setting prevents full table scans when populating non-ASE replicate databases using Enterprise Connect Data Access (ECDA) as an interface. off – generates an Adaptive Server writetext command that includes a text pointer. Default: off Note: If you are using ExpressConnect to connect non-ASE replicate databases, then you are not required to configure the dsi_alt_writetext database parameter.
dsi_bulk_copy	Turns the bulk-copy-in feature on or off for a connection. If dynamic_sql and dsi_bulk_copy are both on, Replication Server applies bulk-copy-in when appropriate and uses dynamic SQL if Replication Server cannot use bulk-copy-in. Turn dsi_bulk_copy on to improve performance if you have large batches of inserts. Default: off Note: You must set dsi_bulk_copy to off before you enable real-time loading (RTL) replication to Sybase IQ.
dsi_bulk_threshold	The number of consecutive insert commands in a transaction 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. Replication Server uses dsi_bulk_threshold for real-time loading (RTL) replication to Sybase IQ and high volume adaptive replication (HVAR) to Adaptive Server. If the number of commands for an insert, delete, or update operation on one table is less than the number you specify after compilation, RTL and HVAR use language instead of bulk interface. Minimum: 1 Note: Do not set to ‘1’ when you enable RTL or HVAR as this detrimental to performance. Default: 20 Configuration level: Server, database For setting, use configure replication server for server-level or alter connection for database-level. Note: You must set dsi_compile_enable to ‘on’ to use dsi_bulk_threshold for RTL or HVAR.
dsi_cdb_max_size	Maximum net-change database size that Replication Server can generate for HVAR or RTL. in megabytes. Default – 1024 Minimum – 0 Maximum – 2,147,483,647 In HVAR, Replication Server uses dsi_cdb_max_size as a threshold to: Detect large transactions that are replicated using the continuous replication mode. Stop grouping small compilable transactions into a group requiring a net-change database that is larger than dsi_cdb_max_size. In RTL, Replication Server uses dsi_cdb_max_size to flush large transaction groups incrementally using full incremental compilation.
dsi_charset_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. The values are: on – convert from the primary Replication Server character set to the replicate Replication Server character set; if character sets are incompatible, shut down the DSI with an error. allow – convert where character sets are compatible; apply any unconverted updates to the database, as well. off – do not attempt conversion. This option is useful if you have different but compatible character sets and do not want any conversion to take place. During subscription materialization, a setting of “off” behaves as if it were “allow.” Default: on
dsi_cmd_batch_size	The maximum number of bytes that Replication Server places into a command batch. Default: 8192 bytes
dsi_cmd_prefetch	Allows DSI to pre-build the next batch of commands while waiting for the response from data server, and therefore improves DSI efficiency. If you also tune your data server to enhance performance, it is likely that you will gain an additional performance increase when you use this feature. Default: off When you set dsi_compile_enable to ‘on’, Replication Server ignores what you set for dsi_cmd_prefetch. License: Separately licensed under the Advanced Services Option. See Replication Server Administration Volume 2 > Performance Tuning > Replication Server – Advanced Services Option .
dsi_cmd_separator	The character that separates commands in a command batch. Default: newline (\n) Note: You must update this parameter in an interactive mode, not by executing a DDL-generated script, or any other script. You cannot reset dsi_cmd_separator by running a script.
dsi_command_convert	Specifies how to convert a replicate command. A combination of these operations specifies the type of conversion: d – delete i – insert u – update t – truncate none – no operation Combinations of operations for dsi_command_convert include i2none, u2none, d2none, i2di, t2none, and u2di. You must type the number 2. The operation before conversion precedes the 2 and the operations after conversion are after the 2. For example: d2none – do not replicate the delete command. i2di,u2di – convert both insert and update to delete followed by insert, which is equivalent to an autocorrection. t2none – do not replicate truncate table command. Default: none You can also configure this parameter at the table level. For setting, use alter connection for database-level, or alter connection with the for replicate table named clause for table-level configuration. Set dsi_command_convert to none to remove the current dsi_command_convert setting for a connection or a table.
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. Used with parallel DSI. Default: 1000ms (1 second) Minimum: 0 Maximum: 86,400,000 ms (24 hours)
dsi_commit_check_locks_log	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. Default: 200 Minimum: 1 Maximum: 1,000,000
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: 400 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: on
dsi_compile _enable	Set to ‘on’ to enable RTL or HVAR at the server-level, database-level, or table-level. Default: off – server and database-level. Replication Server uses continuous log order row by row change replication. on – table-level For setting, use configure replication server for server-level, alter connection for database-level, or alter connection with the for replicate table named clause for table-level configuration. Set dsi_compile_enable to ‘off’ for an affected table if replicating new row changes causes problems, such as when there is a trigger on the table which requires all the operations on that table to be replicated in log order, and therefore compilation is not allowed. Note: Set dsi_compile _enable to ‘on’ at the server or database-level before you set dsi_compile_enable to ‘off’ at the table-level. When you set dsi_compile_enable to ‘on’, Replication Server ignores what you set for replicate_minimal_columns and dsi_cmd_prefetch. After you execute dsi_compile_enable at the server, database, or table-level, suspend and resume the connection. License: Separately licensed under the Advanced Services Option. See the Replication Server Administration Guide Volume 2 > Performance Tuning > Advanced Services Option.
dsi_compile_max_cmds	Specifies, in number of commands, the maximum size of a group of transactions. When HVAR or RTL reaches the maximum group size for the current group that it is compiling, HVAR or RTL starts a new group. However, if there is no more data to read and even if the group does not reach the maximum number of commands, HVAR or RTL immediately applies the group in its current state to the replicate database. HVAR or RTL do not wait for more data to arrive in order to build the group size up to the limit you set. In RTL, Replication Server uses dsi_compile_max_commands with dsi_cdb_max_size to trigger the flushing of groups incrementally in full incremental compilation. In HVAR, Replication Server uses dsi_compile_max_commands with dsi_cdb_max_size to detect large transactions that are then replicated using the continuous replication mode. Default: 10,000 Minimum: 100 You can configure the parameter at the server or database levels For setting, use configure replication server for server-level or alter connection for database-level. Note: You must set dsi_compile_enable to ‘on’ to use dsi_compile_max_cmds.
dsi_compile_retry_threshold	Specifies a threshold value for the number of commands in a group of transactions being compiled for HVAR or RTL during the retry phase. If the number of commands in a group containing failed transactions is: Smaller than the value of dsi_compile_retry_threshold, Replication Server retries processing the group in continuous replication mode. Greater than the value of dsi_compile_retry_threshold, Replication Server retries processing the group using HVAR which may then require more retries to identify the failed transactions. Default: 100 Minimum: 0 Maximum: 2,147,483,647
dsi_connector_sec_mech	Specifies the DSI connector security mechanism. Default: default. Valid values: Depends on the connector. ExpressConnect for HANA DB uses this parameter to adjust the security mechanism used to connect to the replicate data server. Replication Server passes this parameter to the connector without validation. For a list of valid values, see the documentation for ExpressConnect for HANA DB.
dsi_connector_type	Specifies the database driver technology used for implementing the connector. This parameter along with dsi_dataserver_make is used to identify the connector that is associated with the connection. If you are replicating to ASE or IQ, set this parameter value to `ctlib` or if replicating to Oracle, set the value to `oci`. Default: default. Valid values: cli, ctlib, jdbc, msnative, oci, odbc.
dsi_dataserver_make	Specifies the data server type that contains the replicate database that you want to connect to. Set to: ase – to replicate to Adaptive Server ase – to replicate to IBM DB2 on z/OS hdb – to replicate to HANA iq – to replicate to Sybase IQ ase – to replicate to Microsoft SQL Server ora – to replicate to Oracle udb – to replicate to IBM UDB Use dsi_dataserver_make and dsi_connector_type to identify the connector that is associated with the connection. You can configure dsi_dataserver_make at the database level. If you do not specify this parameter, Replication Server deduces the data server type from the function-string class name of the database connection. If the functions-string class is customized, Replication Server cannot deduce the data server type and defaults to ‘ASE’.
dsi_do_decompression	Specifies whether or not to decompress LOB data. Set to: on – to decompress LOB data off – (default) to not decompress LOB data In the rs_ase_to_hanadb, rs_ase_to_iq, rs_ase_to_msss, rs_ase_to_oracle, and rs_ase_to_udb, connection profiles, dsi_do_decompression is set to on so that non-ASE replicate data servers can handle compressed LOB data sent from ASE.
dsi_exec_request_sproc	Turns on or off request stored procedures at the DSI of the primary Replication Server. Default: on
dsi_fadeout_time	The number of seconds of idle time before a DSI connection is closed. A value of “-1” indicates that a connection will not close. Default: 600 seconds
dsi_incremental_parsing	Set to on to enable incremental parsing by the DSI Scheduler thread when you enable high volume adaptive replication (HVAR), real-time loading (RTL), or DSI bulk copy-in. Note: dsi_incremental_parsing takes effect only if either dsi_compile_enable or dsi_bulk_copy is also set to on. Otherwise, Replication Server ignores dsi_incremental_parsing. Default: on The primary and replicate Replication Servers must be version 15.7.1 SP100 or later to support incremental parsing. Use dsi_incremental_parsing with: alter connection and create connection – to enable incremental parsing at the connection level for the specified database. Any change to the parameter setting takes effect immediately. configure replication server – to enable incremental parsing at the server level for all connections. You must suspend and resume connections for any change to the parameter to take effect. Connection-level settings override server-level settings. In the Replication Server Administration Guide Volume 2, see: Incremental Parsing High Volume Adaptive Replication to Adaptive Server DSI Bulk Copy-in See Real-Time Loading Solution in the Replication Server Heterogeneous Guide
dsi_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. Values are “on” and “off.” Default: on
dsi_isolation_level	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. Note: Data 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.
dsi_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. Default: on (except standby databases)
dsi_large_xact_size	The number of commands allowed in a transaction before the transaction is considered to be large. Default: 100 Minimum: 4 Maximum: 2,147,483,647 Replication Server ignores dsi_large_xact_size when you turn on dsi_compile_enable.
dsi_max_cmds_in_batch	Defines the maximum number of source commands whose output commands can be batched. You must suspend and resume the connection for any change in the parameter to take effect. Range: 1 – 1000 Default: 100
dsi_max_cmds_to_log	The number of commands to write into the exceptions log for a transaction. Default: -1 (all commands) Valid values: 0 to 2147483647
dsi_max_xacts_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 – 1000. Default: 20 This parameter is ignored when dsi_compile_enable is turned on.
dsi_max_text_to_log	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,` `unitext, image` or `rawobject` columns from filling the RSSD or its log. Default: -1 (all `text`, `unitext`, `image`, or `rawobject` columns)
dsi_non_blocking_commit	The number of minutes that Replication Server saves a message after a commit. A 0 value means that non-blocking commit is disabled. Note: You cannot use this parameter with alter connection to configure an active database connection in a standby environment. Default: 0 Maximum: 60
dsi_num_large_xact_threads	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. Default: 0
dsi_num_threads	The number of parallel DSI threads to be used. The maximum value is 255. Default: 1
dsi_partitioning_rule	Specifies the partitioning rules (one or more) the DSI uses to partition transactions among available parallel DSI threads. Values are origin, origin_sessid, time, user, name, and none. See Replication Server Administration Guide Volume 2 > Performance Tuning > Use Parallel DSI Threads > Partitioning Rules: Reducing Contention and Increasing Parallelism for detailed information. Default: none This parameter is ignored when dsi_compile_enable is turned on.
dsi_proc_as_rpc	Specifies how Replication Server applies stored procedure replication. Set on to use remote procedure call (RPC) calls. Set off to use language calls. Default: off When the replicate database is Adaptive Server , dsi_proc_as_rpc can be on or off. When the replicate database is Oracle: Set on if you use ExpressConnect for Oracle (ECO). ECO only supports stored procedure replication using RPC. By default, Replication Server sets dsi_proc_as_rpc on if you use one of the Oracle ECO connection profiles when you create the connection to the Oracle database from Replication Server. See Replication Server Options 15.5 > ExpressConnect for Oracle 15.5 Installation and Configuration Guide 15.5 > Configuring ExpressConnect for Oracle.
dsi_quoted_identifier	Enables or disables quoted identifier support in the Data Server Interface (DSI). on – enables quoted identifiers if you mark the table as quoted in a replication definition or if the LTL that is sent by RepAgent from Adaptive Server 15.7 marks the table as quoted off – disable quoted identifier support always – always surrounds identifiers with double quotes, regardless of primary database configuration or replication definition setting. You can use the always option for a specific table or for all tables. Default: off If you set dsi_quoted_identifier to on for an Adaptive Server database connection , you must not include double quotes in any stored procedure you want to replicate. Otherwise, the DSI thread shuts down. Enable this parameter to: Create or modify a connection that allows quoted identifiers to be forwarded to data servers. Use create connection or alter connection to set dsi_quoted_identifier. Use admin config to check the value of dsi_quoted_identifier. Support marking of identifiers in a replication definition as quoted. Quoted identifiers are not supported in mixed version environments. For replication of a quoted identifier to succeed, the primary Replication Server and the Replication Server that connects to the replicate data server version must be 15.2 and later. However, intermediate Replication Servers in a route can be of lower versions.
dsi_replication	Specifies whether or not transactions applied by the DSI are marked in the transaction log as being replicated. When dsi_replication is set to “off,” the DSI executes set replication off in the Adaptive Server database, preventing Adaptive Server from adding replication information to log records for transactions that the DSI executes. Since these transactions are executed by the maintenance user and, therefore, not usually replicated further (except if there is a standby database), setting this parameter to “off” avoids writing unnecessary information into the transaction log. dsi_replication must be set to “on” for the active database in a warm standby application for a replicate database, and for applications that use the replicated consolidated replicate application model. Default: on (“off” for standby database in a warm standby application)
dsi_replication_ddl	Supports bidirectional replication by specifying whether or not transactions are to be replicated back to the original database. When dsi_replication_ddl is 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. Default: off
dsi_retry	Specifies whether or not to suspend replication after failing to continue replication using the HVAR, RTL, dynamic SQL, DSI bulk copy-in, parallel DSI, or continuous log-order language replication modes . Set dsi_retry to: 0 – the default setting where Replication Server retries applying transactions and then automatically switches to the continuous language replication mode when HVAR, RTL, parallel DSI, dynamic SQL or DSI bulk copy-in fails to apply transactions 1 – to stop replication when: HVAR or RTL fail to apply compilable transactions Parallel DSI, dynamic SQL, DSI bulk copy-in, or the continuous log-order language modes fail to apply transactions 2 – to stop replication when: The number of commands in a group containing failed transactions is smaller than the value of dsi_compile_retry_threshold and HVAR or RTL fail to apply compilable transactions Parallel DSI, dynamic SQL, DSI bulk copy-in, parallel DSI, or continuous log-order language modes fail to apply transactions Use dsi_retry with: alter connection and create connection – to suspend replication at the connection level for the specified database configure replication server – to suspend replication at the server level for all connections create alternate connection – to suspend replication for the specified replication path in a multipath environment Connection-level settings override server-level settings. See See Parallel DSI Threads, DSI Bulk Copy-in, Dynamic SQL for Enhanced Replication Server Performance, High Volume Adaptive Replication to Adaptive Server, and Enhanced Retry Mechanism in the Replication Server Administration Guide Volume 2 See Real-Time Loading Solution and Enhanced Retry Mechanism in the Replication Server Heterogeneous Guide
dsi_row_count_validation	If you have table rows that are not synchronized, and you want to bypass the default error actions and messages, you can set dsi_row_count_validation to off to disable row count validation. Default: on to enable row count validation. You need not suspend and resume a database connection when you set dsi_row_count_validation for the connection; the parameter takes effect immediately. However, the new setting affects the batch of replicated objects that Replication Server processes after you execute the command. Changing the setting does not affect the batch of replicated objects that Replication Server is currently processing.
dsi_rs_ticket_report	Determines whether to call function string rs_ticket_report or not. rs_ticket_report function string is invoked when dsi_rs_ticket_report is set to on. Default: on
dsi_serialization_method	Specifies the method used to determine when a transaction can start, while still maintaining consistency. In all cases, commit order is preserved. These methods are ordered from most to least amount of parallelism. Greater parallelism can lead to more contention between parallel transactions as they are applied to the replicate database. To reduce contention, use the dsi_partition_rule option. no_wait – specifies that a transaction can start as soon as it is ready—without regard to the state of other transactions. wait_for_start – specifies that a transaction can start as soon as the transaction scheduled to commit immediately before it has started. wait_for_commit – specifies that a transaction cannot start until the transaction scheduled to commit immediately preceding it is ready to commit. wait_after_commit – specifies that a transaction cannot start until the transaction scheduled to commit immediately preceding it has committed completely. Note: You can only set dsi_serialization_method to no_wait if dsi_commit_control is set to “on”. These options are retained only for backward compatibility with older versions of Replication Server: none – same as wait_for_start. single_transaction_per_origin – same as wait_for_start with dsi_partitioning_rule set to origin. Note: The isolation_level_3 value is no longer supported as a serialization method but it is the same as setting dsi_serialization_method to wait_for_start and dsi_isolation_level to 3. Default: wait_for_commit
dsi_sqt_max_cache_size	Maximum SQT (Stable Queue Transaction interface) cache size for the outbound queue, 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. Default: 0 For 32-bit Replication Server: Minimum – 0 Maximum – 2GB (2,147,483,648 bytes) For 64-bit Replication Server: Minimum – 0 Maximum – 2 petabytes (2,251,799,813,685,247 bytes)
dsi_stage_all_ops	Prevents compilation for specified tables when you configure Replication Server and Sybase IQ InfoPrimer integration. . If table history must be preserved, as in the case of slowly changing dimension (SCD) tables, set dsi_stage_all_ops to on. See Replication Server Heterogeneous Replication Guide > Sybase IQ as Replicate Data Server > Replication Server and Sybase IQ InfoPrimer Integration > Parameters > dsi_stage_all_ops.
dsi_text_convert_multiplier	Changes the length of `text` or `unitext` datatype columns at the replicate site. Use dsi_text_convert_multiplier when `text` or `unitext` datatype columns must expand or contract due to character set conversion. Replication Server multiplies the length of primary `text` or `unitext` data by the value of dsi_text_convert_multiplier to determine the length of `text` or `unitext` data at the replicate site. Its type is `float`. If the character set conversion involves expanding `text` or `unitext` datatype columns, set dsi_text_convert_multiplier equal to or greater than 1.0. If the character set conversion involves contracting `text` or `unitext` datatype columns, set dsi_text_convert_multiplier equal to or less than 1.0. Default: 1
dsi_timer	Use the dsi_timer configuration parameter to specify a delay between the time transactions commit at the primary database and the time transactions commit at the standby or replicate database. Replication Server processes transactions in the outbound queue in commit order after the period of delay is over. After you execute dsi_timer with alter connection or alter logical connection, suspend and resume the connection. Specify the delay in the hh:mm format. Maximum: 24 hours. Default: 00:00, which means there is no delay. Note: Replication Server does not support time zone differences between the RepAgent or Replication Agent at the primary database and the Replication Server with the DSI connection where you want to execute dsi_timer.
dsi_top1_enable	For Adaptive Server databases, set dsi_top1_enable to on to enable replication of tables that do not have unique keys. If a table does not have a unique key, it is possible that there are two or more rows with the same values. However, DSI shuts down if it cannot find a unique row to apply an operation. The dsi_top1_enable parameter instructs DSI to select and update only the first instance of multiple similar rows by setting `unsigned_integer` to 1 in the top `unsigned_integer` clause of the Adaptive Server select statement. Default: off Use configure replication server to set the parameter for all replicate connections. Do not use configure replication server to set dsi_top1_enable to on if there are connections to non-Adaptive Server replicate databases. Instead, use alter connection to set the parameter individually for each Adaptive Server replicate database connection. Replication Server does not support replication of a table without unique keys if: There is a customized function string for the table. There is a table replication definition for the table. Transactions use updates and deletes with the like option in the where clause at the primary database. The replicate database is not Adaptive Server.
dsi_xact_group_size	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. Sybase recommends that you set dsi_xact_group_size to the maximum value and use dsi_max_xacts_in_group to control the number of transactions in a group. Note: Obsolete for Replication Server version 15.0 and later. Retained for compatibility with older Replication Servers. Maximum: 2,147,483,647 Default: 65,536 bytes This parameter is ignored when dsi_compile_enable is turned on.
dump_load	Set to “on” at replicate sites only to enable coordinated dump. See the Replication Server Administration Guide Volume 2 for details. Default: off
dynamic_sql	Turns dynamic SQL feature on or off for a connection. Other dynamic SQL related configuration parameters will take effect only if this parameter is set to on. Note: 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. Default: off Note: You must set dynamic_sql to off before you enable real-time loading (RTL) replication to Sybase IQ.
dynamic_sql_cache_management	Manages the dynamic SQL cache for a connection. Values: mru – 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. Default: fixed
dynamic_sql_cache_size	Allows Replication Server to estimate how many database objects can use dynamic SQL for a connection. You can use dynamic_sql_cache_size to limit resource demand on a data server. Default: 100 Minimum: 1 Maximum: 65,535
exec_cmds_per_timeslice	Specifies the number of LTL commands an LTI or RepAgent executor thread can process before yielding the CPU. By increasing this value, you allow the RepAgent executor thread to control CPU resources for longer periods of time, which may improve throughput from RepAgent to Replication Server. Set this parameter at the connection level using alter connection. See the Replication Server Administration Guide Volume 2 > Performance Tuning > Controlling the Number of Commands the RepAgent Executor Can Process. Default: 2,147,483,647 Minimum: 1 Maximum: 2,147,483,647
exec_max_cache_size	Specifies the amount of memory to allocate for the Executor command cache. Default: 1,048,576 bytes for 32-bit and 64-bit Replication Servers. For 32-bit Replication Server: Minimum – 0 Maximum – 2,147,483,647 bytes For 64-bit Replication Server: Minimum – 0 Maximum – 2,251,799,813,685,247 bytes For setting, use configure replication server for all database connections to Replication Server or alter connection for a specific database connection. See Replication Server Administration Guide Volume 2 > Performance Tuning > Suggestions for Using Tuning Parameters > Executor Command Cache.
exec_nrm_request_limit	Specifies the amount of memory available for messages from a primary database waiting to be normalized. Set nrm_thread to ‘on’ with configure replication server before you use exec_nrm_request_limit. Minimum: 16,384 bytes Maximum: 2,147,483,647 bytes Default for: 32-bit – 1,048,576 bytes (1MB) 64-bit – 8,388,608 bytes (8MB) After you change the configuration for exec_nrm_request_limit, suspend and resume the Replication Agent. License: Separately licensed under the Advanced Services Option. See the Replication Server Administration Guide Volume 2 > Performance Tuning > Replication Server – Advanced Services Option.
exec_prs_num_threads	Enables asynchronous parsing feature by starting multiple parser threads for a specific connection from the primary database, and specifies the number of asynchronous parser threads for the connection. Default: 0 (disables asynchronous parser) Minimum: 0 Maximum: 20 Note: Before configuring the asynchronous parser, ensure that smp_enable is on, and that the Replication Server host machine can support additional threads for the parsing.
exec_sqm_write_request_limit	Specifies the amount of memory available for messages waiting to be written to an inbound queue. Default: 1MB Minimum: 16KB Maximum: 2GB
md_sqm_write_request_limit	Specifies the amount of memory available to the Distributor for messages waiting to be written to the outbound queue. Note: In Replication Server 12.1, md_sqm_write_request_limit replaces md_source_memory_pool. md_source_memory_pool is retained for compatibility with older Replication Servers. Default: 1MB Minimum: 16KB Maximum: 2GB
parallel_dsi	Provides a shorthand method for configuring parallel DSI threads. Setting parallel_dsi to on automatically sets: 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 on 32-bit platforms and 20 million bytes on 64-bit platforms. Setting parallel_dsi to off resets these parallel DSI parameters to their default values. You can set parallel_dsi to on and then set individual parallel DSI configuration parameters to fine-tune your replication performance. Default: off
rep_as_standby	When the database is marked with sp_reptostandby and rep_as_standby is on, tables with a table replication definition not covered by a database replication definition are replicated. To replicate the tables, set: rep_as_standby to on send maint xacts to replicate to false send warm standby xacts to true Default: off
replicate_minimal_columns	Specifies whether Replication Server should send all replication definition columns for all transactions, or only those needed to perform update or delete operations at the replicate database. Values are On and Off. Replication Server uses this connection-level parameter when a replication definition does not contain the replicate minimal columns clause, or if there is no replication definition at all. Note: If your replication definition has replicate all columns and the replicate_minimal_columns connection property is set to ‘on’, the connection replicates minimal columns. If you want to replicate all columns to your target database, even if there is no change to the column values for the row, set replicate_minimal_ columns values for the DSI connection to “off”. You can use admin config to display replicate_minimal_columns configuration information. When you set dsi_compile_enable to ‘on’, Replication Server ignores what you set for replicate_minimal_columns. See the Replication Server Administration Guide Volume 2 > Performance Tuning > Using replicate_minimal_columns with Dynamic SQL .
save_interval	The number of minutes that the Replication Server saves messages after they have been successfully passed to the destination data server. See the Replication Server Administration Guide Volume 2 for details. Default: 0 minutes
sqm_cmd_cache_size	The maximum size, in bytes, of parsed data that Replication Server can store in the SQM command cache. 32-bit Replication Server: Default – 1,048,576 Minimum – 0, which disables SQM command caching Maximum – 2,147,483,647 64-bit Replication Server: Default – 20,971,520 Minimum – 0 Maximum – 2,251,799,813,685,247 Replication Server ignores any value you set for sqm_cmd_cache_size if cmd_direct_replicate or sqm_cache_enable is off. Use configure replication server to set the parameter at the server level for all connections, or use alter connection at the database level for individual connections.
sqm_max_cmd_in_block	Specifies, in each SQM block, the maximum number of entries with which the parsed data can associate. Default: 320 Minimum: 0 Maximum: 4096 Set the value of sqm_max_cmd_in_block to the number of entries in the SQM block. Depending on the data profile, each block has a different number of entries because the block size is fixed, and the message size is unpredictable. If you set a value that is too large, there is memory waste. If you set a value that is too small, replication performance is compromised. Replication Server ignores any value you set for sqm_max_cmd_in_block if cmd_direct_replicate or sqm_cache_enable is off.
sqt_max_prs_size	Maximum memory, in bytes consumed by commands unpacked by the transaction profiling processes for HVAR and RTL. For 32-bit Replication Server: Default – 2,147,483,647 (2GB) Minimum – 0 Maximum – 2,147,483,647 For 64-bit Replication Server: Default – 2,147,483,647 (2GB) Minimum – 0 Maximum – 2,251,799,813,685,247 Use configure replication server to set the parameter at the server level for all connections, or use alter connection at the database level for individual connections. The default value at the database level is 0. If you retain the database-level default or reset to the default, Replication Server uses the value set at the server level. After you upgrade to Replication Server 15.7.1 SP100 and later, you must set the default to 2GB for both 32-bit and 64-bit Replication Server.
stage_operations	Set to on for Replication Server to write operations to staging tables for the specified connection when you configure Replication Server and Sybase IQ InfoPrimer integration. See Replication Server Heterogeneous Replication Guide > Sybase IQ as Replicate Data Server > Replication Server and Sybase IQ InfoPrimer Integration > Parameters > stage_operations.
sub_sqm_write_request_limit	Specifies the memory available to the subscription materialization or dematerialization thread for messages waiting to be written to the outbound queue. Default: 1MB Minimum: 16KB Maximum: 2GB
unicode_format	Supports sending unicode data in `U&”` format. Set unicode_format to one of these values: `string` – unicode characters are converted to character string format. For example, the `string` “hello” is sent out as “hello”. `ase` – unicode characters are sent out in `U&’’` format. For example, the `string` “hello” is sent out as “U&'\0068\0065\006c\006c\006f’ ”. The two-byte unicode value is sent in network order as required by Adaptive Server Enterprise. Default: `string`
use_batch_markers	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. Default: off

security_param – A parameter that affects network-based security for connections. See "Parameters affecting network-based security" table in create route for a list of parameters and a description of values. This parameter does not apply to non-ASE, non-IQ connectors.
set security_services to 'default' – Resets all network-based security features for the connection to match the global settings of your Replication Server. This parameter does not apply to non-ASE, non-IQ connectors.
new_ds and new_db – Name of the new data server and database for the connection.
Note: The new_ds and new_db parameters can have the same values that you have defined for data_server and database parameters.
trace – Allows ExpressConnect tracing at the DSI level.
value – A character string containing a new value for the option.
If you are using the trace option, the syntax for value takes the form “module, condition,[on|off]”, where:
- module – Specifies the module type. Valid value is econn.
- condition – Specifies if a trace option is set to on or off.
- on or off – Specifies the state of the condition that is desired.
Note: The trace parameter in the alter connection command allows empty string. For example:
```
alter connection to data_server.database 
set trace to ''
```
An empty string disables ExpressConnect tracing values after the connection or when the Replication Server is restarted.

Examples

Example 1 – Changes the function-string class for the pubs2 database in the TOKYO_DS data server to sql_derived_class:

suspend connection to TOKYO_DS.pubs2
 
alter connection to TOKYO_DS.pubs2b
set function string class to sql_derived_class
 
resume connection to TOKYO_DS.pubs2

Example 2 – Changes the number of LTL commands the LTI or RepAgent Executor thread can process before it must yield the CPU to other threads:

suspend connection to TOKYO_DS.pubs2
alter connection to TOKYO_DS.pubs2b
set exec_cmds_per_timeslice to ’10’
resume connection to TOKYO_DS.pubs2

Usage

Use suspend connection to suspend activity on the connection before altering it.
Execute alter connection at the Replication Server where the connection was created.
Before you use log transfer off to stop data transfer from a primary database, be sure there are no replication definitions defined for data in the database.
To change the route to a Replication Server, use alter route.
Use set function string class [to] function_class to activate class-level translations for non-Sybase data servers.
You can set connection parameters for the default or alternate connections using the alter connection parameter.

Any value you set for an alternate connection overrides inherited values from the default connection or the default values.
Execute alter connection at the Replication Server where the connection was created.

Database connection parameters

Use alter connection to change the configuration parameters of a DSI or a database connection. To change a DSI configuration value, suspend the connection to the DSI, change the value, and then resume the connection to the DSI. This procedure causes the new value to take effect.
Replication Server configuration parameters are stored in the rs_config system table. Some parameters can be modified by updating rows in the table. See the Replication Server Administration Guide Volume 1 for more information.
See the Replication Server Administration Guide Volume 2 for more information about configuring parallel DSI threads.
Use assign action to enable retry of transactions that fail due to specific data server errors.
Before you change the function-string class, make sure that the class and all the required function strings exist for the new class.
Before you change the error class, make sure the new class exists.
Change the character for data servers that require a command separator to recognize the end of a command.
If you have specified a different separator character and want to change it back to a newline character, enter the alter connection command as follows:
```
alter connection to data_server.database 
  set  to '<Return>'
```
where you press the Return key, and no other characters, between the two single-quote characters.

The dsi_bulk_copy parameter

When dsi_bulk_copy is on, SQT counts the number of consecutive insert statements on the same table that a transaction contains. If this number reaches the dsi_bulk_threshold, DSI:

Bulk-copies the data to Adaptive Server until DSI reaches a command that is not insert or that belongs to a different replicate table.
Continues with the rest of the commands in the transaction.

Adaptive Server sends the result of bulk copy-in at the end of the bulk operation, when it is successful, or at the point of failure.

Note: The DSI implementation of bulk copy-in supports multistatement transactions, allowing DSI to perform bulk copy-in even if a transaction contains commands that are not part of the bulk copy.

The dsi_partitioning_rule parameter

You can specify more than one partitioning rule at a time. Separate values with a comma, but no spaces. For example:

alter connection to data_server.database
  set dsi_partitioning_rule to ‘origin,time’

The dataserver and database name parameter

Using dataserver and database name parameter you can switch the connection from using one connector to using another connector. For example, if you replicating to Oracle using the ASE/CT-Lib connector and you want to switch your connection to use the Oracle/OCI connector, you may be required to use a new data server and database name. Because the name given to the DirectConnect/Oracle in the Sybase interfaces file may not be the same as the Oracle data server name in the Oracle TNS Names file. To change:

Suspend the connection.
Alter the connection setting dsi_dataserver_make to ora and dsi_connector_type to oci.
Alter the connection setting dataserver and database name to new_ds and new_db
where:
- new_ds – name of the data server in the Oracle tnsnames.ora file
- new_ds – name of the database
Note: The new_ds and new_db parameters can have the same values that you have defined for data_server and database parameters.
Resume the connection.

The dump_load parameter

Before setting dump_load to “on,” create function strings for the rs_dumpdb and rs_dumptran functions. Replication Server does not generate function strings for these functions in the system-provided classes or in derived classes that inherit from these classes.

The save_interval configuration parameter

Set save_interval to save transactions in the DSI queue that can be used to resynchronize a database after it has been restored from backups. Setting a save interval is also useful when you set up a warm standby of a database that holds replicate data or receives replicated functions. You can use sysadmin restore_dsi_saved_segments to restore backlogged transactions.

Network-based security parameters

These parameters do not apply to non-ASE, non-IQ connectors.
Both ends of a connection must use compatible Security Control Layer (SCL) drivers with the same security mechanisms and security features. The data server must support set proxy or an equivalent command.

It is the replication system administrator’s responsibility to choose and set security features for each server. Replication Server does not query the security features of remote servers before attempting to establish a connection. Connections fail if security features at both ends of the connection are not compatible.
alter connection modifies network-based security settings for an outgoing connection from Replication Server to a target data server. It overrides default security parameters set with configure replication server.
If unified_login is set to “required,” only the replication system administrator with “sa” permission can log in to the Replication Server without a credential. If the security mechanism should fail, the replication system administrator can log in to Replication Server with a password and disable unified_login.
A Replication Server can have more than one security mechanism; each supported mechanism is listed in the libtcl.cfg file under SECURITY.
Message encryption is a costly process with severe performance penalties. In most instances, it may be wise to set msg_confidentiality “required” only for certain connections. Alternatively, choose a less costly security feature, such as msg_integrity.

Using alter connection to change maintenance passwords

You can change the maintenance user password of any DSI connection using the alter connection command:
```
alter connection to data_server.database
set password to password
```
If your Replication Server is using ERSSD and the data_server.database match the ERSSD names, using alter connection and set password updates the rs_maintusers table, issues sp_password at ERSSD, and updates the configuration file line RSSD_maint_pw_enc.

Permissions

alter connection requires “sa” permission.