Ip address of Server

Analytics
Enthusiast

Ip address of Server

Is there any data Dictionary tables which maintains server name and Ip address of the server
3 REPLIES
Junior Contributor

Re: Ip address of Server

Hi Praneet,
there's no system table for that.
IP-addresses are resolved by CLI/ODBC using the network's name resolution facility, e.g. DNS, WINS, hosts-file.
COP1 is added to the system's logical name and that name is resolved, if successful COP2 is resolved and so on until name resolution fails.
E.g. system name "dbc" -> ip-address for "dbccop1" -> ip-address for "dbccop2" -> ...

Dieter
Enthusiast

Re: Ip address of Server

I have the DSN Name but I dont know the IP address.

If i updated my Host.ini file with DNS name Rather than IP address will it work?

I have updated with Dns name in Host file but it's not working.
Junior Contributor

Re: Ip address of Server

Hi Praneet,
within hosts there must be an entry like this for a logical name XXX:
ip-address1 XXXcop1
ip-address2 XXXcop2
...

Dieter