Re: What is in the name ?

From: tqma@my-deja.com > >Would someone please explain what are the >relationship/difference among: > >DBSERVERNAME, >INFORMIXSERVER, and >hostname INFORMIXSERVER points to an entry in your sqlhosts and the DBSERVERNAME or DBSERVERALIASES entries in the onconfig file. It allows you to, for example, quickly change between shared memory and TCP connections on your local machine or to switch to a connection on another machine. These refer to an instance of Informix running on a particular host (you can have many running on a single host) HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

In article <82oird$9eb$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: tqma@my-deja.com > > > >Would someone please explain what are the > >relationship/difference among: > > > >DBSERVERNAME, > >INFORMIXSERVER, and > >hostname > > INFORMIXSERVER points to an entry in your sqlhosts and the DBSERVERNAME or> DBSERVERALIASES entries in the onconfig file. It allows you to, for example, > quickly change between shared memory and TCP connections on your local > machine or to switch to a connection on another machine. > > These refer to an instance of Informix running on a particular host (you can > have many running on a single host) So, if I have just one instance of Informix runing on a host then all these names can point to the same name, the hostname ? Thanh Sent via Deja.com http://www.deja.com/ Before you buy.

tqma@my-deja.com schrieb: > > INFORMIXSERVER points to an entry in your sqlhosts and the > DBSERVERNAME or> > DBSERVERALIASES entries in the onconfig file. It allows you to, for > example, > > quickly change between shared memory and TCP connections on your > local > > machine or to switch to a connection on another machine. > > > > These refer to an instance of Informix running on a particular host > (you can > > have many running on a single host) > > So, if I have just one instance of Informix runing on a host > then all these names can point to the same name, the hostname ? Thanh, in "Informix speak", a "server" is an instance of an Informix database engine running on a specific machine, called the "host". "DBSERVERNAME" is the name of the server. It is an entry in the "onconfig" configuration file which uniquely names an instance on this host. Under "DBSERVERALIASES" you can give your instance one or more alias names, which are needed if your instance can be reached via different protocols, e.g. shared memory and tcp/ip. For each entry in "DBSERVERNAME" and "DBSERVERALIASES", there must be a corresponding entry in the "sqlhosts" file which specifies which server can be reached on which host via which protocol. The "hostname" is one of the parameters in the "sqlhosts" file. It specifies the network name of the machine the engine is running on. You really should read up on this file in the manual. The "INFORMIXSERVER" environment variable is used to specify which engine the frontends should actually use. This is used to lookup the parameters for engine access in the "sqlhosts" file. Hope this helps, Richard -- +--------------------------+------------------------------------------+ | Dr. med Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | | Klinikum Grosshadern | FAX : +49-89-7095-6420 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+

tqma@my-deja.com wrote: > > In article <82oird$9eb$1@news.xmission.com>, > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > > > From: tqma@my-deja.com > > > > > >Would someone please explain what are the > > >relationship/difference among: > > > > > >DBSERVERNAME, > > >INFORMIXSERVER, and > > >hostname > > > > INFORMIXSERVER points to an entry in your sqlhosts and the > DBSERVERNAME or> > DBSERVERALIASES entries in the onconfig file. It allows you to, for > example, > > quickly change between shared memory and TCP connections on your > local > > machine or to switch to a connection on another machine. > > > > These refer to an instance of Informix running on a particular host > (you can > > have many running on a single host) > > So, if I have just one instance of Informix runing on a host > then all these names can point to the same name, the hostname? Umm, the quick and dirty answer is yes. I'd qualify that by saying you probably should not have the servername the same as the hostname just because you will start to hardcode the servername, as bad as that is, in your code here and there and if one day you mode that server to another host you will then not feel compelled to rename the server thereby causing jobs to fail mysteriously. Similarly if you need to bring up a second server instance on that host your naming scheme is blown also. I prefer to name server instances after the set of databases that they serve. Art S. Kagel Art S. Kagel

Richard and The Clown, Thanks for taking the time to explain. It does help. Thanh In article <3850C098.598D0703@ana.med.uni-muenchen.de>, richard.spitz@ana.med.uni-muenchen.de wrote: > tqma@my-deja.com schrieb: > > > > INFORMIXSERVER points to an entry in your sqlhosts and the > > DBSERVERNAME or> > > DBSERVERALIASES entries in the onconfig file. It allows you to, for > > example, > > > quickly change between shared memory and TCP connections on your > > local > > > machine or to switch to a connection on another machine. > > > > > > These refer to an instance of Informix running on a particular host > > (you can > > > have many running on a single host) > > > > So, if I have just one instance of Informix runing on a host > > then all these names can point to the same name, the hostname ? > > Thanh, > > in "Informix speak", a "server" is an instance of an Informix database > engine running on a specific machine, called the "host". > > "DBSERVERNAME" is the name of the server. It is an entry in the > "onconfig" configuration file which uniquely names an instance on > this host. Under "DBSERVERALIASES" you can give your instance > one or more alias names, which are needed if your instance can be > reached via different protocols, e.g. shared memory and tcp/ip. > > For each entry in "DBSERVERNAME" and "DBSERVERALIASES", there > must be a corresponding entry in the "sqlhosts" file which > specifies which server can be reached on which host via which > protocol. > > The "hostname" is one of the parameters in the "sqlhosts" file. It > specifies the network name of the machine the engine is running > on. You really should read up on this file in the manual. > > The "INFORMIXSERVER" environment variable is used to specify which > engine the frontends should actually use. This is used to lookup the > parameters for engine access in the "sqlhosts" file. > > Hope this helps, > Richard > -- > +--------------------------+------------------------------------------ + > | Dr. med Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | > | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | > | Klinikum Grosshadern | FAX : +49-89-7095-6420 | > | 81366 Munich, Germany | GSM : +49-172-8933578 | > +--------------------------+------------------------------------------ + > Sent via Deja.com http://www.deja.com/ Before you buy.