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
```

See Replication Server Reference Manual > Adaptive Server Commands and System Procedures.

Configuration Parameters Affecting RepAgent
Use sp_config_rep_agent with the configuration parameters to affect how RepAgent connects to a database and to tune RepAgent performance.
Master Key and rs password
Set the master key password and rs password attributes to continue replication.

Parent topic: Manage RepAgent and Support Adaptive Server

Related concepts

Manage Network-based Security

Related tasks

Starting RepAgent