Re: Freeing logical logs

Jason Fry (fry_ja@leg.wa.gov) 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 Jason, I seem to remember a side issue in a recent INFORMIX Performance Tuning class. One of the other students mentioned a situation similar to yours. The response given by the instructor was that this is a recent change to OnLine to allow ONLOG the ability to look back at these files. The logs will be marked free when the system needs to use them. Apparently this is documented in the "New Features Guide", since I am on the road, I don't have mine with me to verify. You may want to verify this with Tech Support. Regards Barry Lemrow -- +----------------------------+------------------------------------------+ | Barry Lemrow | Disclaimer: | | Technical Consultant | "Opinions expressed are mine and not | | SAP National Practice | necessarily those of my employer, | | Hewlett-Packard | family, or friends!" | | blemrow@a3166tpa.ssr.hp.com| | +----------------------------+------------------------------------------+