Hmm, I am wondering if there is a terminology issue here.

Informix instances can have more than one DB.
Oracle instances have only one DB.

(At least that is what they said in the Oracle DBA 101 class I went to
years ago...so be kind if I am wrong)

But you can also have multiple instances of Informix on the same box.
Meaning multiple shared memory structures, different
onconfigs/servernames...egads this is hard to explain in an email.

Abanero, is this making sense?
Do you have one Informix instance (memory, onconfig etc) with multiple
DB's in it, or do you have
multiple instances that each have their own collection of databases, etc
in it?

-----Original Message-----
From: Neil Truby [mailto:neil.truby@ardenta.com]
Sent: Friday, May 21, 2004 4:15 AM
To: informix-list@iiug.org
Subject: Re: ontape Info


"Abanero" <abanero@supereva.it> wrote in message
news:ad9fb198.0405202354.554fe1b4@posting.google.c om...
> "Neil Truby" <neil.truby@ardenta.com> wrote in message
news:<2h47atF8lir0U1@uni-berlin.de>...
> > You've backed up all databases in ONE instance - the instance
defined by
the
> > INFORMIXSERVER environment variable of the session you used to
execute
the
> > ontape utility.
>
> Thanks to all, just to understand, my informix database has 4
> instances, with command:
>
> ontape -s -L 0.
>
> I have backed up all databases in ONE nistance. This means if I
> restore database from Tape I lose all instances and only one istance
> are restore?

No. You have backed up one instance. If you restore from that tape you
will restore just that instance. The others will not be affected.
In order to back up the other three instances, or restore them, you
would
need to set the INFORMIXSERVER environment variable to some other
appropriate value.


sending to informix-list