Re: Onbar & Continous Logging.

Robertson Lee NTSE wrote: > > All, > We have recently upgraded our Informix to 7.23 UC4 and as such are going > to take advantage of ONBAR nd finally rid ourselves of the nightmare > that is ONARCHIVE. > In onarchive you can set expiry dates for logical logs which expires > them from the catalog and subsequently from disk thus avoiding > filesystem full messages. My question is can a similar operation be > performed with ONBAR or does this clean up have to be done manually via > scripts etc. > Apologies if this is very basic stuff but I haven't been on any courses > yet and I can't find any reference to it in the manual. > > Regards > > Lee > > Lee Robertson > Oracle DBA > Siemens Microelectronics Ltd > Tel 0191-2804037 Hi! There is a very good thing (i think), you can use called automatic backup of logical logs. Turn on the script $INFORMIXDIR/etc/log_full.sh as ALARMPROGRAM in your onconfig. Be sure that LTAPEDEV is not set to /dev/null. Then every time a logical log becomes full and a log switch is made, Informix does a onbar -l to backup this logical log. Do you do your log. log backups to disk? How to manage expiration dates of archives is the job of the storage manager you use with onbar. You can't set anthing like this within onbar. There is a manual called Backup an Restore Guide (a very smal one) that discribes the features of onbar. HTH Tini