sp_config_rep

Changes or displays the configuration parameters for the RepAgent thread for an Adaptive Server database.

Syntax

sp_config_rep_agent [dbname[, RepAgent_parameter]

Parameters

dbname – the name of the database for which you want to configure RepAgent.
RepAgent parameter – The configuration parameter that affects RepAgent. See Configuration Parameters Affecting RepAgent.

Examples

Example 1 – Enables RepAgent for the pubs2 database. RepAgent connects to "repsvr1" with "repusr1" and password "reppwd1":
```
sp_config_rep_agent pubs2, 'enable', 'repsvr1',
  'repusr1', 'reppwd1'
```

Example 2 – Displays configuration information for the pubs2database:

sp_config_rep_agent pubs2

Parameter Name               Default    Config Value     Run Value
----------------------      ---------  ---------------  -------------
priority                       5            5                5
trace flags                    0            0                0
scan timeout                   15           15               15
retry timeout                  60           60               60
rs username                    n/a          rs1_user         rs1_user
batch ltl                      true         true             true
rs servername                  n/a          rs1              rs1
send buffer size               2k           4k               4k
trace log file                 n/a          n/a              n/a
connect database               n/a          n/a              pdb1
connect dataserver             n/a          n/a              pds1
scan batch size                1000         1000             1000
security mechanism             n/a          n/a              n/a
msg integrity                  false        false            false
unified login                  false        false            false
schema cache growth factor     1            1                1
skip ltl errors                false        false            false
msg origin check               false        false            false
short ltl keywords             false        false            false
msg confidentiality            false        false            false
data limits filter mode        stop         stop             stop
msg replay detection           false        false            false
mutual authentication          false        false            false
send structured oqids          false        false            false
send warm standby xacts        false        false            false
msg out-of-sequence check      false        false            false
skip unsupported features      false        false            false
send maint xacts to replicate  false        false            false
net password encryption        true         true             true
startup delay                  0            5                5
cluster instance name     coordinator  coordinator     coordinator
bind to engine                 -1           2                2
ltl batch size                 16384        16384            16384

Example 3 – Displays values for a specific parameter:

sp_config_rep_agent pubs2, 'scan batch size'

Parameter Name             Default      Config Value     Run Value
----------------------     ---------    ---------------  -------------
scan batch size              1000       1000             1000

Example 4 – Sets scan_timeout to 60 seconds for the pubs2database:
```
sp_config_rep_agent pubs2, 'scan timeout', '60'
```
Example 5 – Configures RepAgent to wait 50 seconds before starting:
```
sp_config_rep_agent pubs2, 'startup delay', '50'
```

Example 6 – Starts a disabled RepAgent on ASE1:

1> sp_config_rep_agent pdb, 
    'cluster instance name','ASE1'
2> go

Parameter Name             Default       Config Value     Run Value
----------------------     -----------   ---------------  -------------
cluster instance name      coordinator   ASE1             ASE1

Usage

Use sp_config_rep_agent to configure RepAgent for Adaptive Server databases.
Enable RepAgent in this way:
- sp_addserver – Identifies the Adaptive Server for RepAgent. You need to do this only once per screen.
- sp_configure 'enable rep agent thread' – Configures the data server for RepAgent. You need to do this only once per screen.
- sp_config_rep_agent – Configures the database for RepAgent.
Refer to the Adaptive Server Enterprise Reference Manual for more information about sp_addserver.
After you configure the parameters using sp_config_rep_agent, you must restart RepAgent using sp_start_rep_agent for the new parameters to take effect.
If you execute sp_config_rep_agent without parameters, Adaptive Server displays the default, configured, and runtime values for all databases that are enabled for RepAgent.

If you only enter dbname, Adaptive Server displays the default, configured, and runtime values for the specified database.
Properties specified by sp_config_rep_agent are stored in the sysattributes table of the database and have an attribute class of RA.
Use sp_config_rep_agent to set the RepAgent configuration parameters after you have enabled RepAgent at the data server using sp_configure.
repserver_user must have connect source permission.

Configuring Network-Based Security

Note: Network-based security for RepAgent is enabled with sp_configure at the Adaptive Server. See the Adaptive Server Enterprise System Administration Guide for more information.

A security mechanism may not support all security properties. Verify the properties of a security mechanism by executing admin security_property at the Replication Server. For more information, see admin security_property.
The security mechanism enabled for the RepAgent must be the same as that enabled for the Replication Server. Security settings at the RepAgent and the Replication Server must be compatible.
If RepAgent Setting Is

Setting at Replication Server Can Be
true

required, or

not required
false

not required
If unified_login is true, you must specify the rs_password parameter as NULL when RepAgent is enabled at the database.
If you specify one or more security settings, but do not specify a security mechanism, Adaptive Server initializes the default mechanism, the first entry in the SECURITY section in $SYBASE/$SYBASE_ASE/config/libtcl.cfg.

If RepAgent Setting Is	Setting at Replication Server Can Be
true	required, or not required
false	not required

Permissions

sp_config_rep_agent requires “sa” or “dbo” permission or replication_role.