Results 1 to 9 of 9

Thread: Logical Logs

  1. #1
    Join Date
    Nov 2004
    Posts
    4

    Unanswered: Logical Logs

    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

  2. #2
    Join Date
    Nov 2004
    Posts
    60
    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

  3. #3
    Join Date
    Nov 2004
    Posts
    26
    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)

  4. #4
    Join Date
    Nov 2004
    Posts
    4
    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

  5. #5
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    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

  6. #6
    Join Date
    Nov 2004
    Posts
    60
    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

  7. #7
    Join Date
    Nov 2004
    Posts
    4
    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

  8. #8
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    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

  9. #9
    Join Date
    Nov 2004
    Posts
    4
    Thank you for all the help everyone just never noticed it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •