Re: Turning off transaction logging from command line?

> > I would like to know if there is a better way of doing this. > Ideally, I would like to do the following from a shell script: > 1. disable transaction logging > 2. load all text files into Informix > 3. enable transaction logging > Then the shell script would be run from cron(1) every Saturday AM, > saving the DBA the trouble of having to dial into our system every > weekend. > > Can this be done? And if so, how? Documented in 5.0, but actually working in 4.1, you may use tbtape. tbtape -N database turns logging off for a database tbtape -U database -s turns Unbuffered logging on for a database If you on not using 4.1, you may still turn logging on and off, but its alot more painful, since Informix has to be brought to quiescent. Email me if you want those directions. Basically, you fake a Level 1 archive to /dev/null, the change the logging status thru tbmonitor. -- Naomi Walker (aka N7FSA) naomi%anasaz.UUCP@asuvax.eas.asu.edu Enthusiasm is caught, In tennis, not taught. love means nothing.