I am fairly new to Informix and was looking for someone who could shed some light on logical logs. When I perform a onstat -l this is the output:


Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 64 28469 1195 286 23.8 4.2

address number flags uniqid begin size used %used
c178c54c 4 U-B---- 5187 200035 5000 5000 100.00
c178c568 5 U-B---- 5188 2013bd 5000 5000 100.00
c178c584 6 U-B---- 5189 202745 5000 5000 100.00
c178c5a0 7 U-B---- 5190 203acd 5000 5000 100.00
c178c5bc 8 U-B---- 5191 204e55 5000 5000 100.00
c178c5d8 9 U-B---- 5192 2061dd 5000 5000 100.00
c178c5f4 10 U-B---- 5193 207565 5000 5000 100.00
c178c610 11 U-B---- 5194 2088ed 5000 5000 100.00
c178c62c 12 U-B---- 5195 209c75 5000 5000 100.00
c178c648 13 U-B---- 5196 20affd 5000 5000 100.00
c178c664 14 U-B---- 5197 20c385 5000 5000 100.00
c178c680 15 U---C-L 5198 20d70d 5000 395 7.90
c178c69c 16 U-B---- 5179 20ea95 5000 5000 100.00
c178c6b8 17 U-B---- 5180 20fe1d 5000 5000 100.00
c178c6d4 18 U-B---- 5181 2111a5 5000 5000 100.00
c178c6f0 19 U-B---- 5182 21252d 5000 5000 100.00
c178c70c 20 U-B---- 5183 2138b5 5000 5000 100.00
c178c728 21 U-B---- 5184 214c3d 5000 5000 100.00
c178c744 22 U-B---- 5185 215fc5 5000 5000 100.00
c178c760 23 U-B---- 5186 21734d 5000 5000 100.00

Why are the logical logs which are full and backed-up are not being released?

Thanks
Hendrick

Why do you not think they are being released? B means backed up and available for re-use. If they were not being released the engine would halt activity once the current logical log (C) reached 100% and it couldn't roll over to the next one

It's just one of those cunning little ploys of informix's to confuse us (I get confused enough on my own, I don't need the help)

The reason I feel they are not being reused is becuase logical log 15 fills to 100% and then goes back down to 0%. Non of the other logical logs are being used.

Hendrick

Informix only shows logincal log as free for a splitt second. That is normal. If you dont think that it using any other logs force it to the next one by executing
onmode -l

Quite right! Also, ensure logging is turned on for your database. Try the command 'ondblog unbuf/buf log dbname' followed by a full system archive to get you going

What exactly would this accomplish? This is our production box and would want to affect anything. Today all the logical logs are filled except 17 now.

Thanks

they are backed up, informix only shows a log as free for a split second.
if log 17 fills up it will move on to the next one

Thank you for all the help everyone just never noticed it.