Hi,

your version of IDS is (quite) old. There have been several fixes for
such things in newer versions (most notably IDS 10.00.xCx).

What may be the case with your version: the time you see in
the onstat output may be (inadvertedly) some time from the
storage manager. :-(
I'm not really sure about this and I don't want to spend any
time on testing this with such an old version. I would say
that the time you see in the online.log has more practical
relevance to you than the time in the output of "onstat -g arc".

[ Actually the really relevant time for a dbspace backup is
 the time of the archive checkpoint that is done for the
 dbspace. Because this is the time when the dbspace was
 physically consistent. And with that it is the time that will
 determine, where logical recovery has to start (for that
 dbspace). But this is more of an internal time keeping.
 With current versions of IDS this is, what is displayed in
 the "onstat -g arc" and what is kept in the root reserved
 pages ("oncheck -pr" to check these).
]

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

Informix URLs list: http://home.arcor.de/mfu1/informix/urls.html

informix-list-bounces@iiug.org wrote on 28.11.2006 23:29:52:

I just checked my onstat -g arc, running 9.4FC3 on aix5.3.
For all of our dbspaces it shows the time the archive BEGAN.
It's the same time that is shown in the bar_act.log for the instance.
We are doing a whole system backup.



========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator

email:           fwellers@yahoo.com

Home:          703-430-0805

Cell:             703-477-6045
========================

http://www.one.org/

----- Original Message ----
From: "hariog@yahoo.com" <hariog@yahoo.com>
To: informix-list@iiug.org
Sent: Tuesday, November 28, 2006 5:29:52 PM
Subject: Level 0 archive info. from onstat

Greeting All,

HP-UX B.11.11 U 9000/800
IDS 9.21.HC2

Though it's not an issue but it is bugging me on & off. I am sure some
one here will be able to explain this.

We have got 4 dbspaces as rootdbs, llogdbs, plogdbs, superdbs. We do
level 0 archive every night. superdbs dbspace contain data and DB size
is about 37 GB.Usually level 0 archive finishes by 8:00 AM. We use
onbar.

There is always inconsistancy in completion time when looking at online
log and "onstat -g arc"

Example:

This morning's online log indicate level 0 archive completion time as:

07:50:13  Archive on superdbs Completed.

and onstat -g arc indicate as:

Dbspaces - Archive Status

name               number level date             log
log-position
rootdbs            1      0     11/29/2006.08:30 33478      0x3e018

superdbs           2      0     11/29/2006.08:30 33478      0x3e018

llogdbs            4      0     11/29/2006.08:30 33478      0x3e018

plogdbs            5      0     11/29/2006.08:30 33478      0x3e018

As you can see online log indicate time as 7:50 AM where as onstat is
reporting 8:30. Why ?

TIA

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list