Table 2-1 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).
Parameter name |
Target |
Description |
---|---|---|
All |
Port number that the Replication Agent will use to listen for administrative connections. |
|
Oracle |
Determines the number of blocks or pages that are read at a time from the primary database archive log. |
|
Oracle |
Password for Oracle Automatic Storage Management (ASM) access for the user specified in the asm_username. |
|
Oracle |
Identifies the Oracle ASM connection name found in the tnsnames.ora file. |
|
Oracle |
Identifies the Oracle tnsnames.ora file name where the ASM connection information is located. |
|
Oracle |
Identifies the Oracle user name to be used when connecting to the ASM server. |
|
Oracle MSSQL |
Determines whether or not the Replication Agent should automatically adjust the log_read_block_count parameter if any part of a read is discarded |
|
All |
Use minimal column information in LTL. |
|
All |
Use abbreviated LTL syntax. |
|
All |
Enable/disable connection from LTI to Replication Server. |
|
Oracle MSSQL |
Password for ddl_username. |
|
Oracle MSSQL |
The database user name included in LTL for replicating DDL commands to the replicate database. |
|
All |
Number of seconds to wait before sending an incomplete LTL buffer to Replication Server. |
|
All |
Log Reader filters operations with maintenance user ID. |
|
Oracle MSSQL |
Password for user ID passed in LTL with replicated stored procedure invocations. |
|
Oracle MSSQL |
User ID passed in LTL with replicated stored procedure invocations. |
|
All |
Determines the number of log backup files kept in the log directory. |
|
All |
Directory where Replication Agent system log file is located. |
|
Oracle MSSQL |
Determines the number of blocks or pages that are read at a time from the primary database transaction log. |
|
All |
Switch on/off verbose mode in trace log file. |
|
All |
Number of 1KB blocks written to log file before wrapping. |
|
Oracle MSSQL |
Maximum number of log records permitted in the log reader log scan queue during replication. |
|
Oracle MSSQL |
Maximum number of operations permitted in the log reader operation queue during replication. |
|
Oracle MSSQL |
Specifies which byte order to use when replicating NCLOB for Oracle, and NTEXT for Microsoft SQL Server. |
|
Oracle |
Determines whether redo log threads for all nodes in an RAC database are scanned in parallel or with a serial scan. |
|
UDB |
Size in bytes of the log read buffer. |
|
Oracle |
Determines whether truncate partition commands are sent as DDL or DML to the replicate database. |
|
All |
Switches on/off LTI batch mode. |
|
All |
Maximum number of change sets stored in the LTI input buffer. |
|
All |
Number of LTL commands sent before LTI requests new LTM Locator. |
|
All |
Size of the LTL batch buffer. |
|
All |
Specifies whether unicode LOB data should be converted from little endian to big endian before sending LTL to Replication Server. |
|
All |
Case of database object names sent to Replication Server. |
|
All |
Specifies whether to send origin_time command tag in LTL. |
|
All |
Controls whether the Replication Agent sends only primary key columns data for the before image for update and delete operations. |
|
All |
Password for Replication Agent administrative port. |
|
All |
User ID for Replication Agent administrative port. |
|
All |
Maximum number of operations Log Reader will read in a single log scan. |
|
Oracle UDB |
Identifies the directory path where the Replication Agent expects to find archived Oracle redo log files or the archived UDB transaction log files. |
|
Oracle UDB |
Enables or disables the removal of archived transaction log files from the path specified by pdb_archive_path. |
|
Oracle MSSQL |
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. |
|
Oracle MSSQL |
Determines if the Replication Agent automatically marks tables for replication during initialization or DDL replication. |
|
All |
Automatic execution of SQL scripts used to create/remove transaction log objects and mark/unmark primary database objects. |
|
Oracle |
Determines whether or not Replication Agent generates commit log records at the primary database. |
|
Oracle |
Determines the interval in seconds at which Replication Agent generates commit log records. |
|
All |
Converts native date/time formats to Sybase datetime format. |
|
All |
Enables replication for LOB columns by default when table is marked. |
|
Oracle UDB |
Enables replication by default when object is marked. |
|
Oracle |
Determines whether or not Replication Agent ignores data of unsupported datatypes stored in columns of type ANYDATA. |
|
Oracle |
Enables or disables the use of Oracle archive log files. |
|
All |
Determines whether or not Replication Agent skips the processing of any command for which there is no matching session or user information. |
|
All |
To support replication of large identifiers up to 255 characters in length with Replication Server 12.6 or later. |
|
Oracle |
Specifies the file to read at Replication Agent initialization to obtain Oracle time zone information. |
|
All |
Name of the primary database device. |
|
All |
Character string prefix used to identify transaction log objects. |
|
All |
Non-alphabetic characters allowed in pdb_xlog_prefix. |
|
All |
Type of connection to primary data server. |
|
MSSQL |
The primary database dedicated administrative connection port number used by Replication Agent during the server level initialization of the primary database. |
|
All |
Name of database replicated from the primary data server. |
|
UDB |
Data source name or database alias of the database replicated from the primary data server. |
|
All |
Name of primary data server host machine. |
|
MSSQL |
Determines if the Replication Agent should use Windows authentication when connecting to the primary SQL Server. |
|
All |
Password for user ID that the Replication Agent uses to access the primary data server. |
|
All |
Port number for the primary data server. |
|
All |
Number of times to retry connection to primary data server. |
|
All |
Number of seconds to wait between connection retry attempts. |
|
All |
Server name of primary data server. |
|
Oracle |
Oracle connection name found in the tnsmame.ora file which identifies the connection information for the primary database. |
|
Oracle |
Oracle file name identifying the Oracle tnsname.ora file to be used to identify the connection information for the primary database. |
|
All |
User ID that Replication Agent uses to access primary data server. |
|
All |
Number of times LTM attempts to get back to Replicating state after a failure. |
|
All |
Number of seconds to wait between LTM attempts to get back to Replicating state. |
|
Oracle MSSQL |
The directory path for Replication Agent System Database (RASD) backup files. |
|
Oracle MSSQL |
The directory path for the Replication Agent System Database (RASD) database file. |
|
Oracle MSSQL |
Enables or disables Replication Agent System Database (RASD) transaction log mirroring. |
|
Oracle MSSQL |
The directory path for the Replication Agent System Database (RASD) trace log file. |
|
Oracle MSSQL |
The directory path for the Replication Agent System Database (RASD) transaction log file. |
|
Oracle MSSQL |
The directory path for the Replication Agent System Database (RASD) transaction log file mirror. |
|
Oracle |
Determines whether or not Replication Agent functions in standby mode. |
|
Oracle |
Indicates whether or not Replication Agent uses the Oracle RMAN utility to truncate old archive log files. |
|
Oracle |
Password used with rman_username to connect to the Oracle RMAN utility. |
|
Oracle |
Login name used with rman_password to connect to the Oracle RMAN utility. |
|
All |
Character set used to communicate with Replication Server. |
|
All |
Name of primary Replication Server host machine. |
|
All |
Network I/O packet size sent to Replication Server. |
|
All |
Password for user ID Replication Agent uses to access Replication Server. |
|
All |
Port number for primary Replication Server. |
|
All |
Indicates if the owner is always included with the replicate table clause when generating replication definitions. |
|
All |
Number of times to retry connection to primary Replication Server. |
|
All |
Number of seconds to wait between connection retry attempts. |
|
All |
Name of primary database identified to Replication Server. |
|
All |
Name of primary data server identified to Replication Server. |
|
All |
Determines whether Replication Agent records the primary database time or the primary database date and time into the rs_ticket marker. |
|
All |
User ID that Replication Agent uses to access primary Replication Server. |
|
All |
Character set used to communicate with RSSD. |
|
All |
Name of RSSD database. |
|
All |
Name of RSSD host machine. |
|
All |
Password for user ID Replication Agent uses to access RSSD. |
|
All |
Port number for RSSD. |
|
All |
User ID that Replication Agent uses to access RSSD. |
|
Oracle |
Number of seconds that Replication Agent waits on an RAC node before the node is deemed inactive. |
|
All |
Number of seconds to increase Log Reader wait before next scan after finding no operations to replicate. |
|
All |
Maximum number of seconds for Log Reader to wait before next scan after finding no operations to replicate. |
|
All |
LTI ignores error messages returned by Replication Server. |
|
All |
LTI uses structured tokens when generating LTL output. |
|
All |
Number of minutes to wait between automatic log truncations. |
|
All |
Methods of log truncation allowed. |
|
All |
Switches on/off access to RSSD for replication definitions. |