Instance Tradeoff

Posted in 1997

Herb Blacker — 17 Jul 1997 13:23:24 -0400 — source: Informix-list mailing list archive (1991-1998)

I'm going to be putting six or seven databases on the same machine (IBM RS/6000 w/4 SMP CPU's and AIX running Informix v7.2x). My question is: what are the tradeoffs between putting each database in its own instance, vs. putting them all in the same instance. I will need to run reports from more than one of these databases concurrently (i.e. select ... from db1:xxx, db2:yyy etc.). Are there any white papers on this in the iiug site? I've taken the DBA courses, but this wasn't mentioned. ------------------------------------------------------------------------- Herb Blacker Cimarron, Inc. Database Administrator - DOL Job Corps, San Marcos, Texas ------------------------------------------------------------------------