Re: logical log questions

In article <jsd-1507961334150001@bass-kitten.cyborganic.com>, jsd@cyborganic.com' says... > > >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. > You just have to backup them to tape (command ontape -c or -a). After the copy to tape (you may try to /dev/null too) the logical logs will be available for more logging. Be atention to the size os the transacions and the highwater mark because if the logs fill in a big transacion and the highwater marks are too high you'll in problems because the system can't do the rollback. RTFM :) Alex