Nothing concetual here, and why pretend?
The archive will be an exact copy of the database at the instant
the ontape command is issued (well a few seconds later as it
needs to take a checkpoint first). Any transactions after this
time will not be on the archive, however they will be in the
logical logs (which are being backup up to disk or tape aren't
they ??!!). These can be applied to the database in the event
of a restore in order to get an up-to-date database back.
This is how it was, is now and probably always will be.

Keith


-> -----Original Message-----
-> From: natebsi@gmail.com [mailto:natebsi@gmail.com]
-> Sent: Monday, June 05, 2006 4:11 PM
-> To: informix-list@iiug.org
-> Subject: Conceptual Ontape Question
->
->
-> Lets pretend, shall we?
->
-> 1. Users are actively using the system, entering data and what-not.
->
-> 2. Level 0 ontape is started at 4:30pm.
->
-> 3. All users are logged off at 5:30pm.
->
-> 4. Ontape completes successfully at 5:45pm.
->
->
-> Question:
->
-> Was all of the data backed up? Or was some data potentially missed
-> since users were entering data for that 45 minute period that ontape
-> was running?
->
-> I say the latter, but now I'm hearing that ontape would have
-> picked up
-> everything.
->
-> Anyone know the correct answer?
->
-> Thanks!
->
-> _______________________________________________
-> Informix-list mailing list
-> Informix-list@iiug.org
-> http://www.iiug.org/mailman/listinfo/informix-list
->

************************************************** *********************************************
This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission.

This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this messageis free from such problems.
************************************************** *********************************************

Lol, no sense of humor on a Monday morning eh?

My belief was like yours, which is the way it works with most RDBMS's
that allow hot backups, ala Oracle. I just wanted to confirm since this
question came up last week.

And yes, the logs are always backed up to tape for all prod instances.

Thanks for the response,

Nate


Simmons, Keith wrote:
> Nothing concetual here, and why pretend?
> The archive will be an exact copy of the database at the instant
> the ontape command is issued (well a few seconds later as it
> needs to take a checkpoint first). Any transactions after this
> time will not be on the archive, however they will be in the
> logical logs (which are being backup up to disk or tape aren't
> they ??!!). These can be applied to the database in the event
> of a restore in order to get an up-to-date database back.
> This is how it was, is now and probably always will be.
>
> Keith
>
>
> -> -----Original Message-----
> -> From: natebsi@gmail.com [mailto:natebsi@gmail.com]
> -> Sent: Monday, June 05, 2006 4:11 PM
> -> To: informix-list@iiug.org
> -> Subject: Conceptual Ontape Question
> ->
> ->
> -> Lets pretend, shall we?
> ->
> -> 1. Users are actively using the system, entering data and what-not.
> ->
> -> 2. Level 0 ontape is started at 4:30pm.
> ->
> -> 3. All users are logged off at 5:30pm.
> ->
> -> 4. Ontape completes successfully at 5:45pm.
> ->
> ->
> -> Question:
> ->
> -> Was all of the data backed up? Or was some data potentially missed
> -> since users were entering data for that 45 minute period that ontape
> -> was running?
> ->
> -> I say the latter, but now I'm hearing that ontape would have
> -> picked up
> -> everything.
> ->
> -> Anyone know the correct answer?
> ->
> -> Thanks!
> ->
> -> _______________________________________________
> -> Informix-list mailing list
> -> Informix-list@iiug.org
> -> http://www.iiug.org/mailman/listinfo/informix-list
> ->
>
> ************************************************** *********************************************
> This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission.
>
> This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems.
> ************************************************** *********************************************