Re: Changing hostname / IP address
A poster asked whether moving an IDS 7.3/Solaris 8 instance to a new machine by giving that box the old host name and IP (plus editing sqlhosts) would work, so that desktop icons on hundreds of PCs wouldn't all need changing, and whether sysmaster/sysutils would object. The only substantive reply recommended avoiding the hostname swap altogether by using DNS alias (CNAME) records: point sqlhosts entries and client icons at a logical name, then just repoint the alias when the server moves, with separate aliases for the database engine and the application server. The rest of the thread is joking about host-naming conventions; no confirmation from the original poster is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
"Five Cats" <cats_spam@[127.0.0.1]> wrote ... > > A customer has a nice new (ish) box and are wondering if changing the IP > address & host name to that of the current one (which would of course > also be changed) would be a possible way of avoiding having to get a new > icon on each PCs desktop - there are several hundred PCs in quite a few > offices across 800 square miles and they don't have Citrix or similar to > manage the desktops. > > I can see it will be necessary to alter the host in the sqlhosts file, > but will this be acceptable? Or is there something I don't know about > in the sysmaster and/or sysutils database that would get upset? > > The OS is Solaris 8, the Informix is IDS 7.3x. DNS contains a wonderful, underused facility called ALIAS records. Make an alias called prod_box (hmmm - that's a bit rude) and make it "point" to the current production box. All SQLHOSTS and desktop icon names should then refer to prod_box instead of dfcncux01. If you ever need to move anything to another machine, you merely need to change the alias record and no client will ever be the wiser. Also, even if you currently have the database on the same machine that the desktop icons (4JS?) connect to, it's worth making a separate alias for the application server vs. the engine server. One day you might choose or be forced to have the engine on a separate machine from the applications, so once again, it can be very useful to move the engine access but leave access to the executables on the original machine. ALIAS records can be used for all sorts of things: mail servers, web servers, jabber servers, engines, application servers, ..... Not using ALIAS records is akin to not using symbolic links for your raw chunks.
"Andrew Hamm" <ahamm@mail.com> wrote in message news:bu4g4s$dv5a4$1@ID-79573.news.uni-berlin.de... > "Five Cats" <cats_spam@[127.0.0.1]> wrote ... > > > Make an alias called prod_box (hmmm - that's a bit rude) and make it "point" > to the current production box. All SQLHOSTS and desktop icon names should > then refer to prod_box instead of dfcncux01. Hmmm, that's a bit rude too. Almost. > If you ever need to move > anything to another machine, you merely need to change the alias record and > no client will ever be the wiser. Nor better informed.
"Captain Pedantic" <theharlequin36@hotmail.com> wrote ... > > then refer to prod_box instead of dfcncux01. > > Hmmm, that's a bit rude too. Almost. Actually it is. I despise naming conventions like that. A free lollypop for the first person to correctly guess what the letters mean.
On Wed, 14 Jan 2004 18:36:25 -0500, Andrew Hamm wrote: > "Captain Pedantic" <theharlequin36@hotmail.com> wrote ... >> > then refer to prod_box instead of dfcncux01. >> >> Hmmm, that's a bit rude too. Almost. > > Actually it is. I despise naming conventions like that. A free lollypop for > the first person to correctly guess what the letters mean. Hmm: df - default cnc - connection ux - Unix 01 - first one How's that? I like cherry. Art S. Kagel
Art S. Kagel wrote: > > Hmm: > > df - default > cnc - connection > ux - Unix > 01 - first one > > How's that? I like cherry. :-)) That's so sweet. I think you missed the "rude" factor...
On Thu, 15 Jan 2004 18:20:25 -0500, Andrew Hamm wrote: > Art S. Kagel wrote: >> >> Hmm: >> >> df - default >> cnc - connection >> ux - Unix >> 01 - first one >> >> How's that? I like cherry. > > :-)) > > That's so sweet. I think you missed the "rude" factor... When have I ever been rude? Art S. Kagel
Art S. Kagel wrote: > > When have I ever been rude? True, but One Day we'll corrupt you.
Related threads
- Re: Oracle V Informix
- Re: Performance advice
- SP, Is this you? (was: Creating a view with subscripting)
- Re: How long a future? (was: An interesting meeting with IBM)