RE: onbar catalog files slowly filling up

You did not mention your Informix release and platform. I use a script which performs deletion for IDS 7.31.UC3. It had to be changed from the one which I used for IDS 7.30.UC7XK. The structure of the sysutils database changes depending upon your release level. IDS.2000 contains an "onsmsync" utility which is supposed to synchronize the sysutils database with you Storage manager. The release notes for earlier releases contain recommendations on how to delete some rows from the bar_* tables. > -----Original Message----- > From: java44@my-deja.com [mailto:java44@my-deja.com] > Sent: Tuesday, November 30, 1999 07:27 > To: informix-list@iiug.org > Subject: onbar catalog files slowly filling up > > > Need some info if anyone has run into this before. Presently > we have three onbar catalog tables growing steadily: bar_object, > bar_action, bar_instance. Informix has no policy regarding > the growth of > these tables. > > Now, we really only need to keep 3 months worth of information here. > Just curious if anyone has truncated these tables, and seen any side > effects, or if anyone has a methodology for doing this that is safe. > > > Thanks, > Richard > > > Sent via Deja.com http://www.deja.com/ > Before you buy. >

You may also want to remove entries in the ixbar.# file, located in the $INFORMIXDIR/etc directory. It contains 1 row for every object backed up. It is used for cold restores. You could write a shell script, to trim it back, or manually remove the entries. Bernstein, Rick wrote: > > You did not mention your Informix release and platform. > I use a script which performs deletion for IDS 7.31.UC3. > It had to be changed from the one which I used for IDS 7.30.UC7XK. > > The structure of the sysutils database changes depending upon > your release level. IDS.2000 contains an "onsmsync" utility which > is supposed to synchronize the sysutils database with you > Storage manager. The release notes for earlier releases contain > recommendations on how to delete some rows from the bar_* tables. > > > > -----Original Message----- > > From: java44@my-deja.com [mailto:java44@my-deja.com] > > Sent: Tuesday, November 30, 1999 07:27 > > To: informix-list@iiug.org > > Subject: onbar catalog files slowly filling up > > > > > > Need some info if anyone has run into this before. Presently > > we have three onbar catalog tables growing steadily: bar_object, > > bar_action, bar_instance. Informix has no policy regarding > > the growth of > > these tables. > > > > Now, we really only need to keep 3 months worth of information here. > > Just curious if anyone has truncated these tables, and seen any side > > effects, or if anyone has a methodology for doing this that is safe. > > > > > > Thanks, > > Richard > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > >

IDS 7.24UC1 and 7.31UC2 on AIX 4.3.2. Sorry about that :) As of now my plan is to archive the past information then delete it from the tables and IXBAR file. I'm going to create a script that automates this. It'd be nice if Informix had taken care of this. -Richard In article <8210rl$q0k$1@news.xmission.com>, "Bernstein, Rick" <rbernste@alarismed.com> wrote: > > You did not mention your Informix release and platform. > I use a script which performs deletion for IDS 7.31.UC3. > It had to be changed from the one which I used for IDS 7.30.UC7XK. > > The structure of the sysutils database changes depending upon > your release level. IDS.2000 contains an "onsmsync" utility which > is supposed to synchronize the sysutils database with you > Storage manager. The release notes for earlier releases contain > recommendations on how to delete some rows from the bar_* tables. > > > -----Original Message----- > > From: java44@my-deja.com [mailto:java44@my-deja.com] > > Sent: Tuesday, November 30, 1999 07:27 > > To: informix-list@iiug.org > > Subject: onbar catalog files slowly filling up > > > > > > Need some info if anyone has run into this before. Presently > > we have three onbar catalog tables growing steadily: bar_object, > > bar_action, bar_instance. Informix has no policy regarding > > the growth of > > these tables. > > > > Now, we really only need to keep 3 months worth of information here. > > Just curious if anyone has truncated these tables, and seen any side > > effects, or if anyone has a methodology for doing this that is safe. > > > > > > Thanks, > > Richard > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > > Sent via Deja.com http://www.deja.com/ Before you buy.