Distributed Deployment

Sybase recommends a distributed deployment when there is high network latency between the DA server and the database servers, when many concurrent comparisons are required, or when performance requirements are more important than ease of deployment and maintenance.

Before You Begin

This example uses a single Data Assurance (DA) server and two remote DA agents. The local DA agent is not used.

Deployment Summary
Component Name	Machine Name	Port Numbers
DA server	mars	4500 – RMI 4501 – TDS 4503 – DASD 4504 – HTTP
DA agent	venus	4510 – RMI 4511 – TDS 4512 – DTS 4514 – HTTP
DA agent	pluto	4510 – RMI 4511 – TDS 4512 – DTS 4514 – HTTP
Adaptive Server Enterprise	venus	5000 – server
Adaptive Server Enterprise	pluto	5000 – server

Start your DA server instance:
```
$SYBASE/DA-15_5/server/myserver/RUN_myserver
```
Where $SYBASE is the directory in which you installed the Data Assurance Option, myserver is the name of your DA server instance, and RUN_myserver is the startup script.
Note: On Windows, the startup script file is named RUN_myserver_32.bat or RUN_myserver_64.bat, where myserver is your DA server instance name. On UNIX or Linux platforms, the file is named RUN_myserver_64.sh.
Start your DA agent instances on the machines named venus and pluto:
```
$SYBASE/DA-15_5/agent/myagent/RUN_myagent
```
Where $SYBASE is the directory in which you installed the Data Assurance agent, myagent is the name of your DA agent instance, and RUN_myagent is the startup script.
Note: On Windows, the startup script file is named RUN_myagent_32.bat or RUN_myagent_64.bat, where myagent is your DA agent instance name. On UNIX or Linux platforms, the file is named RUN_myagent_64.sh.
From isql, log in to DA server as an administrator:
```
$SYBASE/OCS-15_0/bin/isql -S mars:4501 -U da_admin -P sybase -w 250
```
Note: 4501 is the default TDS port number for DA server. The TDS port is required when the command line tool connects to the DA server using isql.
You can also log in to your DA agent instances in the same way. For example:
```
$SYBASE/OCS-15_0/bin/isql -S venus:4511 -U da_admin -P sybase -w 250
```
Verify the product version:
```
version
go
```

Create DA agent profiles to connect to the DA server:

create agent agent_venus 
	set host=venus 
	and set port=4510 
	and set user=da_admin 
	and set password=sybase  
	go

create agent agent_pluto
	set host=pluto
	and set port=4510 
	and set user=da_admin 
	and set password=sybase  
	go

View the newly created DA agents:
```
show agent
	go
```

Test connection settings for the DA agents:

test agent agent_venus
	go

test agent agent_pluto
	go

Create database connections for the new DA agents:

create connection conn_venus
	set agent=agent_venus 
	and set host=venus
	and set port=5000 
	and set database=pubs2 
	and set user=sa	 
	and set password='' 
	go

create connection conn_pluto
	set agent=agent_pluto 
	and set host=pluto
	and set port=5000 
	and set database=pubs2 
	and set user=sa	 
	and set password='' 
	go

Note: In this example, agent_venus connects to the Adaptive Server database installed on venus, and agent_pluto connects to the Adaptive Server installed on pluto.

View the newly created database connections:
```
show connection
	go
```
Continue from Step 6 in the previous example for a single-server deployment.