Table 2-1 lists all of the Sybase Replication Agent configuration parameters, with a brief description of each parameter.
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.