Configuring OpenSwitch manually

These instructions describe how to configure OpenSwitch manually by editing the connectivity configuration file (sql.ini) and the OpenSwitch configuration file (<primary_OpenSwitch_server_name>.cfg).

Setting up the sql.ini connectivity configuration file

1. In Windows, open a Command Prompt window, go to the%SYBASE% directory, and run the SYBASE.bat file:

   %SYBASE%\SYBASE.bat
   

2. Verify that the sql.ini file exists in the %SYBASE% directory. If it does not, create it by copying from sample.ini. Go to the %SYBASE% directory, and enter:

   cd %SYBASE%\ini
   cp sample.ini sql.ini
   

3. 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 theOpenSwitch 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 that 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 that 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
   

4. Save the sql.ini file and close the text editor.

Setting up the OpenSwitch configuration file

1. Create a new OpenSwitch configuration file by going to %OPENSWITCH%\config and copying the sample.cfg file by entering the following, where <cfg_file> is the name of your server configuration, for example, OpenSwitch.cfg:

   cp sample.cfg <cfg_file>
   

   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.

2. Save the file and close the text editor.

3. Go to %OPENSWITCH% and create a logs directory:

   mkdir logs
   

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF