Re: Level 0 archive info. from onstat
Posted in 2006
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