Eliminating Onbar archive history

Does anyone have a process in place to eliminate rows from the sysutils tables based on keeping a set number of onbar database backups (say, 3) and identifying/eliminating unneeded database backups and log backups?? Trying to set up SIMPLE procedures for using Onbar/ADSM. TIA Doug Agnew

Doug, We're running IDS V7.30.UC2 on HP-UX 10.20. In $INFORMIXDIR/release/en_us/0333/ONBARDOC_7.3 it provides a sample script to remove old backup history from the sysutils database. It includes the SQL to delete the data. Of course the standard disclaimer applies. I would advise backing up the data by unloading it to flat file before deleting it from the tables. In article <oF2p2.2023$Dc2.2657966@news4.mco>, "Doug Agnew" <dagnew@charlottepipe.com> wrote: > Does anyone have a process in place to eliminate rows from the sysutils > tables based on keeping a set number of onbar database backups (say, 3) and > identifying/eliminating unneeded database backups and log backups?? > > Trying to set up SIMPLE procedures for using Onbar/ADSM. > > TIA > > Doug Agnew > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

In article <oF2p2.2023$Dc2.2657966@news4.mco>, Doug Agnew <dagnew@charlottepipe.com> writes >Does anyone have a process in place to eliminate rows from the sysutils >tables based on keeping a set number of onbar database backups (say, 3) and >identifying/eliminating unneeded database backups and log backups?? > >Trying to set up SIMPLE procedures for using Onbar/ADSM. > Check the release notes for Online under $INFORMIXDIR/release/en_us/0333/SERVERS* there may be something there... >TIA > >Doug Agnew > > -- David Williams