sp_config_rep_agent

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

Syntax

sp_config_rep_agent [dbname
 [, {'enable', 'repserver_name', 'repserver_username', 'repserver_password'} |
'disable'[, 'preserve secondary truncpt'] |
'rs servername'[, 'repserver_name'] |
'rs username'[, 'repserver_username'] |
'rs password'[, 'repserver_password'] |
'scan batch size'[,'no_of_qualifying_log_records'] | 
'scan timeout'[, 'scan_timeout_in_seconds'] |
'retry timeout'[, 'retry_timeout_in_seconds'] |
'skip ltl errors'[, 'true' | 'false'] |
'batch ltl'[, 'true' | 'false'] |
'send warm standby xacts'[, 'true' | 'false'] |
'send buffer size’[, ‘2K’ | ‘4K’ |’8K’ | ‘16K’] |
'connect dataserver'[, 'connect_dataserver_name'] |
'connect database'[, 'connect_database_name'] |
'send maint xacts to replicate'[, 'true' | 'false'] |
'send structured oqids’[, ‘true’ | ‘false’] |
'short ltl keywords'[, 'true' | 'false'] |
'security mechanism'[, 'mechanism_name'] |
'unified login'[, 'true' | 'false'] |
'mutual authentication'[, 'true' | 'false'] |
'msg confidentiality'[, 'true' | 'false'] |
'msg integrity'[, 'true' | 'false'] |
'msg replay detection'[, 'true' | 'false'] |
'msg origin check'[, 'true' | 'false'] |
'msg out-of-sequence check'[, 'true' | 'false'] |
'skip unsupported features'[, 'true' | 'false'] |
'schema cache growth factor'[, 'growth_factor_value'] |
'ha failover'[, 'true' |'false'] |
'data limits filter mode'[, 'off' | 'stop' | 'skip' |'truncate'] |
'priority'[, 'priority_value'] |
'startup delay’[, 'delay_value'] |
'net password encryption’[, ‘true’ | ‘false’] |
'cluster instance name'[, 'coordinator' | 'instance_name'] |
'bind to engine'[, engine_number] |
'ltl batch size'[, ltl_batch_size] |
'ltl metadata reduction', {'true' |'false'}
'multithread rep agent', {'true' | 'false'}
'number of send buffers', {'num_of_send_buffers'} |
'max number replication paths', {'max number replication paths value'}
'ddl path for unbound objects', {'all' | 'default'} |
'auto start', {'true' | 'false'}]

Parameters

Examples

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.

Permissions

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

Related reference
sp_configure 'enable rep agent threads'
sp_help_rep_agent
sp_start_rep_agent
sp_stop_rep_agent