System Architecture

A Replication Server Data Assurance Option system has a central Data Assurance (DA) server component with zero or more satellite DA agents. The exact number of servers and agents depends on your deployment type: single-server or distributed.

Single-Server Deployment

The example architecture shown here illustrates a single-server deployment with:

One DA server (with embedded agent)
One primary (source) database
One replicate (target) database
Data Assurance System Database (DASD)
Command line tool (CLT)
Replication Server System Database (RSSD)
Protocols used between components

Single-Server Deployment
da_arc_ss

Distributed Deployment

The example architecture shown here illustrates a distributed deployment with:

One DA server (with embedded agent)
Two remote DA agents
One primary (source) database
Two replicate (target) databases
Data Assurance System Database (DASD)
Command line tool (CLT)
Replication Server System Database (RSSD)
Protocols used between components

Distributed Deployment
da_arc

DA server is the core component and includes the DASD and an embedded DA agent, which is called the local agent. The remote DA agent stands alone, and is used by a DA server to enhance comparison job performance. Sybase recommends that you install a remote DA agent on a machine that shares a fast Ethernet connection with your database.

DA server:

Compares rows
Compares schemas
Creates jobs
Creates schedules for job
Creates script for reconciliation
Creates Data Manipulation Language (DML) commands for automatic reconciliation
Checks job status
Generates reports

Determine the number of DA agents to install based on your database or replication environment requirements. For example, you may choose to install one remote DA agent for your primary (source) database and one remote DA agent for your replicate (target) database. If you have different jobs that connect to different databases, you may decide to install multiple remote DA agents. Or you may have a single primary database and 10 replicate databases, and yet choose to perform the entire comparison task using the local agent.

To send commands to the DA server or the DA agent, use either:

The interactive SQL (isql) tool. The isql parser lets you run multiple commands sequentially through an isql options file. See Adaptive Server Enterprise > Utility Guide > Using Interactive isql from the Command Line.
The Sybase Control Center Data Assurance plug-in. See Sybase Control Center 3.2.8 for Data Assurance Documentation.

DA server integrates with Replication Server to automatically generate DA server jobs that are based on the information in the RSSD. Replication Server can import jobs only from table replication definitions; it cannot import jobs from database replication definitions.

DA server supports only one login, da_admin, which is assigned all administrator privileges.