Configuring and tuning the Mirror Replication Agent

The performance of Mirror Replication Agent can be tuned or optimized by adjusting some of the Mirror Replication Agent configuration parameters.

You can set or change a Mirror Replication Agent configuration parameter with the ra_config command.

Because the Mirror Replication Agent overwrites its entire configuration file whenever ra_config or ra_set_login is invoked, Sybase recommends that you do not edit the configuration file. Also, each Mirror Replication Agent instance reads its configuration file only at start-up. You must use the ra_config command if you want a new configuration parameter value to take effect before the instance is shut down and restarted.

Some configuration parameter changes are recorded in the configuration file when you invoke ra_config, but they do not take effect until the Mirror Replication Agent instance is shut down and restarted.

All Mirror Replication Agent configuration parameters can be changed when the Mirror Replication Agent instance is in Admin state. Some configuration parameters cannot be changed when the instance is in Replicating state.

Table 3-1 lists all Mirror Replication Agent configuration parameters.

**Table 3-1: Mirror Replication Agent configuration parameters**
Parameter name	Target	Description	Default
admin_port	All	Port number on which Mirror Replication Agent listens for incoming user connections.	10000
column_compression	All	Use minimal column information.	true
compress_ltl_syntax	All	Use abbreviated LTL syntax.	true
connect_to_rs	All	Enable/disable connection from LTI to Replication Server.	true
ddl_password	Oracle	Password for user ID passed in LTL with replicated DDL invocations.	<not_configured>
ddl_username	Oracle	User ID passed in LTL with replicated DDL invocations.	<not_configured>
dump_batch_timeout	All	Time to send incomplete buffer to Replication Server.	5
filter_maint_userid	All	Log Reader filters operations with maintenance user ID.	true
function_password	Oracle	Password for user ID passed in LTL with replicated stored procedure invocations.	““ (empty string)
function_username	Oracle	User ID passed in LTL with replicated stored procedure invocations.	sa
log_backup_files	All	Determines the number of log backup files kept in the log directory.	3
log_directory	All	Directory where Mirror Replication Agent system log file is located.	Current directory on the Mirror Replication Agent host machine from which the Mirror Replication Agent instance was started.
log_trace_verbose	All	Switch on/off verbose mode in trace log file.	false
log_wrap	All	Number of 1KB byte blocks written to log file before wrapping.	1000
lti_batch_mode	All	Specifies whether to batch the LTL commands sent to Replication Server.	true
lti_max_buffer_size	All	Maximum number of change sets stored in the LTI input buffer.	5000
lti_update_trunc_point	All	Number of LTL commands sent before LTI requests new LTM Locator.	1000
ltl_batch_size	All	Size of the LTL batch buffer.	40000
ltl_big_endian_unitext	All	Specifies whether "unitext" data should be converted from little endian to big endian before sending LTL to Replication Server.	true
ltl_character_case	All	Case of database object names sent to Replication Server.	asis
ltl_origin_time_required	All	Specifies whether to send origin_time command tag in LTL.	false
ltm_admin_pw	All	Password for Mirror Replication Agent administrative port.	““ (empty string)
ltm_admin_user	All	User ID for Mirror Replication Agent administrative port.	sa
max_ops_per_scan	All	Maximum number of operations Log Reader will read in a single log scan.	1000
pdb_archive_path	Oracle	Identifies the directory path where the Replication Agent expects to find archived Oracle redo log files.	none
pdb_archive_remove	Oracle	Enables or disables the removal of archived Oracle redo log files from the path specified by pdb_archive_path.	false
pdb_automark_tables	All	Automatic marking of user tables when the Replication Agent is initialized.	true
pdb_auto_create_repdefs	All	Automatic creation of Replication Definitions when tables or procs are marked.	true
pdb_auto_run_scripts	Oracle	Automatic execution of SQL scripts used to create/remove transaction log objects and mark/unmark primary database objects.	true
pdb_convert_datetime	Oracle	Converts native date/time formats to Sybase datetime format.	false
pdb_dflt_column_repl	All	Enables replication for LOB columns by default when table is marked.	true
pdb_dflt_object_repl	All	Enables replication by default when object is marked.	true
pdb_include_archives	Oracle	Enables or disables the use of Oracle archive log files.	true
pdb_support_large_identifier	All	To support replication of large identifiers up to 255 characters in length.	true
pdb_timezone_file	Oracle	Specifies the file to read at initialization to obtain Oracle time zone information.	none
pdb_xlog_device	Oracle	Name of the primary database device.	NULL
pdb_xlog_prefix	Oracle	Character string prefix used to identify transaction log objects.	ra_
pdb_xlog_prefix_chars	Oracle	Non-alphabetic characters allowed in pdb_xlog_prefix.	_#$
pds_connection_type	All	Type of connection to primary data server.	For Oracle: ORAJDBC
pds_database_name	All	Name of database replicated from primary data server.	<not_configured>
pds_datasource_name	All	Data source name of database replicated from primary data server.	<not_configured>
pds_host_name	All	Name of primary data server host machine.	<not_configured>
pds_password	All	Password for user ID Mirror Replication Agent uses to access primary data server.	““ (empty string)
pds_port_number	All	Port number for primary data server.	1111
pds_retry_count	All	Number of times to retry connection to primary data server.	5
pds_retry_timeout	All	Number of seconds to wait between connection retry attempts.	10
pds_server_name	All	Server name of primary data server.	<not_configured>
pds_username	All	User ID that Mirror Replication Agent uses to access primary data server.	<not_configured>
ra_retry_count	All	Number of times LTM attempts to get back to Replicating state after a failure.	2
ra_retry_timeout	All	Number of seconds to wait between LTM attempts to get back to Replicating state.	10
rasd_backup_dir	All	The directory path for Replication Agent System Database (RASD) backup files.	<not_configured>
rasd_database	All	The directory path for the Replication Agent System Database (RASD) database file.	<not_configured>
rasd__mirror_tran_log	All	Enables or disables Replication Agent System Database (RASD) transaction log mirroring.	false
rasd_trace_log_dir	All	The directory path for the Replication Agent System Database (RASD) trace log file.	<not_configured>
rasd_tran_log	All	The directory path for the Replication Agent System Database (RASD) transaction log file.	<not_configured>
rasd__tran_log_mirror	All	The directory path for the Replication Agent System Database (RASD) transaction log file mirror.	path to the RASD transaction log file
rs_charset	All	Character set used to communicate with Replication Server.	““ (empty string)
rs_host_name	All	Name of primary Replication Server host machine.	<not_configured>
rs_packet_size	All	Network I/O packet size sent to Replication Server.	2048
rs_password	All	Password for user ID Mirror Replication Agent uses to access Replication Server.	““ (empty string)
rs_port_number	All	Port number for primary Replication Server.	1111
rs_retry_count	All	Number of times to retry connection to primary Replication Server.	5
rs_retry_timeout	All	Number of seconds to wait between connection retry attempts.	10
rs_source_db	All	Name of primary database identified to Replication Server.	<not_configured>
rs_source_ds	All	Name of primary data server identified to Replication Server.	<not_configured>
rs_username	All	User ID that Mirror Replication Agent uses to access primary Replication Server.	<not_configured>
rssd_charset	All	Character set used to communicate with RSSD.	““ (empty string)
rssd_database_name	All	Name of RSSD database.	<not_configured>
rssd_host_name	All	Name of RSSD host machine.	<not_configured>
rssd_password	All	Password for user ID Mirror Replication Agent uses to access RSSD.	““ (empty string)
rssd_port_number	All	Port number for RSSD.	1111
rssd_username	All	User ID that Mirror Replication Agent uses to access RSSD.	<not_configured>
scan_sleep_increment	All	Number of seconds to increase Log Reader wait before next scan after finding no operations to replicate.	5
scan_sleep_max	All	Maximum number of seconds for Log Reader to wait before next scan after finding no operations to replicate.	60
skip_ltl_errors	All	LTI ignores error messages returned by Replication Server.	false
structured_tokens	All	LTI uses structured tokens when generating LTL output.	true
truncation_interval	Oracle	Number of minutes to wait between automatic log truncations.	0
truncation_type	Oracle	Method(s) of log truncation allowed.	locator_update
use_rssd	All	Switches on/off access to RSSD for replication definitions.	true

Table 3-1: Mirror Replication Agent configuration parameters

Parameter name

Target

Description

Default

admin_port

All

Port number on which Mirror Replication Agent listens for incoming user connections.

10000

column_compression

All

Use minimal column information.

true

compress_ltl_syntax

All

Use abbreviated LTL syntax.

true

connect_to_rs

All

Enable/disable connection from LTI to Replication Server.

true

ddl_password

Oracle

Password for user ID passed in LTL with replicated DDL invocations.

<not_configured>

ddl_username

Oracle

User ID passed in LTL with replicated DDL invocations.

<not_configured>

dump_batch_timeout

All

Time to send incomplete buffer to Replication Server.

filter_maint_userid

All

Log Reader filters operations with maintenance user ID.

true

function_password

Oracle

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

““ (empty string)

function_username

Oracle

User ID passed in LTL with replicated stored procedure invocations.

log_backup_files

All

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

log_directory

All

Directory where Mirror Replication Agent system log file is located.

Current directory on the Mirror Replication Agent host machine from which the Mirror Replication Agent instance was started.

log_trace_verbose

All

Switch on/off verbose mode in trace log file.

false

log_wrap

All

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

1000

lti_batch_mode

All

Specifies whether to batch the LTL commands sent to Replication Server.

true

lti_max_buffer_size

All

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

5000

lti_update_trunc_point

All

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

1000

ltl_batch_size

All

Size of the LTL batch buffer.

40000

ltl_big_endian_unitext

All

Specifies whether "unitext" data should be converted from little endian to big endian before sending LTL to Replication Server.

true

ltl_character_case

All

Case of database object names sent to Replication Server.

asis

ltl_origin_time_required

All

Specifies whether to send origin_time command tag in LTL.

false

ltm_admin_pw

All

Password for Mirror Replication Agent administrative port.

““ (empty string)

ltm_admin_user

All

User ID for Mirror Replication Agent administrative port.

max_ops_per_scan

All

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

1000

pdb_archive_path

Oracle

Identifies the directory path where the Replication Agent expects to find archived Oracle redo log files.

none

pdb_archive_remove

Oracle

Enables or disables the removal of archived Oracle redo log files from the path specified by pdb_archive_path.

false

pdb_automark_tables

All

Automatic marking of user tables when the Replication Agent is initialized.

true

pdb_auto_create_repdefs

All

Automatic creation of Replication Definitions when tables or procs are marked.

true

pdb_auto_run_scripts

Oracle

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

true

pdb_convert_datetime

Oracle

Converts native date/time formats to Sybase datetime format.

false

pdb_dflt_column_repl

All

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

true

pdb_dflt_object_repl

All

Enables replication by default when object is marked.

true

pdb_include_archives

Oracle

Enables or disables the use of Oracle archive log files.

true

pdb_support_large_identifier

All

To support replication of large identifiers up to 255 characters in length.

true

pdb_timezone_file

Oracle

Specifies the file to read at initialization to obtain Oracle time zone information.

none

pdb_xlog_device

Oracle

Name of the primary database device.

NULL

pdb_xlog_prefix

Oracle

Character string prefix used to identify transaction log objects.

ra_

pdb_xlog_prefix_chars

Oracle

Non-alphabetic characters allowed in pdb_xlog_prefix.

_#$

pds_connection_type

All

Type of connection to primary data server.

For Oracle: ORAJDBC

pds_database_name

All

Name of database replicated from primary data server.

<not_configured>

pds_datasource_name

All

Data source name of database replicated from primary data server.

<not_configured>

pds_host_name

All

Name of primary data server host machine.

<not_configured>

pds_password

All

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

““ (empty string)

pds_port_number

All

Port number for primary data server.

1111

pds_retry_count

All

Number of times to retry connection to primary data server.

pds_retry_timeout

All

Number of seconds to wait between connection retry attempts.

pds_server_name

All

Server name of primary data server.

<not_configured>

pds_username

All

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

<not_configured>

ra_retry_count

All

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

ra_retry_timeout

All

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

rasd_backup_dir

All

The directory path for Replication Agent System Database (RASD) backup files.

<not_configured>

rasd_database

All

The directory path for the Replication Agent System Database (RASD) database file.

<not_configured>

rasd__mirror_tran_log

All

Enables or disables Replication Agent System Database (RASD) transaction log mirroring.

false

rasd_trace_log_dir

All

The directory path for the Replication Agent System Database (RASD) trace log file.

<not_configured>

rasd_tran_log

All

The directory path for the Replication Agent System Database (RASD) transaction log file.

<not_configured>

rasd__tran_log_mirror

All

The directory path for the Replication Agent System Database (RASD) transaction log file mirror.

path to the RASD transaction log file

rs_charset

All

Character set used to communicate with Replication Server.

““ (empty string)

rs_host_name

All

Name of primary Replication Server host machine.

<not_configured>

rs_packet_size

All

Network I/O packet size sent to Replication Server.

2048

rs_password

All

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

““ (empty string)

rs_port_number

All

Port number for primary Replication Server.

1111

rs_retry_count

All

Number of times to retry connection to primary Replication Server.

rs_retry_timeout

All

Number of seconds to wait between connection retry attempts.

rs_source_db

All

Name of primary database identified to Replication Server.

<not_configured>

rs_source_ds

All

Name of primary data server identified to Replication Server.

<not_configured>

rs_username

All

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

<not_configured>

rssd_charset

All

Character set used to communicate with RSSD.

““ (empty string)

rssd_database_name

All

Name of RSSD database.

<not_configured>

rssd_host_name

All

Name of RSSD host machine.

<not_configured>

rssd_password

All

Password for user ID Mirror Replication Agent uses to access RSSD.

““ (empty string)

rssd_port_number

All

Port number for RSSD.

1111

rssd_username

All

User ID that Mirror Replication Agent uses to access RSSD.

<not_configured>

scan_sleep_increment

All

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

scan_sleep_max

All

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

skip_ltl_errors

All

LTI ignores error messages returned by Replication Server.

false

structured_tokens

All

LTI uses structured tokens when generating LTL output.

true

truncation_interval

Oracle

Number of minutes to wait between automatic log truncations.

truncation_type

Oracle

Method(s) of log truncation allowed.

locator_update

use_rssd

All

Switches on/off access to RSSD for replication definitions.

true

For more information about the ra_config command and Mirror Replication Agent configuration parameters, see the Mirror Replication Agent Reference Manual.