Adding entries to the interfaces file for client connections during failover

To enable clients to reconnect to the failed over companion, you must add a line to the interfaces file. By default, clients connect to the port listed in the query line of the server entry. If that port is not available (because the server has failed over), the client connects to the server listed in the hafailover line of the server entry. Here is a sample interfaces file for a primary companion named MONEY1 and a secondary companion named PERSONEL1:

MONEY1
				master tli tcp MONEY 9678
				query tli tcp MONEY 9678
				hafailover PERSONEL1 
PERSONEL1
	master tli tcp PERSONEL 9679
	query tli tcp PERSONEL 9679

Use dsedit to add entries to the interfaces file. If the interfaces entries already exist, you must modify them to work for failover.

See the Adaptive Server Enterprise Utility Guide for information about dsedit.