Configuration Parameter Reference

The Replication Agent configuration parameters table lists all of the Replication Agent configuration parameters and a brief description of each parameter. The target column indicates when the parameter is used for “All” targets or specific targets: Oracle, Microsoft SQL Server (MSSQL), or DB2 UDB (UDB).

Replication Agent Configuration Parameters
Parameter Name	Target	Description
admin_port	All	Port number that Replication Agent will use to listen for administrative connections.
asa_host	All	The host machine for RASD of the Replication Agent.
asa_port	All	The client port number for RASD of the Replication Agent.
asa_password	All	Identifies the password for RASD.
asm_password	Oracle	Password for Automatic Storage Management (ASM) access for the user specified in the asm_username.
asm_tns_connection	Oracle	Identifies the Oracle ASM connection name found in the tnsnames.ora file.
asm_tns_filename	Oracle	Identifies the Oracle tnsnames.ora file name where the ASM connection information is located.
asm_username	Oracle	Identifies the Oracle user name to be used when connecting to the ASM server.
auto_adjust_block_count	MSSQL	Determines whether or not Replication Agent should automatically adjust the log_read_block_count parameter if any part of a read is discarded
column_compression	All	Use minimal column information in LTL.
compress_ltl_syntax	All	Use abbreviated LTL syntax.
connect_to_rs	All	Enable/disable connection from LTI to Replication Server.
ddl_password	Oracle MSSQL	Password for ddl_username.
ddl_username	Oracle MSSQL	The database user name included in LTL for replicating DDL commands to the replicate database.
dump_batch_timeout	All	Number of seconds to wait before sending an incomplete LTL buffer to Replication Server.
filter_maint_userid	All	Log Reader filters operations with maintenance user ID.
function_password	Oracle MSSQL	Password for user ID passed in LTL with replicated stored procedure invocations.
function_username	Oracle MSSQL	User ID passed in LTL with replicated stored procedure invocations.
lob_uncommitted_read	UDB	Enables or disables uncommitted read.
log_backup_files	All	Determines the number of log backup files kept in the log directory.
log_directory	All	Directory where Replication Agent system log file is located.
log_read_block_count	MSSQL	Determines the number of blocks or pages that are read at a time from the primary database transaction log.
log_trace_verbose	All	Switch on/off verbose mode in trace log file.
log_wrap	All	Number of 1KB blocks written to log file before wrapping.
lr_max_lobdata_cache	Oracle	Maximum size of LOB data cache for off-row LOB data.
lr_max_op_queue_size	All	Maximum number of operations permitted in the log reader operation queue during replication.
lr_max_scan_queue_size	All	Maximum number of log records permitted in the log reader log scan queue during replication.
lr_ntext_byte_order	Oracle MSSQL	Specifies which byte order to use when replicating NCLOB for Oracle, and NTEXT for Microsoft SQL Server.
lr_read_buffer_size	UDB	Size in bytes of the log read buffer.
lr_send_trunc_partition_ddl	Oracle	Determines whether truncate partition commands are sent as DDL or DML to the replicate database.
lti_batch_mode	All	Switches on/off LTI batch mode.
ltl_formatter_count	All	Number of threads in the LTL formatter that work concurrently on items in the LTI queue.
lti_max_buffer_size	All	Maximum number of change sets stored in the LTI input buffer.
lti_update_trunc_point	All	Number of LTL commands sent before LTI requests new LTM Locator.
ltl_batch_size	All	Size of the LTL batch buffer.
ltl_big_endian_unitext	All	Specifies whether unicode LOB data should be converted from little endian to big endian before sending LTL to Replication Server.
ltl_character_case	All	Case of database object names sent to Replication Server.
ltl_origin_time_required	All	Specifies whether to send origin_time command tag in LTL.
ltl_send_only_primary_keys	All	Controls whether Replication Agent sends only primary key columns data for the before image for update and delete operations.
ltl_trace_in_hex	All	Determines whether Replication Agent logs values of non-unichar (such as char, varchar, or text) datatypes in hexadecimal format in the LTITRACELTL.log file, when LTITRACELTL trace is set to true.
ltm_admin_pw	All	Password for Replication Agent administrative port.
ltm_admin_pw_min_length	All	The minimum length of the Replication Agent administrator login password.
ltm_admin_user	All	User ID for Replication Agent administrative port.
max_ops_per_scan	All	Maximum number of operations Log Reader will read in a single log scan.
pdb_archive_control_path	UDB	Sets the explicit path for the SQLOGCTL.LFH file or other control files.
pdb_archive_path	Oracle UDB	Identifies the directory path where Replication Agent expects to find archived Oracle redo log files or the archived UDB transaction log files.
pdb_archive_remove	Oracle UDB	Enables or disables the removal of archived transaction log files from the path specified by pdb_archive_path.
pdb_auto_alter_repdefs	Oracle	Determines whether Replication Agent automatically generates alter replication definition statements, when processing changes in a marked table schema.
pdb_auto_create_repdefs	All	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.
pdb_automark_tables	Oracle MSSQL	Determines if Replication Agent automatically marks tables for replication during initialization or DDL replication.
pdb_auto_run_scripts	All	Automatic execution of SQL scripts used to create/remove transaction log objects and mark/unmark primary database objects.
pdb_convert_datetime	All	Converts native date/time formats to Sybase `datetime` format.
pdb_dflt_column_repl	All	Enables replication for LOB columns by default when table is marked.
pdb_dflt_object_repl	Oracle UDB	Enables replication by default when object is marked.
pdb_ignore_unsupported_anydata	Oracle	Determines whether or not Replication Agent ignores data of unsupported datatypes stored in columns of type `ANYDATA`.
pdb_include_archives	Oracle	Enables or disables the use of Oracle archive log files.
pdb_skip_missing_user	All	Determines whether or not Replication Agent skips the processing of any command for which there is no matching session or user information.
pdb_support_large_identifier	All	To support replication of large identifiers up to 255 characters in length with Replication Server 12.6 or later.
pdb_timezone_file	Oracle	Specifies the file to read at Replication Agent initialization to obtain Oracle time zone information.
pdb_xlog_device	All	Name of the primary database device.
pdb_xlog_prefix	All	Character string prefix used to identify transaction log objects.
pdb_xlog_prefix_chars	All	Non-alphabetic characters allowed in pdb_xlog_prefix.
pds_connection_type	All	Type of connection to primary data server.
pds_dac_port_number	MSSQL	The primary database dedicated administrative connection port number used by Replication Agent during the server level initialization of the primary database.
pds_database_name	All	Name of database replicated from the primary data server.
pds_datasource_name	UDB	Data source name or database alias of the database replicated from the primary data server.
pds_host_name	All	Name of primary data server host machine.
pds_integrated_security	MSSQL	Determines if Replication Agent should use Windows authentication when connecting to the primary SQL Server.
pds_password	All	Password for user ID that Replication Agent uses to access the primary data server.
pds_port_number	All	Port number for the primary data server.
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	MSSQL	Server name of primary data server.
pds_ssl_sc_cn	MSSQL	Common name (CN) of the primary data server certificate.
pds_ssl_sc_dn	Oracle	Distinguished name (DN) of the primary data server certificate.
pds_tns_connection	Oracle	Oracle connection name found in the tnsnames.ora file which identifies the connection information for the primary database.
pds_tns_filename	Oracle	Oracle file name identifying the Oracle tnsnames.ora file to be used to identify the connection information for the primary database.
pds_username	All	User ID that Replication Agent uses to access primary data server.
ra_admin_device	All	The primary database device on which Replication Agent system objects are created.
ra_admin_instance_prefix	All	The prefix string used to identify Replication Agent system objects specific to one Replication Agent instance.
ra_admin_prefix	All	The prefix string used to identify shared Replication Agent system objects.
ra_admin_prefix_chars	All	Non-alphabetic characters that are allowed in the database object name prefix string that identifies Replication Agent system objects.
ra_admin_owner	All	The owner of all Replication Agent system objects, including shared and instance-specific system objects.
ra_admin_owner_password	Oracle	The password for the user name specified in the ra_admin_owner parameter.
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.
rasd_database	All	The directory path for the Replication Agent System Database (RASD) database file.
rasd_mirror_tran_log	All	Enables or disables Replication Agent System Database (RASD) transaction log mirroring.
rasd_trace_log_dir	All	The directory path for the Replication Agent System Database (RASD) trace log file.
rasd_tran_log	All	The directory path for the Replication Agent System Database (RASD) transaction log file.
rasd_tran_log_mirror	All	The directory path for the Replication Agent System Database (RASD) transaction log file mirror.
ra_standby	Oracle	Determines whether or not Replication Agent functions in standby mode.
ra_statrack_interval	All	Determines the interval, in seconds, at which statistics are sampled by ra_statrack.
repdef_send_standby	Oracle	Determines whether Replication Agent adds the send standby clause when creating replication definitions.
rman_enabled	Oracle	Indicates whether or not Replication Agent uses the Oracle RMAN utility to truncate old archive log files.
rman_password	Oracle	Password used with rman_username to connect to the Oracle RMAN utility.
rman_path	Oracle	The directory path for the Oracle RMAN utility.
rman_username	Oracle	Login name used with rman_password to connect to the Oracle RMAN utility.
rs_charset	All	Character set used to communicate with Replication Server.
rs_host_name	All	Name of primary Replication Server host machine.
rs_packet_size	All	Network I/O packet size for data sent to Replication Server.
rs_password	All	Password for user ID Replication Agent uses to access Replication Server.
rs_port_number	All	Port number for primary Replication Server.
rs_replicate_owner_required	All	Indicates if the owner is always included with the replicate table clause when generating replication definitions.
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.
rs_source_ds	All	Name of primary data server identified to Replication Server.
rs_ticket_version	All	Determines whether Replication Agent records the primary database time or the primary database date and time into the rs_ticket marker.
rs_username	All	User ID that Replication Agent uses to access primary Replication Server.
rssd_charset	All	Character set used to communicate with RSSD.
rssd_database_name	All	Name of RSSD database.
rssd_host_name	All	Name of RSSD host machine.
rssd_password	All	Password for user ID that Replication Agent uses to access RSSD.
rssd_port_number	All	Port number for RSSD.
rssd_username	All	User ID that Replication Agent uses to access RSSD.
scan_fetch_size	All	Number of rows to fetch from the primary database when Oracle LogMiner is scanning the log in each network round-trip.
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_lr_errors	Oracle UDB	Determines whether Replication Agent ignores log record processing errors.
skip_ltl_errors	All	LTI ignores error messages returned by Replication Server.
ssl_certificates_filename	All	Indicates the path of the file containing Certificate Authority (CA) certificates included with the Replication Agent installation.
ssl_identity_filename	All	Indicates the path to the Replication Agent instance identity file, a PKCS #12 file containing an asymmetric key pair used for SSL communication.
ssl_identity_password	All	The passsword to access a Replication Agent instance identity file.
structured_tokens	All	LTI uses structured tokens when generating LTL output.
truncation_interval	All	Number of minutes to wait between automatic log truncations.
truncation_type	All	Methods of log truncation allowed.
use_rssd	All	Switches on/off access to RSSD for replication definitions.
use_ssl	All	Indicates whether clients must use SSL to connect to Replication Agent.