Re: Informix logfiles truncating

Set your LTAPEDEV to /dev/null? From: "Valeriy Tsuryk" <valery@quikcat.com> > >We developing distributed client-server application and we using > >Informix Dynamic Server Workgroup Edition 7.3... on UnixWare 7.1.1. > >Our database uses transaction logging. > >Our database has couple static tables with customers information > >and several tables with dynamic data. Amount of static data is not > >big and data can be backuped for example once per week or when > >operator will decide to do it. Dynamic data should not be backuped > >anyway. > >But in our system dynamic data changes every several minutes. It > >cause a fast growing of logfiles, and every two - three days > >Informix stops and waits while we backup logfiles. While Informix > >waiting for backup users of our system can't work. Increasing of > >logfiles size can only postpone this situation. > >We want to give our customers possibility to evaluate our software. > >During this evaluation we do not suppose to backup any data and we > >do not want to worry about logfiles at all. We want to have some > >'black box' which can be started once and work without any service > >and operator's actions. We understand and accept that in case if > >something will happened with database it will be impossible to > >restore data. > >How can we tune Informix Server to truncate / reuse / automatically > >backup logfiles ? > >Are there another solutions to avoid problem with continuous logfiles >backup >? > > > >Thanks for help! > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Sorry for one more question. As far as I can understand even if I will have LTAPEDEV as /dev/null I should schedule ontape -.... or something else in order to wipe out log dbspace? "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:8kk35u$hmk$1@news.xmission.com... > > Set your LTAPEDEV to /dev/null? > > From: "Valeriy Tsuryk" <valery@quikcat.com> > > > >We developing distributed client-server application and we using > > > >Informix Dynamic Server Workgroup Edition 7.3... on UnixWare 7.1.1. > > > >Our database uses transaction logging. > > > >Our database has couple static tables with customers information > > > >and several tables with dynamic data. Amount of static data is not > > > >big and data can be backuped for example once per week or when > > > >operator will decide to do it. Dynamic data should not be backuped > > > >anyway. > > > >But in our system dynamic data changes every several minutes. It > > > >cause a fast growing of logfiles, and every two - three days > > > >Informix stops and waits while we backup logfiles. While Informix > > > >waiting for backup users of our system can't work. Increasing of > > > >logfiles size can only postpone this situation. > > > >We want to give our customers possibility to evaluate our software. > > > >During this evaluation we do not suppose to backup any data and we > > > >do not want to worry about logfiles at all. We want to have some > > > >'black box' which can be started once and work without any service > > > >and operator's actions. We understand and accept that in case if > > > >something will happened with database it will be impossible to > > > >restore data. > > > >How can we tune Informix Server to truncate / reuse / automatically > > > >backup logfiles ? > > > >Are there another solutions to avoid problem with continuous logfiles > >backup > >? > > > > > > > >Thanks for help! > > > > > > > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >

No. If the engine sees that LTAPEDEV is set to /dev/null in the ONCONFIG file at startup (or by using onmonitor when the engine is online) it understands that you want to deep-six the logfiles and will automatically free each logfile as it fills. Art S. Kagel Valeriy Tsuryk wrote: > > Sorry for one more question. > As far as I can understand even if I will have LTAPEDEV as /dev/null I > should schedule ontape -.... > or something else in order to wipe out log dbspace? > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > news:8kk35u$hmk$1@news.xmission.com... > > > > Set your LTAPEDEV to /dev/null? > > > > From: "Valeriy Tsuryk" <valery@quikcat.com> > > > > > >We developing distributed client-server application and we using > > > > > >Informix Dynamic Server Workgroup Edition 7.3... on UnixWare 7.1.1. > > > > > >Our database uses transaction logging. > > > > > >Our database has couple static tables with customers information > > > > > >and several tables with dynamic data. Amount of static data is not > > > > > >big and data can be backuped for example once per week or when > > > > > >operator will decide to do it. Dynamic data should not be backuped > > > > > >anyway. > > > > > >But in our system dynamic data changes every several minutes. It > > > > > >cause a fast growing of logfiles, and every two - three days > > > > > >Informix stops and waits while we backup logfiles. While Informix > > > > > >waiting for backup users of our system can't work. Increasing of > > > > > >logfiles size can only postpone this situation. > > > > > >We want to give our customers possibility to evaluate our software. > > > > > >During this evaluation we do not suppose to backup any data and we > > > > > >do not want to worry about logfiles at all. We want to have some > > > > > >'black box' which can be started once and work without any service > > > > > >and operator's actions. We understand and accept that in case if > > > > > >something will happened with database it will be impossible to > > > > > >restore data. > > > > > >How can we tune Informix Server to truncate / reuse / automatically > > > > > >backup logfiles ? > > > > > >Are there another solutions to avoid problem with continuous logfiles > > >backup > > >? > > > > > > > > > > > >Thanks for help! > > > > > > > > > > > > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >

Valeriy Tsuryk wrote: > > Sorry for one more question. > As far as I can understand even if I will have LTAPEDEV as /dev/null I > should schedule ontape -.... > or something else in order to wipe out log dbspace? > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > news:8kk35u$hmk$1@news.xmission.com... > > > > Set your LTAPEDEV to /dev/null? No; that's the advantage of /dev/null (or NUL on NT). All my toy systems (meaning all my OnLine instances) run with LTAPEDEV to /dev/null so I don't have to worry about this. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"