ontape backup question

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.