Enabling RepAgent (using rs_init or sp_config_rep_agent) sets default configuration parameters. You can change the default parameters using sp_config_rep_agent. You must restart RepAgent for the new parameters to take effect.
Table 5-1 describes the configuration parameters that affect RepAgent. These parameters are stored in the sysattributes table of the database for which RepAgent is enabled.
If your system supports network-based security, refer to “Managing network-based security” for a list and description of network security configuration parameters for RepAgent.
Configuration parameter |
Description |
|---|---|
batch ltl |
When set to “true,” sends LTL commands to Replication Server in batches. When set to “false,” sends LTL commands to Replication Server one at a time. Default: true |
connect database |
The name of the database for which RepAgent is configured, or the name of the temporary database RepAgent uses when connecting to Replication Server in recovery mode. |
connect dataserver |
The name of the RepAgent data server or the name of the temporary data server RepAgent uses when connecting to Replication Server in recovery mode. |
data limits filter mode |
Specifies how RepAgent handles log records containing column counts greater than 250, column lengths greater than 255 bytes, and parameter lengths greater that 255 bytes before attempting to send them to Replication Server. Values are:
Default: off (Replication Server 12.5 and later); stop (Replication Server 12.1 and earlier) |
ha failover |
Specifies whether, when Sybase Failover has been installed, RepAgent automatically starts after server failover. Default: true |
priority |
Sets relative priority values for individual RepAgents. Recommended values are 4, 5, and 6, where 6 indicates low priority, 5 indicates medium priority, and 4 indicates high priority. Default: 5 |
rs name |
The name of the Replication Server to which RepAgent connects and transfers transactions from the transaction log. Use rs name when you have changed the name of the Replication Server. |
rs password |
The password RepAgent uses to log in to Replication Server. Use rs password when you want to change the RepAgent password. |
rs username |
The user name RepAgent uses to log in to Replication Server. Use rs_username when you want to change the RepAgent username. |
retry timeout |
The number of seconds RepAgent remains inactive before attempting to reconnect to Replication Server after a recoverable error or when Replication Server is down. Default: 60 seconds |
scan batch size |
The maximum number of log records to send to Replication Server in each batch. When this number of records have been sent, RepAgent asks Replication Server for a new secondary truncation point. Default: 1000 records |
scan timeout |
The amount of time RepAgent remains inactive after sending a batch to the Replication Server and before querying the Replication Server for the new secondary truncation point. If there are more records in the log, RepAgent resumes scanning. If there are no more records and the Replication Server has still not acknowledged receipt by sending a secondary truncation point, RepAgent again timeouts for the length of time this parameter is set to. Default: 15 seconds |
schema cache growth factor |
Controls the duration of time table or stored procedure schema can reside in the RepAgent schema cache before they expire. Larger values require more memory. Range is 1 to 10. Default: 1 |
send buffer_size |
Controls the size, in kilobytes, of the send buffer RepAgent uses to communicate with Replication Server. Values are 2K, 4K, 8K, and 16K. Default: 2K
|
send maint xacts to replicate |
When set to “true,” RepAgent sends records generated by the maintenance user to the Replication Server for distribution to subscribing sites. When set to “false,” RepAgent does not send records from the maintenance user to the Replication Server. Default: false |
send structured oqids |
Specifies whether RepAgent sends origin queue IDs (OQIDs) as structured tokens or as binary strings. When set to “true,” RepAgent sends OQIDS as structured tokens, which saves space in the LTL and improves throughput. Default: false |
send warm standby xacts |
Normally schema and system transactions are not sent to a warm standby database. When set to “true,” RepAgent sends schema, system, and maintenance-user transactions. When set to “false,” RepAgent does not send transactions to the standby database. Default: false |
short ltl keywords |
Specifies whether RepAgent sends an abbreviated form of LTL to Replication Server. When set to “true,” RepAgent uses the shortened LTL form that requires less space and reduces the amount of data sent to Replication Server. Default: true |
skip ltl errors |
When set to “true,” RepAgent ignores LTL errors returned by the Replication Server. This option is normally turned on during recovery. Default: false |
skip unsupported features |
Instructs RepAgent to skip log records for features unsupported by the Replication Server. This option is normally used if Replication Server is a earlier version than Adaptive Server. Default: false |
To configure RepAgent, log in to Adaptive Server and execute sp_config_rep_agent at the isql prompt. For complete syntax and usage information, see the Replication Server Reference Manual.
Execute sp_config_rep_agent once for each parameter you want to configure. For example, to change the maximum number of log records sent to Replication Server in a batch to 2000, perform these steps:
Log in to Adaptive Server and enter:
use dbname
go
sp_config_rep_agent dbname, ’scan batch size’, ’2000’
Restart RepAgent:
sp_start_rep_agent dbname
The new parameter takes effect after you restart RepAgent.
Refer to “Starting RepAgent” for more information about sp_start_rep_agent.
Send-buffer size is not related to database page size.