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------------------------------
Original Message:
Sent: Wed April 28, 2021 12:12 PM
From: Arjen Van Drie
Subject: ontape -l show 100% full logs but ontape -a doesn't flush them
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
Original Message:
Sent: Wed April 28, 2021 11:13 AM
From: Paul Watson
Subject: ontape -l show 100% full logs but ontape -a doesn't flush them
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
Original Message:
Sent: 4/28/2021 11:12:00 AM
From: Arjen Van Drie
Subject: RE: ontape -l show 100% full logs but ontape -a doesn't flush them
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
Original Message:
Sent: Wed April 28, 2021 11:01 AM
From: Paul Watson
Subject: ontape -l show 100% full logs but ontape -a doesn't flush them
Nope ,it will stay at 100%. On 11.70.FC2GE it stays at 100%, the only 11.7 I have running
Original Message:
Sent: 4/28/2021 10:48:00 AM
From: Arjen Van Drie
Subject: RE: ontape -l show 100% full logs but ontape -a doesn't flush them
Shouldn't %used go back to 0 then? On my 11 other informix servers this is the case...
------------------------------
Arjen Van Drie
Original Message:
Sent: Wed April 28, 2021 10:45 AM
From: Paul Watson
Subject: ontape -l show 100% full logs but ontape -a doesn't flush them
The B flag means Backed up
Original Message:
Sent: 4/28/2021 10:41:00 AM
From: Arjen Van Drie
Subject: ontape -l show 100% full logs but ontape -a doesn't flush them
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