Go Back   Rhinocerus > Newsgroup > Newsgroup comp.databases.* > Newsgroup comp.databases.informix

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 05-23-2012, 08:41 AM
Francesco Veroni
Guest
 
Posts: n/a
Default Multiple port configuration in the sqlhosts file

In a very old training doc I found this:
http://dl.dropbox.com/u/3605787/sqlhosts.JPG

I would ask: what kind of sense have to configure more than 1 hostname
in the sqlhosts for the same istance? Where my application will be
redirected? On the first host (sales) or on the second (accounting)?
Reply With Quote
Alt Today
Advertising
 
and become member of Rhinocerus
Standard Sponsored Links

  #2 (permalink)  
Old 05-24-2012, 08:00 AM
Martin Fuerderer
Guest
 
Posts: n/a
Default Re: Multiple port configuration in the sqlhosts file

Hi Francesco,

it's called "Wildcard adressing for TCP/IP connections".
It allows the database server on a machine with more than
one network interface cards to accept connections from
clients on each network interface card (with the same port
number). The wildcard in the sqlhosts file is relevant only
for the server. A client ignores the wildcard.

I think a better description of this (than in the old manual
where you found the picture) is in the current "Informix
Administrator's Guide" -> "Chapter 3: Client/server
communications" -> "The sqlhosts information" ->
"Alternatives for TCP/IP connections" -> "Wildcard
addressing for TCP/IP connections".
Or look at:
http://publib.boulder.ibm.com/infoce...admin_0194.htm

Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

Read about the Informix Warehouse Accelerator:
http://tinyurl.com/the-iwa-blog

IBM Deutschland Research & Development GmbH
Chairman of the Supervisory Board: Martina Koederitz
Board of Management: Dirk Wittkopp
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

informix-list-bounces@iiug.org wrote on 05/23/2012 10:41:31 AM:
>
> In a very old training doc I found this:
> http://dl.dropbox.com/u/3605787/sqlhosts.JPG
>
> I would ask: what kind of sense have to configure more than 1 hostname
> in the sqlhosts for the same istance? Where my application will be
> redirected? On the first host (sales) or on the second (accounting)?
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>


Reply With Quote
  #3 (permalink)  
Old 05-25-2012, 07:43 AM
Francesco Veroni
Guest
 
Posts: n/a
Default Re: Multiple port configuration in the sqlhosts file

Many thanks for the clear reply, Martin!
Francesco
Reply With Quote
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




All times are GMT. The time now is 05:17 PM.


Copyright ©2009

LinkBacks Enabled by vBSEO 3.3.0 RC2 © 2009, Crawlability, Inc.