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 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
DA agent	venus	4510 – RMI 4511 – TDS 4512 – DTS
DA agent	pluto	4510 – RMI 4511 – TDS 4512 – DTS
Adaptive Server Enterprise	venus	5000 – server
Adaptive Server Enterprise	pluto	5000 – server

Start your DA server instance:
```
$SYBASE/DA-15_5/server/instance/RUN_instance_64.sh
```
Where $SYBASE is the directory in which you installed the Data Assurance Option, instance is the name of your DA server instance, and RUN_instance_64.sh is the start-up script.
Note: On Windows, the start-up script file is named RUN_instance_32.bat or RUN_instance_64.bat, where instance is your DA server instance name. On UNIX or Linux platforms, the file is named RUN_instance_64.sh.
Start your DA agent instances on the machines named venus and pluto:
```
$SYBASE/DA-15_5/agent/instance/RUN_instance_64.sh
```
Where $SYBASE is the directory in which you installed the Data Assurance agent, instance is the name of your DA agent instance, and RUN_instance_64.sh is the start-up script.
Note: On Windows, the start-up script file is named RUN_instance_32.bat or RUN_instance_64.bat, where instance is your DA server instance name. On UNIX or Linux platforms, the file is named RUN_instance_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 password -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 password -w 250
```

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=password  
go

create agent agent_pluto
	set host=pluto
	and set port=4510 
	and set user=da_admin 
	and set password=password  
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 5 in the previous example for a single-server deployment.