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

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: > 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

Thanks Martin & Floyd. Martin, now it make sense after your clear explanation. Thanks again.