RepAgent

Chapter 12 Working with Replication Server

When using Replication Server for a non Sybase ASE primary database, you need to use RepAgent.

RepAgent captures the changes made in the primary database and sends the transaction log to the primary Replication Server.

RepAgent needs to be configured to connect to the Primary Database, Primary Replication Server and RSSD database of the Primary Replication Server.

You need to define:

A server object for the primary database. The code of the server must be the host machine name where the primary database resides. You also need to define the port number in the PortNumber extended attribute of the server object
A server object for the replication process. The code of the server must be the host machine name where the primary Replication Server resides. You also need to define the port number in the PortNumber extended attribute of the server object
The RSSD database host name, port number and database name in the replication process Extended Attributes tab
The RepAgent specific properties in the primary database Extended Attributes tab

The following extended attributes are available from the server property sheet:

Name	Internal Code	Description
Port number	PortNumber	Specifies the primary database or Replication Server host machine port number

The following extended attributes are available from the primary database property sheet:

Name	Internal Code	Description
Use replication agent	UseReplicationAgent	Specifies if a replication agent should be used for primary database. This option is not necessary if the PDM of the primary database is defined and opened.
RepAgent type	RepAgentType	Specifies the replication agent type (Oracle, DB2, SQL Server, Informix, Mirror Activator)
RepAgent name	RepAgentName	Specifies the replication agent instance name. It is used to generate replication agent script using isql.
RepAgent user name	RepAgentUserName	Specifies the replication agent user login name. It is used to generate replication agent script using isql.
RepAgent password	RepAgentPassword	Specifies the replication agent user login password. It is used to generate replication agent script using isql.
Primary database user name	RepAgentPrimDBUserName	Specifies the primary database server user login name for the replication agent instance
Primary database password	RepAgentPrimDBPassword	Specifies the primary database server user login password for the replication agent instance
RepServer user name	RepAgentRepServerUserName	Specifies the Replication Server user login name for the replication agent instance
RepServer password	RepAgentRepServerPassword	Specifies the Replication Server user login password for the replication agent instance
RSSD user name	RepAgentRSSDUserName	Specifies the RSSD user login name for the replication agent instance
RSSD password	RepAgentRSSDPassword	Specifies the RSSD user login password for the replication agent instance

The following extended attributes are available from the replication process property sheet:

Name	Internal Code	Description
Host name	RSSDHostName	Specifies the host machine name of the RSSD database server
Port number	RSSDPortNumber	Specifies the port number of the RSSD database server
Database name	RSSDDatabaseName	Specifies the name of the RSSD database