Re: Logical logs from rootdbs to own logspace

"Andrew Hamm" <ahamm@mail.com> wrote in message news:2kh0tsF2cbhcU1@uni-berlin.de... > Really? I hope you are talking about a long-forgotten feature of a Version > Five then, 'cos this works beaudifully: > onstat - IBM Informix Dynamic Server Version 9.40.TC2E1 -- On-Line -- Up 00:01:40 D:\\Informix>onparams -a -d djw1 Logical log successfully added. D:\\Informix>onstat -m ... 21:22:26 Init operation complete - Mode Online 21:22:26 On-Line Mode 21:23:14 Log file 7 added to DBspace 2. D:\\Informix>ontape -s -L 0 Archive to tape device 'nul' is complete. D:\\Informix>onstat -l ... address number flags uniqid begin size used %used 0CB37CA8 1 U-B---- 1 1:763 500 500 100.00 0CB37CE8 2 U-B---- 2 1:1263 500 500 100.00 0CB37D28 3 U-B---- 3 1:1763 500 500 100.00 0CB37D68 4 U-B---- 4 1:2263 500 352 70.40 0CB37DA8 5 U---C-L 5 1:2763 500 39 7.80 0CB37DE8 6 A------ 0 1:3263 500 0 0.00 0CEECD98 7 A------ 0 2:697 500 0 0.00 onmode -l a few times to switch logical logs (just to force it on so you can see the results..). D:\\Informix>onstat -l address number flags uniqid begin size used %used 0CB37CA8 1 U---C-- 8 1:763 500 0 0.00 0CB37CE8 2 U-B---- 2 1:1263 500 500 100.00 0CB37D28 3 U-B---- 3 1:1763 500 500 100.00 0CB37D68 4 U-B---- 4 1:2263 500 352 70.40 0CB37DA8 5 U-B---L 5 1:2763 500 40 8.00 0CB37DE8 6 U-B---- 6 1:3263 500 1 0.20 0CEECD98 7 U-B---- 7 2:697 500 1 0.20 Yep..no need to drop to quiescent mode...I seem to remember having to do this in 7.31 though!