Re: Freeing logical logs

fry_ja@leg.wa.gov (Jason Fry) wrote: >I've finally backed up my logical log files, but they are still not >free. This is the output of the onstat -l command >address number flags uniqid begin size used >%used >88d988 1 U-B---- 16 203acd 5000 5000 >100.00 >88d9a4 2 U-B---- 17 204e55 5000 5000 >100.00 >88d9c0 3 U-B---- 18 2061dd 5000 5000 >100.00 >88d9dc 4 U---C-L 19 200035 5000 3927 >78.54 >88d9f8 5 F------ 0 2013bd 5000 0 >0.00 >88da14 6 F------ 0 202745 5000 0 >0.00 >As you can see, three of the logs are backed up, but are not being >released. The book said to take Online down to quiescent mode, which >should cause the active transactions to roll back. I tried this, but >to no avail. I've also tried forcing a checkpoint. Any ideas on how >to free these logs. >TIA >Jason Fry >Washington State Legislative Service Center I don't know what version of informix you are using but if it is 7.1x Informix does not actually free a logical log until it is ready to reuse it. Once the log has been used it will never show free again just the UB status. Once it is time to reuse the log it will reuse it. You should have no problem unless the next log in the order also contains the last checkpoint. I was told they did this so informix tech would have some way of recovering some data for those folks backing the logs up to /dev/null. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com