Configuring RepAgent

Use sp_config_rep_agent to change the default RepAgent configuration parameters.

The default RepAgent configuration parameters are set after enabling RepAgent using rs_init or sp_config_rep_agent. Configuration parameters affecting RepAgent are stored in the sysattributes table of the database for which RepAgent is enabled. You must restart RepAgent for the new parameters to take effect. There are also network security configuration parameters for RepAgent if your system supports network-based security.

To configure RepAgent:

Log in to Adaptive Server and specify the database.
For example:
```
use dbname
go
```
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:
```
sp_config_rep_agent dbname, ‘scan batch size’, ’2000’
go
```
Restart RepAgent for the new parameter to take effect.
```
sp_start_rep_agent dbname
go
```

In the Replication Server Reference Manual see:

Adaptive Server Commands and System Procedures
Configuration Parameters Affecting RepAgent