Re: Hi

"Stephen F. Cawley" wrote: > > An instance can be thought of as single database (development, test, > production, ...). A server is the hardware device, and you can have > several instances configures on it (see multiple residency in the admin > guide). There is a one-to-many relationship between a server and its > instances. > > SC > > > Hi, > > > > What is the difference between an instance and a server ? > > > > Regs, > > Rajesh Well yes, but if he meant database server, then it could be as you say a machine, or an instance or a particular version or type of database engine software. ;-) If you follow the terminology used by Informix for setting up multiple instances, then a database server (DBSERVER) is an instance or at least an alias to an instance via a particular communication protocol. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+