- Forum
- Usenet
- COMP.DATABASES.INFORMIX
-
Informix sqlhosts port numbers for aliases
I'm using an Informix database 12.1 and I'm wondering if I should use unique port numbers for each alias. The two database servers are setup for HDR.
onconfig.dbserver1
DBSERVERNAME dbserver1
DBSERVERALIASES dbserver,dbserver_dr1
onconfig.dbserver2
DBSERVERNAME dbserver2
DBSERVERALIASES dbserver,dbserver_dr2
# sqlhosts.dbserver1
dbserver1 onsoctcp host1 50100
dbserver2 onsoctcp host2 50100
dbserver onsoctcp host1 50100
dbserver_dr1 drsoctcp host1 50200
dbserver_dr2 drscotcp host2 50200
# sqlhosts.dbserver2
dbserver1 onsoctcp host1 50100
dbserver2 onsoctcp host2 50100
dbserver onsoctcp host2 50100
dbserver_dr1 drsoctcp host1 50200
dbserver_dr2 drscotcp host2 50200
The same alias "dbserver" is needed on both servers so SQL statements using 'from database@dbserver:table' work. Is there any performance advantage in using distinct port numbers for aliases? In my setup each server is listening on the same port that it
makes an outgoing connection to the primary/secondary HDR.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)