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
Looks to me that you are running version 7.x +, the logs are no longer
marked as being free, yet they are.
Jeff Diaz
jdiaz@jax.jaxnet.com