ontape backup question
Paulo Rafael Padilla, using IDS 9.40 FC9 with weekly level 0 and daily level 1 ontape backups, saw a level 1 grow above 50 percent over a quiet weekend. Bob Roussey suggested a large table took another extent, checkable with oncheck -pe. Obnoxio The Clown said the backup covers allocated, not changed, space. Paulo found several tables near new extents. Explained.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi all,
I get IDS 9.40 FC9 on solaris 8
I execute a Level 0 backup weekly and I execute a Level 1 every day. All this
with ontape.
Normally backup level 1 grows a 25 % before I get another Level 0. Weekend
there are a little activity on instance.
Last weekend my backup Level 1 grew up to more than 50 %.
I checked up daily onstat -p. I compared inserts delete and updates activity
from Friday to Saturday and from Thursday to Friday. Thursday to Friday had
more activity and backup Level 1 grew less than Friday to Saturday that had
much less activity.
What can I check to find what it is causing this suddenly growing?
Regards
Maybe a large table grabbed another extent. You can check with "oncheck -pe
db_name" I believe.
--
Bob
-------------- Original message --------------
From: "PAULO RAFAEL PADILLA" <rafaelpadilla@grupomayan.com>
> Hi all,
>
> I get IDS 9.40 FC9 on solaris 8
>
> I execute a Level 0 backup weekly and I execute a Level 1 every day. All this
> with ontape.
>
> Normally backup level 1 grows a 25 % before I get another Level 0. Weekend
> there are a little activity on instance.
>
> Last weekend my backup Level 1 grew up to more than 50 %.
>
> I checked up daily onstat -p. I compared inserts delete and updates activity
> from Friday to Saturday and from Thursday to Friday. Thursday to Friday had
> more activity and backup Level 1 grew less than Friday to Saturday that had
> much less activity.
>
> What can I check to find what it is causing this suddenly growing?
>
> Regards
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
PAULO RAFAEL PADILLA wrote:
> Hi all,
>
> I get IDS 9.40 FC9 on solaris 8
>
> I execute a Level 0 backup weekly and I execute a Level 1 every day. All this
> with ontape.
>
> Normally backup level 1 grows a 25 % before I get another Level 0. Weekend
> there are a little activity on instance.
>
> Last weekend my backup Level 1 grew up to more than 50 %.
>
> I checked up daily onstat -p. I compared inserts delete and updates activity
> from Friday to Saturday and from Thursday to Friday. Thursday to Friday had
> more activity and backup Level 1 grew less than Friday to Saturday that had
> much less activity.
>
> What can I check to find what it is causing this suddenly growing?
Informix doesn't back up everything that is recorded, it backs up
everything that is ALLOCATED. My best guess is that you've had one or
more large extents added when the backup grew.
--
Cheers,
Obnoxio The Clown
http://obotheclown.blogspot.com
Good comments guys. I realized that I had several tables near to use a new extent. I'll check it up.