Manage RepAgent and Support Adaptive Server

Learn about Replication Server support for Adaptive Server features, and how to set up, configure, and manage RepAgent, the Replication Agent for Adaptive Server.

RepAgent is an Adaptive Server thread; it scans the database transaction log and sends transaction information to the Replication Server for distribution to subscribing databases.

See Replication Server Administration Guide Volume 2 > Performance Tuning > Replication Server Internal Processing > Processes in the Primary Replication Server > Replication Agent User Thread.

• Set up RepAgent
  After Replication Server and Adaptive Server are installed on your system, you must enable a RepAgent for each database the Replication Server manage.
• Configuring RepAgent
  Use sp_config_rep_agent to change the default RepAgent configuration parameters.
• Master Key and rs password
  Set the master key password and rs password attributes to continue replication.
• Starting RepAgent
  Use sp_start_rep_agent to start RepAgent on Adaptive Server.
• Stopping RepAgent
  To shut down RepAgent, log in to Adaptive Server and execute sp_stop_rep_agent.
• Disable RepAgent
  Use sp_config_rep_agent to disable RepAgent.
• Configure RepAgent for Network Security
  You can secure the pathway between RepAgent and Replication Server using network-based security features.
• Manage Log Transfer Activity
  Use the log transfer commands to suspend and resume log transfer if you perform recovery, troubleshooting, or diagnostic tasks.
• Review RepAgent Status and Configuration Information
  You can monitor RepAgent and see the values of configuration parameters using commands and system procedures. You can also use the Adaptive Server plug-in to Sybase Central to monitor RepAgent.
• Check Log Files for RepAgent Information and Error Messages
  Obtain RepAgent error and information messages that are recorded in the Adaptive Server errorlog file.
• Use Counters to Monitor RepAgent Performance
  Adaptive Server provides several counters for monitoring RepAgent performance. You can monitor RepAgent performance data using sp_sysmon.
• Support for Extended Limits
  Replication Server version 12.5 and later supports extended limits for replication definitions.
• Support for Longer Identifiers
  Replication Server version 15.0 and later increases the maximum length of replication object identifiers to 255 bytes.
• Support for bigdatetime and bigtime Datatypes
  Replication Server supports replication of the bigdatetime and bigtime datatypes included with Adaptive Server.
• Adaptive Server Shared-disk Cluster Support
  Replication Server and RepAgent thread both support the Adaptive Server shared-disk cluster environment.
• Deferred Name Resolution
  Deferred name resolution lets you create stored procedures in Adaptive Server without resolving the objects used internally by these stored procedures. Adaptive Server postpones the object resolution phase to the first time you execute the stored procedure in Adaptive Server.
• Adaptive Server Data Compression
  Replication Server supports the Adaptive Server data compression feature.
• Support for Incremental Data Transfer
  With Adaptive Server 15.5, you can transfer data incrementally from a table instead of having to transfer the whole table from one Adaptive Server to another. Replication Server supports the data definition language related to the Adaptive Server incremental data transfer feature.
• Predicated Privileges
  There are several requirements for Replication Server support for Adaptive Server predicated privileges.
• Granular Permissions
  Configure your replication system to ensure replication support for Adaptive Server granular permissions.
• Stored Procedure Replication and the execute as Clause
  Ensure support for stored procedure replication when you create stored procedures with the execute as {owner | caller} clause of the Adaptive Server create procedure command.
• Precomputed Result Sets
  Replication Server supports the replication of precomputed result sets DDL commands between primary and replicate Adaptive Server databases that support precomputed result sets.
• Transfer of Database Object Ownership
  Replication Server supports the transfer of database object ownership in Adaptive Server.
• Backlinking Pointers and Shrinking Databases
  Replication Server supports backlinking pointers and shrinking databases in Adaptive Server.
• Performance Enhancements for Adaptive Server Replication
  Replication Server provides several features that enhance performance for Adaptive Server replication.
• In-memory and Relaxed-Durability Databases
  Replication Server supports the in-memory and relaxed-durability database Adaptive Server feature.
• Replication Server Unsupported Operations
  There are some limitations when using Replication Server unsupported operations.