Configuration parameter reference

Table 2-1 lists all of the Sybase Replication Agent configuration parameters, with a brief description of each parameter.

Table 2-1: Replication Agent configuration parameters

Parameter name

Description

admin_port

Port number for Replication Agent administrative port.

column_compression

Use minimal column information.

compress_ltl_syntax

Use abbreviated LTL syntax.

connect_to_rs

Enable/disable connection from LTI to Replication Server.

ddl_password

Password for ddl_username. This configuration is available for Oracle only.

ddl_username

The database user name included in LTL for replicating DDL commands to the standby database. This configuration is available for Oracle only.

dump_batch_timeout

Time to send incomplete buffer to Replication Server.

filter_maint_userid

Log Reader filters operations with maintenance user ID.

function_password

Password for user ID passed in LTL with replicated stored procedure invocations.

function_username

User ID passed in LTL with replicated stored procedure invocations.

log_backup_files

Determines the number of log backup files kept in the log directory.

log_directory

Directory where Replication Agent system log file is located.

log_trace_verbose

Switch on/off verbose mode in trace log file.

log_wrap

Number of 1KB blocks written to log file before wrapping.

lr_ntext_byte_order

Specifies which byte order to use when replicating NTEXT data.(For Microsoft SQL Server only)

lti_batch_mode

Switches on/off LTI batch mode.

lti_max_buffer_size

Maximum number of change sets stored in the LTI input buffer.

lti_update_trunc_point

Number of LTL commands sent before LTI requests new LTM Locator.

ltl_batch_size

Size of the LTL batch buffer.

ltl_character_case

Case of database object names sent to Replication Server.

ltl_origin_time_required

Specifies whether to send origin_time command tag in LTL.

ltm_admin_pw

Password for Replication Agent administrative port.

ltm_admin_user

User ID for Replication Agent administrative port.

max_ops_per_scan

Maximum number of operations Log Reader will read in a single log scan.

pdb_archive_path

Identifies the directory path where the Replication Agent expects to find archived Oracle redo log files. This configuration is available for Oracle only.

pdb_archive_remove

Enables or disables the removal of archived Oracle redo log files from the path specified by pdb_archive_path. This configuration is available for Oracle only.

pdb_automark_tables

Determines if the Sybase Replication Agent automatically marks tables for replication during initialization or DDL replication (For Oracle only)

pdb_auto_create_repdefs

If set to true, when tables and procedures are marked for replication, a replication definition is automatically created at Replication Server for that table or procedure. (For Oracle only)

pdb_auto_run_scripts

Automatic execution of SQL scripts used to create/remove transaction log objects and mark/unmark primary database objects.

pdb_convert_datetime

Converts native date/time formats to Sybase datetime format.

pdb_dflt_column_repl

Enables replication for LOB columns by default when table is marked.

pdb_dflt_object_repl

Enables replication by default when object is marked.

pdb_exception_handling

Allows primary database to continue operation if Replication Agent triggers fail.

pdb_include_archives

Enables or disables the use of Oracle archive log files. (For Oracle only)

pdb_support_large_identifier

To support replication of large identifiers up to 255 characters in length with Replication Server 15.0.

pdb_xlog_device

Name of the primary database device.

pdb_xlog_prefix

Character string prefix used to identify transaction log objects.

pdb_xlog_prefix_chars

Non-alphabetic characters allowed in pdb_xlog_prefix.

pds_connection_type

Type of connection to primary data server.

pds_database_name

Name of database replicated from primary data server.

pds_datasource_name

Data source name of database replicated from primary data server.

pds_host_name

Name of primary data server host machine.

pds_integrated_security

Determines if the Sybase Replication Agent should use Windows authentication when connecting to the primary SQL Server. (For Microsoft SQL Server only)

pds_password

Password for user ID Replication Agent uses to access primary data server.

pds_port_number

Port number for primary data server.

pds_retry_count

Number of times to retry connection to primary data server.

pds_retry_timeout

Number of seconds to wait between connection retry attempts.

pds_server_name

Server name of primary data server.

pds_username

User ID that Replication Agent uses to access primary data server.

ra_retry_count

Number of times LTM attempts to get back to Replicating state after a failure.

ra_retry_timeout

Number of seconds to wait between LTM attempts to get back to Replicating state.

rasd_backup_dir

The directory path for Replication Agent System Database (RASD) backup files. This configuration is available for Oracle only.

rasd_database

The directory path for the Replication Agent System Database (RASD) database file. This configuration is available for Oracle only.

rasd_mirror_tran_log

Enables or disables Replication Agent System Database (RASD) transaction log mirroring. This configuration is available for Oracle only.

rasd_trace_log_dir

The directory path for the Replication Agent System Database (RASD) trace log file. This configuration is available for Oracle only.

rasd_tran_log

The directory path for the Replication Agent System Database (RASD) transaction log file. This configuration is available for Oracle only.

rasd_tran_log_mirror

The directory path for the Replication Agent System Database (RASD) transaction log file mirror. This configuration is available for Oracle only.

rs_charset

Character set used to communicate with Replication Server.

rs_host_name

Name of primary Replication Server host machine.

rs_packet_size

Network I/O packet size sent to Replication Server.

rs_password

Password for user ID Replication Agent uses to access Replication Server.

rs_port_number

Port number for primary Replication Server.

rs_retry_count

Number of times to retry connection to primary Replication Server.

rs_retry_timeout

Number of seconds to wait between connection retry attempts.

rs_source_db

Name of primary database identified to Replication Server.

rs_source_ds

Name of primary data server identified to Replication Server.

rs_username

User ID that Replication Agent uses to access primary Replication Server.

rssd_charset

Character set used to communicate with RSSD.

rssd_database_name

Name of RSSD database.

rssd_host_name

Name of RSSD host machine.

rssd_password

Password for user ID Replication Agent uses to access RSSD.

rssd_port_number

Port number for RSSD.

rssd_username

User ID that Replication Agent uses to access RSSD.

scan_sleep_increment

Number of seconds to increase Log Reader wait before next scan after finding no operations to replicate.

scan_sleep_max

Maximum number of seconds for Log Reader to wait before next scan after finding no operations to replicate.

skip_ltl_errors

LTI ignores error messages returned by Replication Server.

structured_tokens

LTI uses structured tokens when generating LTL output.

truncation_interval

Number of minutes to wait between automatic log truncations.

truncation_type

Methods of log truncation allowed.

use_rssd

Switches on/off access to RSSD for replication definitions.

The following sections list all Sybase Replication Agent configuration parameters in alphabetical order.