Lesson 3: Set up the Open Servers in your system

You need to add a set of Open Servers to the list of Open Servers in your system.

Adding Open Servers

Open Servers are defined in your interfaces file (SQL.ini) using the DSEdit utility. For Unix users, the interfaces file is named interfaces, and the utility is named sybinit.

For full instructions on how to add definitions to your interfaces file, see Configuring Open Servers.

Required Open Servers

For each Open Server definition, you must provide a name and an address. Do not alter the other attributes of the definition. You need to add an Open Server entry for each of the following:

  • The primary database   Create an entry named PRIMEDB with address as follows:

    • Protocol   NLWNSCK

    • Network address   localhost,2638

  • The replicate database   Create an entry named REPDB with address as follows:

    • Protocol   NLWNSCK

    • Network address   localhost,2639

  • The LTM at the primary database   This is necessary so you can shut down the LTM properly. Create an entry named PRIMELTM with address as follows:

    • Protocol   NLWNSCK

    • Network address   localhost,2640

  • Your Replication Server   This tutorial assumes you already have the Replication Server Open Server defined.

What's next?

Next, confirm that the Open Servers are configured properly.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1