Re: logical log questions

jsd@cyborganic.com (Jon Drukman) wrote: >(note: this is informix online 7.12 on SGI IRIX 5.3) >in order to make my databases work with netscape's livewire pro (one of >those web server/db interface deals), i have to create them WITH LOG. >after a day or so of use, the logs fill up (according to the informix >online.log). i have no clue how to empty them. the only thing i can do >is reinitialize the entire database and reload all the data. needless to >say, this is sub-optimal. >i don't even care about the contents of the logs. i have to create the >database that way or my netscape programs start bombing all over the place >complaining "transaction not available (-256)". >is there any way to have the logical logs discarded periodically or >automatically emptied? >thanks in advance, >--jon You can free logical logs by backing them up to tape... The method depends on whether you use ontape or onarchive. Using ontape, you can do a one time backup with "ontape -a" or continual backup with "ontape -c". If you never care to recover the logs, then you can change the logical log device name to "/dev/null" in your onconfig file. I do not recommend this however, since it limits your recovery opportunities. Richard richj@iquest.com