All 5 messages in topic - view as tree
From: har...@yahoo.com - view profile
Date: Wed, Nov 29 2006 12:29 am
Email: har...@yahoo.com
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
Reply » Rate this post: Text for clearing space
From: Martin Fuerderer - view profile
Date: Wed, Nov 29 2006 11:57 am
Email: Martin Fuerderer
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-boun...@iiug.org wrote on 28.11.2006 23:29:52:
- Hide quoted text -
- Show quoted text -
> 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-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
Reply » Rate this post: Text for clearing space
From: Floyd Wellershaus - view profile
Date: Wed, Nov 29 2006 2:02 pm
Email: Floyd Wellershaus
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.
========================
-<
Database Administrator
Unix Administrator
email: fwell...@yahoo.com
Home: 703-430-0805
Cell: 703-477-6045
========================
http://www.one.org/
- Hide quoted text -
- Show quoted text -
----- Original Message ----
From: "har...@yahoo.com"
To: informix-l...@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-l...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Reply » Rate this post: Text for clearing space
From: har...@yahoo.com - view profile
Date: Thurs, Nov 30 2006 12:16 am
Email: har...@yahoo.com
Thanks Martin & Floyd.
Martin, now it make sense after your clear explanation. Thanks again.
Reply » Rate this post: Text for clearing space
From: TBP - view profile
Date: Fri, Dec 1 2006 12:45 pm
Email: TBP
Floyd Wellershaus wrote:
> 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.
There are several timestamps here from several different entities, but
the critical one, as pointed out, is the Archive Checkpoint timestamp.
From the online.log you should see a timestamp for when an archive
starts (for the single dbspace being backed up or the whole instance)
From onstat -g arc you should see the same timestamp for dbspace(s).
From the ixbar.
the archive checkpoint, as this is what is used to work out what is
needed for point in time restores.
Reply » Rate this post: Text for clearing space
End of messages
No comments:
Post a Comment