Freeing logical logs
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