Replication Agent configuration parameters

Table 5-1 lists all of the Replication Agent configuration parameters and gives a brief description of each parameter.

Table 5-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.

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_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 1K byte blocks written to log file before wrapping.

lr_update_trunc_point

Number of maintenance user operations skipped before Log Reader requests new LTM Locator.

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_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_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_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_charset

Character set used on connection to primary database.

pds_connection_type

Type of connection to primary database server.

pds_database_name

Name of database replicated from primary database server.

pds_datasource_name

Data source name of database replicated from primary database server.

pds_host_name

Name of primary database server host machine.

pds_password

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

pds_port_number

Port number for primary database server.

pds_retry_count

Number of times to retry connection to primary database server.

pds_retry_timeout

Number of seconds to wait between connection retry attempts.

pds_server_name

Server name of primary database server.

pds_service_name

Name of database gateway service for primary database server.

pds_username

User ID that Replication Agent uses to access primary database 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.

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 database server identified to Replication Server.

rs_username

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

rssd_charset

Character set used in 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

Method(s) of log truncation allowed.

use_rssd

Switches on/off access to RSSD for replication definitions.