These instructions describe how to configure OpenSwitch manually by editing the sql.ini file and the OpenSwitch configuration file.
In Windows, open a Command Prompt window, go to the %SYBASE% directory, and run:
.\SYBASE.bat
Verify that the sql.ini file exists in the %SYBASE%\ini directory. If it does not, create it by copying from sample.ini. Go to the %SYBASE%\ini directory, and enter:
cp sample.ini sql.ini
Open the sql.ini file in a text editor and modify or add entries to provide the server names and port numbers for each OpenSwitch server and each Adaptive Server in your installation. For example, if you installed two OpenSwitch servers and two Adaptive Servers, you must provide the server name, host name, and port number for each server. In addition, if you are implementing mutually-aware support, you must include the server name, host name, and port number for the companion OpenSwitch server as the last line in the other OpenSwitch server’s entry.
Enter the information in this format:
[servername] master=tcp,hostname,port query=tcp,hostname,port query=tcp,hostname,port
The second “query” line is necessary
only for mutually-aware OpenSwitch servers. See the OpenSwitch
Administration Guide for details about this feature.
[servername] – enter the name of the OpenSwitch server or Adaptive Server.
master=tcp,hostname,port – enter
the name of the machine where the server is running, and the port
number from which the server is started.
query=tcp,hostname,port – (first “query” line)
enter the name of the machine where the server is running, and the
port number from which the server is started.
For mutually-aware OpenSwitch servers only:
query=tcp,hostname,port – (second “query” line)
enter the name of the machine where the mutually-aware
companion OpenSwitch server is running, and the port number from
which that server is started.
For example, if you install one OpenSwitch server (no mutually-aware support) and two Adaptive Servers all on the same machine, the entries in the sql.ini file would look similar to this:
[OSWITCH1] master=TCP,dev2,4000 query=TCP,dev2,4000 [ASESRV1] master=TCP,dev2,5000 query=TCP,dev2,5000 [ASESRV2] master=TCP,dev2,5001 query=TCP,dev2,5001
If you install two OpenSwitch servers that are mutually-aware on one machine and two Adaptive Servers each on a different machine, the entries in the sql.ini file would look similar to this:
[OSW1] master=TCP,dev2,5000 query=TCP,dev2,5000 query=TCP,dev2,5005 [OSW2] master=TCP,dev2,5005 query=TCP,dev2,5005 query=TCP,dev2,5000 [ASE1] master=TCP,dev1,7000 query=TCP,dev1,7000 [ASE2] master=TCP,dev3,8000 query=TCP,dev3,8000
Save the sql.ini file and close the text editor.
Setting up the OpenSwitch configuration file and logs directory
Create a new OpenSwitch configuration file by going to %OPENSWITCH%\config and copying the sample.cfg file by entering:
cp sample.cfg cfg_file
where cfg_file is the name of your server configuration, for example, OpenSwitch_ServerName.cfg.
Use a text editor to set the values in the configuration file you just created. See the tables in “Configuring OpenSwitch using the GUI tool” for definitions of the values you should provide.
Save the file and close the text editor.
Go to %OPENSWITCH% and create a logs directory:
mkdir logs
