Re: Logical log backup problem

One note: Informix does not add logical logs automatically as needed. Austin Schutz wrote in message <3484AA73.B91@collegenet.spam-is-bad.com>... >Eric R. Gavin wrote: >> >> Hello, >> > >> >> Since then, I've discovered that it continues to add logical log files >> because our LOGSMAX parameter is set to 95. But I am worried. It's going >> to run out soon, and I don't want to keep upping the LOGSMAX parameter. >> > > I called Informix with this very question not more than 3 weeks ago. >when you do onstat -l and it shows: > >U---B---- > >It means that log has been backed up. As long as there are no >transactions running in that logfile the system will reuse it. I can >only imagine you don't have a transaction that has gone through 50 megs >of logs without doing a commit :-) > Apparently the reason it doesn't show them as 'Free' like it does when >you first create the log file so you can view the 'log transaction >history' or something like that. > So, as long as there's a B on that line, don't worry about it. > > Austin