2 Databases
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