Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Informix sqlhosts port numbers for aliases

78 views
Skip to first unread message

skyk...@gmail.com

unread,
Jun 28, 2020, 9:21:30 AM6/28/20
to
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.
0 new messages