Informix

 View Only
Expand all | Collapse all

ontape -l show 100% full logs but ontape -a doesn't flush them

  • 1.  ontape -l show 100% full logs but ontape -a doesn't flush them

    Posted Wed April 28, 2021 10:41 AM
    Hello,

    IBM Informix Dynamic Server Version 12.10.FC5

    When I issue "onstat -l", I get:

    Physical Logging
    Buffer bufused  bufsize  numpages   numwrits   pages/io
     P-2  43       256      53         1          53.00
         phybegin         physize    phypos     phyused    %used    
         2:53             190976     120417     43         0.02     

    Logical Logging
    Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
     L-1  0        128      271        41         30         6.6        1.4      
           Subsystem    numrecs    Log Space used
           OLDRSAM      270        48420          
           HA           1          44             

    address          number   flags    uniqid   begin                size     used    %used
    4697a660         1        U-B----  64081    1:25263              8192     8192   100.00
    4697a6c8         2        U-B----  64082    1:33455              8192     8192   100.00
    4697a730         3        U-B----  64083    1:41647              8192     8192   100.00
    4697a798         4        U-B----  64084    1:49839              8192     8192   100.00
    4697a800         5        U-B----  64085    1:58031              8192     8192   100.00
    [...]
    47a273d0         235      U-B----  64075    3:933941             8192     8192   100.00
    47a27438         236      U-B----  64076    3:942133             8192     8192   100.00
    47a274a0         237      U-B----  64077    3:950325             8192     8192   100.00
    47a27508         238      U-B----  64078    3:958517             8192     8192   100.00
    47a27570         239      U-B----  64079    3:966709             8192     8192   100.00
    47a275d8         240      U-B----  64080    3:974901             8192     8192   100.00
    240 active, 240 total

    all of 'em 100% full.

    When I run "ontape -a", I get

    Performing automatic backup of logical logs.

    Do you want to back up the current logical log? (y/n) n

    Program over.

    (I have also answered "y" to the above question). I don't get it and would greatly appreciate some hints...

    Best regards,
    Arjen Van Drie.

    ------------------------------
    Arjen Van Drie
    ------------------------------

    #Informix


  • 2.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    IBM Champion
    Posted Wed April 28, 2021 10:46 AM

    The B flag  means Backed up

     

     

     






  • 3.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    Posted Wed April 28, 2021 10:48 AM
    Shouldn't %used go back to 0 then? On my 11 other informix servers this is the case...

    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 4.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    IBM Champion
    Posted Wed April 28, 2021 11:02 AM

    Nope ,it will stay at 100%. On 11.70.FC2GE it stays at 100%, the only 11.7 I have running

     






  • 5.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    Posted Wed April 28, 2021 11:12 AM
    I mean, I have 11 other informix servers running (version 12.10.FC5 as stated in my original post), and all of them show 0% used. This is the only one showing 100% for all logical logs. This is what I find weird (and a bit worrying). If that is normal behaviour (one server 0% used, the other 100%), then I wonder where the logic is... But maybe I shouldn't worry about it and just assume that either 0 or 100% used is fine. I just don't like assuming...


    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 6.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    IBM Champion
    Posted Wed April 28, 2021 11:14 AM
    What is the flag in the first column ?

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 7.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    Posted Wed April 28, 2021 12:13 PM
    On the ones with 0% used, the first column says F for free. The one with 100% has U for used as the first flag for all 240 logical logs.

    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 8.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    IBM Champion
    Posted Wed April 28, 2021 12:28 PM

    Logs start of as 'A' and will move to F once a backup has been taken (assuming they have not been used before the backup).

     

    Once the  F logs  have been used and backed up they move U-B. 

     

    Try playing with omode –l to see this happen.

     

    Once the log has been marked as U they will "never" go back to 0% used in the real world.   However, if the system moves to next log and you hit onmode –l at exactly that point it could say U and 0% as per below.  It took me a few attempts

     

    IBM Informix Dynamic Server Version 12.10.FC8

     

    onmode –l; onmode –l; onmode –l

     

    90ac0bc8         79       U-B----  18397    3:900053            25000        1     0.00

    90ac0c30         80       U-B----  18398    4:900053            25000       14     0.06

    90ac0c98         81       U---C--  18399    3:925053            25000       12     0.05

     

    Cheers
    Paul

     






  • 9.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    IBM Champion
    Posted Wed April 28, 2021 12:35 PM
    Arjen:

    Not to worry. As long as that 'B' is in the third flag position the log is available to be reused when it's turn comes up. The first flag position is 'A' for a newly added log, then it goes to 'F' once the server has been archived after adding a new log, then to 'U' where it stays except for VERY BRIEFLY being an 'F' again when it is in the process of being reused, but you are unlikely to catch that moment in time because as soon as a new log is made the current log it is immediately written to causing it's first flag position to go back to 'U'.

    This is all normal. Here's my server:

    $ onstat -l 

    IBM Informix Dynamic Server Version 14.10.FC5DE -- On-Line -- Up 2 days 06:29:48 -- 2180172 Kbytes
    2021-04-28 12:33:05

    Physical Logging
    Buffer bufused  bufsize  numpages   numwrits   pages/io
     P-2  20       64       3573       465        7.68
         phybegin         physize    phypos     phyused    %used    
         3:53             99947      70843      23         0.02     

    Logical Logging
    Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
     L-2  0        32       268081     43191      40615      6.2        1.1      
           Subsystem    numrecs    Log Space used
           OLDRSAM      267850     26673340       
           SBLOB        11         988            
           HA           220        9680           

    address          number   flags    uniqid   begin                size     used    %used
    46c16f88         7        U-B----- 756      2:53                 5000     5000   100.00
    469f8f80         8        U-B----- 757      2:5053               5000     5000   100.00
    46ad9f38         9        U-B----- 758      2:10053              5000     5000   100.00
    46ad9fa0         10       U-B----- 759      2:15053              5000     5000   100.00
    46bfa050         11       U-B----- 760      2:20053              5000     5000   100.00
    46bfa0b8         12       U-B----- 761      2:25053              5000     5000   100.00
    46bfa120         13       U-B----- 762      2:30053              5000     5000   100.00
    46bfa188         14       U-B----- 763      2:35053              5000     5000   100.00
    46bfa1f0         15       U-B----- 764      2:40053              5000     5000   100.00
    46bfa258         16       U-B----- 765      2:45053              5000     5000   100.00
    46bfa2c0         17       U-B----- 766      2:50053              5000     5000   100.00
    46bfa328         18       U-B----- 767      2:55053              5000     5000   100.00
    46bfa390         19       U-B----- 768      2:60053              5000     5000   100.00
    46bfa3f8         20       U-B----- 769      2:65053              5000     5000   100.00
    46bfa460         21       U-B----- 770      2:70053              5000     5000   100.00
    46bfa4c8         22       U-B----- 771      2:75053              5000     5000   100.00
    46bfa530         23       U-B----- 772      2:80053              5000     5000   100.00
    46bfa598         24       U-B----- 773      2:85053              5000     5000   100.00
    46bfa600         25       U-B----- 774      2:90053              5000     5000   100.00
    46bfa668         26       U-B----- 775      2:95053              5000     5000   100.00
    46bfa6d0         27       U-B----- 776      2:100053             5000     5000   100.00
    46bfa738         28       U-B----- 777      2:105053             5000     5000   100.00
    46bfa7a0         29       U-B----- 778      2:110053             5000     5000   100.00
    46bfa808         30       U-B----- 779      2:115053             5000     5000   100.00
    46bfa870         31       U-B----- 780      2:120053             5000     5000   100.00
    46bfa8d8         32       U-B----- 781      2:125053             5000     5000   100.00
    46bfa940         33       U-B----- 782      2:130053             5000     5000   100.00
    46bfa9a8         34       U-B----- 783      2:135053             5000     5000   100.00
    46bfaa10         35       U-B----- 784      2:140053             5000     5000   100.00
    46bfaa78         1        U-B----- 785      2:145053             5000     5000   100.00
    46bfaae0         2        U-B----- 786      2:150053             5000     5000   100.00
    46bfab48         3        U-B----- 787      2:155053             5000     5000   100.00
    46bfabb0         4        U-B----- 788      2:160053             5000     5000   100.00
    46bfac18         5        U-B----- 789      2:165053             5000     5000   100.00
    46bfac80         6        U-B----- 790      2:170053             5000     5000   100.00
    46bface8         36       U-B----- 791      2:175053             5000     5000   100.00
    46bfad50         37       U---C-L- 792      2:180053             5000     3693    73.86
    46bfadb8         38       U-B----- 744      2:185053             5000     5000   100.00
    46bfae20         39       U-B----- 745      2:190053             5000     5000   100.00
    46bfae88         40       U-B----- 746      2:195053             5000     5000   100.00
    46bfaef0         41       U-B----- 747      2:200053             5000     5000   100.00
    46bfaf58         42       U-B----- 748      2:205053             5000     5000   100.00
    46bfafc0         43       U-B----- 749      2:210053             5000     5000   100.00
    47e29028         44       U-B----- 750      2:215053             5000     5000   100.00
    47e29090         45       U-B----- 751      2:220053             5000     5000   100.00
    47e290f8         46       U-B----- 752      2:225053             5000     5000   100.00
    47e29160         47       U-B----- 753      2:230053             5000     5000   100.00
    47e291c8         48       U-B----- 754      2:235053             5000     5000   100.00
    47e29230         49       U-B----- 755      2:240053             5000     5000   100.00
    49 active, 49 total


    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 10.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    Posted Wed April 28, 2021 02:59 PM
    Paul, Art and also Andreas,

    thanks, I will stop worrying now :)

    Arjen.

    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 11.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    IBM Champion
    Posted Wed April 28, 2021 03:12 PM
    It's Informix - you never need to worry :-)

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 12.  RE: ontape -l show 100% full logs but ontape -a doesn't flush them

    IBM Champion
    Posted Wed April 28, 2021 10:47 AM
    All these logs do look backed up (carrying that B flag), so no need to perform any backing up (and ontape wouldn't backup a log twice).

    Whether that B originates from real backup, is a separate question.  It could also be a 'fake' B as a consequence of the system dismissing logical logs, by having LTAPEDEV onconfig parameter set to /dev/null - which is the default.

    HTH,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------