Configuring for Query Port Backup

If a client is connected to a server via two networks, the client can establish a connection via the second network if the first one goes down.

  1. Install multiple “master” and “query” lines in a server entry in the interfaces file.
  2. SAP ASE listens for connections at both ports. Clients looking for a host name and a port number for a connection to an SAP ASE try the port on each “query” line in order, until they establish a connection.

    This example shows how to configure a backup network that is used only if the normal connection fails. The primary network is “corporate network” and the backup is “engineering network.”

     # PRODUCTION server with two network listeners
     PRODUCTION<tab>3<tab>3<newline>
     <tab>master tcp ether SERV_CORPNET 4559
     <tab>master tcp ether SERV_ENGNET 5479
     <tab>query tcp ether SERV_CORPNET 4559
     <tab>query tcp ether SERV_ENGNET 5479
  3. Configure PC-client interfaces files with the appropriate multiple “query” entries, as described in the Open Client documentation. For client interfaces files in a homogeneous environment, you can copy the entire file entry for the SAP ASE into the client interfaces file.
  4. A connection on the secondary port occurs only if the corporate network is disabled, or if the corporate network interface on the host machine fails or is shut down due to a network-related failure.