Changes the attributes of a database connection.
alter connection to <data_server>.<database> { for replicate table named [<table_owner>.]<table_name> set <table_param> [to] ‘<value>’ | for replicate schema named <schema> set <create_table_append_text> [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>' | set schemamap [with decluster {with | without} depool | without decluster] from <data_server>.<db>.{<from_schema> | NULL} to {<to_schema> | NULL} | set sap_trim_len to {'on' | 'off'} | set sapsystemname to '<sid_adm_value>' | set reblock_ddntf to {'on' | 'off'} | set dsi_ddl_create_column_table to {'on' | 'off'}}
The data server that holds the database whose connection is to be altered.
The database whose connection is to be altered.
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.
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.
The function-string class to use with the data server. See Function String Variable Modifiers for a list of function classes that SAP Replication Server provides for database connections.
The error class that handles database errors. See Error and Function Classes for a list of error classes that SAP Replication Server provides for database connections.
The error class that handles SAP Replication Server errors for a database. See Error and Function Classes for a list of SAP Replication Server error classes.
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.
Specifies the DSI connector security mechanism.
Allows the connection to send transactions from a RepAgent to the SAP Replication Server.
Stops the connection from sending transactions from a primary database RepAgent.
Maps primary schema or owner (<from_schema>) to replicate schema or owner (<to_schema>).
During DML or heterogeneous DDL replication, if a replicate database is subscribing to a table replication definition that includes the table owner, the replicate owner of the table replication definition takes effect. A schemamap can take effect only if there is no table subscription for the table or if the table replication definition does include the replicate table owner.
Enables declustering of cluster tables for a schema and maps primary schema or owner (<from_schema>) to replicate schema or owner (<to_schema>).
Enables declustering of cluster tables and depooling of pool tables for a schema and maps primary schema or owner <from_schema> to replicate schema or owner <to_schema>.
Enables declustering of cluster tables and disables depooling of pool tables for a schema and maps primary schema or owner (<from_schema>) to replicate schema or owner (<to_schema>).
Disables declustering of cluster tables and depooling of pool tables for a schema and maps primary schema or owner (<from_schema>) to replicate schema or owner (<to_schema>).
The parameter that affects database connections from the SAP Replication Server.
A character string containing a new value for the option.
alter connection to <data_server.database> set trace to ''
An empty string disables ExpressConnect tracing values after the connection or when the SAP Replication Server is restarted.
<database_param> |
Description and <value> |
---|---|
async_parser | Enables
SAP Replication Server to asynchronously parse commands from the
RepAgent. Setting async_parser on sets:
Default: off Note
Before configuring the asynchronous parser, ensure that smp_enable is on, and that the SAP Replication Server host machine can support additional threads for the parsing. You must set the SAP 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 SAP Replication Server to
benefit from ASCII packing in the inbound queue. You must set the SAP
Replication Server site version to 1571 or later before you set
ascii_pack_ibq on.
|
batch |
Specifies how SAP Replication Server sends commands to data servers. When batch is “on,” SAP Replication Server may send multiple commands to the data server as a single command batch. When batch is “off,” SAP 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. Allowable range: 512 bytes to 2,147,483,647 bytes within the limits for the replicate data server Maximum ASE limit: 16384 bytes Default: 512-byte network packet for all Adaptive Server databases. |
deferred_name_resolution |
Enable deferred name resolution in SAP Replication Server to support deferred name resolution in SAP ASE. Deferred name resolution is only supported in SAP ASE 15.5 and later. You must ensure that deferred name resolution is supported in the replicate SAP ASE before you enable deferred name resolution support in SAP 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 SAP Replication Server:
For 64-bit SAP Replication Server:
|
dist_stop_unsupported_cmd |
When dist_stop_unsupported_cmd is on, DIST suspends itself if a command is not supported by downstream SAP Replication Server. If it is off, DIST ignores the unsupported command. Regardless of dist_stop_unsupported_cmd parameter’s setting, SAP 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 SAP Replication Server. Default: off |
dsi_alt_writetext |
Controls how large-object updates are sent to the replicate database. The
values are:
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, SAP Replication Server applies bulk-copy-in when appropriate and uses dynamic SQL if SAP 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 SAP IQ.
|
dsi_bulk_threshold |
The number of consecutive insert commands in a transaction that, when reached, triggers SAP 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, SAP suggests that you do not configure this value much higher than the configuration value for dsi_large_xact_size. SAP Replication Server uses dsi_bulk_threshold for real-time loading (RTL) replication to SAP 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 SAP Replication Server can generate
for HVAR or RTL. in megabytes.
In HVAR, SAP Replication Server uses dsi_cdb_max_size as
a threshold to:
In RTL, SAP 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 SAP Replication Server and the replicate SAP Replication Server. This parameter applies to all data and identifiers to be applied at the DSI in question. The values are:
Default: on |
dsi_check_unique_key |
Checks for unique key in the primary database tables during direct load materialization. If this parameter is set to on, the primary tables with no unique key must not have any activity, otherwise the subscription may fail during the catch-up phase and the subscription is aborted, and marked with error. When the subscription is aborted, it must be dropped and recreated. Before recreating the subscription, cleaning up the replicate table (like truncate table) is required. Default: on |
dsi_cmd_batch_size |
The maximum number of bytes that SAP 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’, SAP Replication Server ignores what you set for dsi_cmd_prefetch. License: Separately licensed under the Advanced Services Option. See Replication Server – Advanced Services Option in the Administration Volume 2 |
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:
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:
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 SAP 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:
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 Advanced Services Option in the Administration Guide Volume 2. |
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, SAP 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:
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:
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:
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:
In the Replication Server Administration Guide Volume 2, see:
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:
Data servers supporting other isolation levels are supported as well through the use of the rs_set_isolation_level function string. Support is not limited to the ANSI standard only. Replication Server can support any isolation level the replicate data server may use. |
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.
Default: off When the replicate database is Adaptive Server , dsi_proc_as_rpc can be on or off. When the replicate database is Oracle:
|
dsi_quoted_identifier |
Enables or disables quoted identifier support in the Data Server Interface (DSI).
Default: off You can set dsi_quoted_identifier at the table level, connection level, or at the server level. The table-level dsi_quoted_identifier setting takes precedence over any existing connection-level dsi_quoted_identifier setting and the connection-level setting takes precedence over the server-level dsi_quoted_identifier setting. See SAP Replication Server Administration Guide: Volume 1 > Manage Replicated Tables > Create Replication Definitions > Quoted Identifiers. 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:
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. Default: off 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.
Additionally, dsi_replication_ddl controls how SAP
Replication Server applies DDL, select into and request
function commands at the replicate database. When you set
dsi_replication_ddl:
|
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:
Use dsi_retry with:
In
the Troubleshooting Guide, see:
For descriptions of the faster replication modes, see:
|
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.
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:
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:
For 64-bit Replication Server:
|
dsi_stage_all_ops |
Prevents compilation for specified tables when you configure SAP Replication Server and SAP 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 dsi_stage_all_ops in the Heterogeneous Replication Guide. |
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>.
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.
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:
|
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. SAP 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. |
dt_apply |
Controls the maximum number of tasks that SAP Replication Server uses to apply one transaction during high volume adaptive replication (HVAR) to SAP ASE databases. Default: 1 which means there is no distributed application of transactions. Minimum: 1 Maximum: 8 Note The replicate SAP
ASE data server requires a separate license and configuration for
distributed transaction management (DTM) to support distributed application
of transactions from SAP Replication Server.
You can also use configure replication server to set dt_apply at the server level for all connections. Setting dt_apply at the connection level overrides any server-level setting that you set. SeeDistributed Application of Transactions in the DSI Thread in the Administration Guide Volume 2. |
dump_load |
Set to “on” at replicate sites only to enable coordinated dump. See the Loading from Coordinated Dumps in the Administration Guide Volume 2 . 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 SAP IQ.
|
dynamic_sql_cache_management |
Manages the dynamic SQL cache for a connection. Values:
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 |
dsi_log_cmds |
Enables the Replication Server to log the failed/skipped transactions to the repserver log file or an alternative file. If the dsi_log_cmds property is on, the RS will log the failed commands to the repserver log file or an alternative file when the DSI is down or skipping transactions while resuming connection. Default: Off |
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:
For 64-bit Replication Server:
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:
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_dist | Enables parallel processing in the distributor thread (DIST) to improve
replication throughput. Default: off For any change to the parameter
to take effect, you must:
See Parallel Processing in DIST in the Administration Guide Volume 2. |
parallel_dsi |
Provides a shorthand method for configuring parallel DSI threads. Setting parallel_dsi to on
automatically sets:
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 |
reblock_ddntf |
(Only for replication from SAP Business Suite on DB2 UDB database to any supported database) Specifies whether Replication Server should adjust each FIELDS column length in the replicate database to 32768 characters except the last row. Values are 'on' and 'off'. Default is 'on'. |
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:
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 . |
sapsystemname |
(Only for replication from SAP Business Suite) Specifies the environment variable for the SAP system name, that is <sid>. |
sap_trim_len |
(Only for replication from SAP Business Suite on
Oracle database to any supported database) Specifies whether Replication
Server should truncate the first two bytes during replication if:
Values are 'on' and 'off'. Default: 'off' |
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:
64-bit Replication Server:
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:
For 64-bit Replication Server:
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 SAP IQ InfoPrimer integration. See stage_operations in the Heterogeneous Replication Guide . |
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 which removes the limitation of UTF-8 character set in Replication Server. Set unicode_format to one of these values:
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 |
dsi_ddl_create_column_table |
When replicating the create table command and initializing replicate tables during materialization, Replication Server supports the configuration to decide whether to store tables in rows or in columns into the SAP HANA database. Replication Server adds a new configuration parameter dsi_ddl_create_column_table in the replicate Replication Server at the connection level by using the alter connection command. When you set the parameter to on, Replication Server issues the create column table command when sending the create table commands to the replicate database. Default: off Note
|
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.
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.
Name of the new data server and database for the connection.
The <new_ds >and< new_db> parameters can have the same values that you have defined for <data_server >and <database> parameters.
Allows ExpressConnect tracing at the DSI level.
A character string containing a new value for the option.
<module> – Specifies the module type. Valid value is <econn>.
<condition> – Specifies if a trace option is set to <on> or <off>.
alter connection to <data_server>.<database> set trace to ''
Specifies the data server and database containing the primary data.
Maps primary schema or owner (<from_schema>) to replicate schema or owner (<to_schema>).
During DML or heterogeneous DDL replication, if a replicate database is subscribing to a table replication definition that includes the table owner, the replicate owner of the table replication definition takes effect. A schemamap can take effect only if there is no table subscription for the table or if the table replication definition does include the replicate table owner.
Specifies the schema of the primary database, that is, the origin user to be mapped. If <from_schema> is NULL, all the users from the primary connection name are mapped to <to_schema>.
Specifies the schema of the replicate database, that is, the target user to be mapped. If <to_schema> is NULL, all the users from the primary connection name are mapped to <from_schema>.
Enables declustering of cluster tables for a schema.
Disables declustering of cluster tables for a schema.
Mapping relations for <data_server>.<db> are dropped if you specify NULL for both <from_schema> and <to_schema>.
A character string containing a new value for the option.
If you are using the create_table_append_text option, only group_option and location_clause syntax elements are supported to be added as appendix now.
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
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
Alter connection to replicateDS.replicateDB, map user A from primaryDS.primaryDB to user B:
alter connection to replicateDS.replicateDB set schemamap from primaryDS.primaryDB.A to B
Alter connection to replicateDS.replicateDB, map all users from primaryDS.primaryDB to user B:
alter connection to replicateDS.replicateDB set schemamap from primaryDS.PrimaryDB.NULL to B
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-SAP 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.
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
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.
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
alter connection to data_server.database set dsi_partitioning_rule to ‘origin,time’
The dataserver and database name parameter
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
<new_ds> – name of the data server in the Oracle tnsnames.ora file
<new_ds> – name of the database
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>.