2 Databases
Alvin Palacios asked whether two databases with the same name can exist in one Informix instance. Greg Dewinter said no. Thomas Parsli suggested different names or two instances. Richard Thomas raised hard-coded names in third-party applications for test setups, and David Williams said to have the vendor make the name configurable. The consensus was no.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
This is a multi-part message in MIME format. --------------CF5199BF62D2957E76F42C44 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Informixsers, Is it possible to have 2 databases (same name) on a single informix instance ? How would you do this ? Alvin --------------CF5199BF62D2957E76F42C44 Content-Type: text/x-vcard; charset=us-ascii; name="alpalaci.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Alvin Palacios Content-Disposition: attachment; filename="alpalaci.vcf" begin:vcard n:Palacios;Alvin tel;fax:+63 2 552 8765 tel;work:+63 2 552 8872 x-mozilla-html:FALSE org:DHL Aviation Philippines Inc. version:2.1 email;internet:alpalaci@mnl-hub.dhl.com title:Sr. Applications Specialist adr;quoted-printable:;;Hangar A 410th W.C.=0D=0APAF Villamor Air Base;Pasay City;;1309;Philippines x-mozilla-cpt:;23808 fn:Alvin Palacios end:vcard --------------CF5199BF62D2957E76F42C44--
Alvin Palacios <alpalaci@mnl-hub.dhl.com> writes: > This is a multi-part message in MIME format. > --------------CF5199BF62D2957E76F42C44 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > > Informixsers, > > Is it possible to have 2 databases (same name) on a single informix > instance ? And how should Informix know which database you where thinking on? > How would you do this ? I wouldn't... Is there any reason why they cant't have names like database_1 and database_2? (And if there is you could run two instances on the same server, they can of cource have the same content [with ie. replication?]) > > Alvin > > --------------CF5199BF62D2957E76F42C44 > Content-Type: text/x-vcard; charset=us-ascii; Please don't use vcard in news-groups, it's ok in mail though (as long as I don't recieve it:) Thomas
No, and why would you want to do this? Greg Alvin Palacios wrote: > This is a multi-part message in MIME format. > --------------CF5199BF62D2957E76F42C44 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Informixsers, > > Is it possible to have 2 databases (same name) on a single informix > instance ? How would you do this ? > > Alvin > > --------------CF5199BF62D2957E76F42C44 > Content-Type: text/x-vcard; charset=us-ascii; > name="alpalaci.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Alvin Palacios > Content-Disposition: attachment; > filename="alpalaci.vcf" > > begin:vcard > n:Palacios;Alvin > tel;fax:+63 2 552 8765 > tel;work:+63 2 552 8872 > x-mozilla-html:FALSE > org:DHL Aviation Philippines Inc. > version:2.1 > email;internet:alpalaci@mnl-hub.dhl.com > title:Sr. Applications Specialist > adr;quoted-printable:;;Hangar A 410th W.C.=0D=0APAF Villamor Air Base;Pasay City;;1309;Philippines > x-mozilla-cpt:;23808 > fn:Alvin Palacios > end:vcard > > --------------CF5199BF62D2957E76F42C44--
Yes you can.
In Informix, a database is a logical collection of tables.
create database accounting in dbspace1;
create database human_resources in dbspace2;
On our system, we have two main databases, where the information is
logically divided, but able to be accessed through 4GL reporting.
John Carlson
Informix DBA
WHSmith USA
Alvin Palacios wrote:
>
> This is a multi-part message in MIME format.
> --------------CF5199BF62D2957E76F42C44
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Informixsers,
>
> Is it possible to have 2 databases (same name) on a single informix
> instance ? How would you do this ?
>
> Alvin
>
> --------------CF5199BF62D2957E76F42C44
> Content-Type: text/x-vcard; charset=us-ascii;
> name="alpalaci.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Alvin Palacios
> Content-Disposition: attachment;
> filename="alpalaci.vcf"
>
> begin:vcard
> n:Palacios;Alvin
> tel;fax:+63 2 552 8765
> tel;work:+63 2 552 8872
> x-mozilla-html:FALSE
> org:DHL Aviation Philippines Inc.
> version:2.1
> email;internet:alpalaci@mnl-hub.dhl.com
> title:Sr. Applications Specialist
> adr;quoted-printable:;;Hangar A 410th W.C.=0D=0APAF Villamor Air Base;Pasay City;;1309;Philippines
> x-mozilla-cpt:;23808
> fn:Alvin Palacios
> end:vcard
>
> --------------CF5199BF62D2957E76F42C44--
On Wed, 06 Oct 1999 07:21:29 -0400, Greg Dewinter <gdewinter@spf.fairchildsemi.com> wrote: >No, and why would you want to do this? > >Greg What if your third party application has its database name hard-coded, and you want to set up a test environment, but don't have the resources (memory, disk etc) to run two informix instances on your production machine, and you don't have a spare server. (Answer: Get out of there as soon as you can find an employer that will value you and your skills more than your present one.) Richard.
In article <37fb561d.18655223@nflintra>, Richard Thomas <binbag@starjump.org> writes >On Wed, 06 Oct 1999 07:21:29 -0400, Greg Dewinter ><gdewinter@spf.fairchildsemi.com> wrote: > >>No, and why would you want to do this? >> >>Greg > >What if your third party application has its database name hard-coded, >and you want to set up a test environment, but don't have the >resources (memory, disk etc) to run two informix instances on your >production machine, and you don't have a spare server. > Get the third party to make the database name configurable.. >(Answer: Get out of there as soon as you can find an employer that >will value you and your skills more than your present one.) > >Richard. -- David Williams