Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

DNS Names in Interfaces file

3 posts in Unix Last posting was on 2001-04-17 22:17:42.0Z
Admin Posted on 2001-04-04 15:26:04.0Z
From: "Admin" <tcgs@hotmail.com>
Subject: DNS Names in Interfaces file
Date: Wed, 4 Apr 2001 11:26:04 -0400
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <a3ZD94RvAHA.178@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
NNTP-Posting-Host: 159.231.37.1
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:638
Article PK: 1092728

Hi All,

The unix admin team wants us to use DNS names instead of hostname/ip
address. Does
sybase support DNS names in the interfaces file and sql.ini files? Is there
any advantages
or disadvantages using DNS names from Sybase perspective? (like any
performance issues
due to an extra step for the client to resolve the DNS name before
connecting to the
server). Any feedback is appreciated.

Admin
tcgs@hotmail.com


Mrs._Tweedy Posted on 2001-04-05 10:06:39.0Z
From: Mrs._Tweedy
Date: Thu, 5 Apr 2001 06:06:39 -0400
Newsgroups: sybase.public.sqlserver.unix
Subject: Re: DNS Names in Interfaces file
Message-ID: <7014D9F82B48339300378A5D85256A25.0057BCD585256A24@webforums>
References: <a3ZD94RvAHA.178@forums.sybase.com>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.unix:629
Article PK: 1092723

We do this all the time and I haven't seen any disadvantages yet .. other
than it makes the DNS servers even more critical as if they're down then
no-one will be able to connect to the db server eventhough it's running
fine and the network is also running correctly.

It gives you the advantage that if you want to move any of your servers to
different machines you don't have to change any of the interfaces / sql.ini
files (assuming you use the same port numbers). We use this quite a lot
for maintenance purposes and on the odd occasion for failover (touch wood!)


Robert Gumpertz Posted on 2001-04-17 22:17:42.0Z
Message-ID: <3ADCC106.845F8F31@examen.com>
Date: Tue, 17 Apr 2001 15:17:42 -0700
From: Robert Gumpertz <robertg@examen.com>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: DNS Names in Interfaces file
References: <a3ZD94RvAHA.178@forums.sybase.com> <7014D9F82B48339300378A5D85256A25.0057BCD585256A24@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 26
NNTP-Posting-Host: inferno.examen.com 208.147.70.129
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:595
Article PK: 1092685

We have some network re-configuration work coming up & would like to take
advantage of this to move machines from net to net temporarily (I think the
single disadvantage to permanent use might be the extra network traffic from
doing DNS lookups with each connect). Mrs. T, can you post an example line
from your interfaces file so I can make sure I have the proper format?
Very much obliged,
-bob g

Mrs._Tweedy wrote:

> We do this all the time and I haven't seen any disadvantages yet .. other
> than it makes the DNS servers even more critical as if they're down then
> no-one will be able to connect to the db server eventhough it's running
> fine and the network is also running correctly.
>
> It gives you the advantage that if you want to move any of your servers to
> different machines you don't have to change any of the interfaces / sql.ini
> files (assuming you use the same port numbers). We use this quite a lot
> for maintenance purposes and on the odd occasion for failover (touch wood!)