Re: Two databases, same name, same machine
Posted in 1997
In article <32ec52db.2646088@196.22.64.66>, <brinama@compans.com> wrote: >What I would like to know is can I run two seperate databases with the >same name on the same machine under Online 5 >Both databases will have exactly the same tables, applications, stored >procs etc, but will hold two distinct sets of data - 2 different >companies. Set up another instance of informix on the machine. >Also, any ideas as to how system performance might be affected Two instances suck up 2X the resources, might be better to look at your app to remove hard coded references to database name. Use a variable or config file or something. An identical database name in the same instance is such a violation of data integrity that I know of no product that offers this 'feature'.