Backed up logs less than 100%

Hi everybody! Our client is using online Dynamic Server 9.21.UC5 on UNIX (AIX 4.3). They reported a problem with database performance (long response time). I asked them for the output from ‘onstat –l’: Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 5 8 147613 18854 7.83 phybegin physize phypos phyused %used 100107 1250 490 213 17.04 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 8 444178 50570 39632 8.8 1.3 Subsystem numrecs Log Space used OLDRSAM 444178 95238988 address number flags uniqid begin size used %used 3007d680 1 U-B---- 46651 1005e9 375 375 100.00 3007d69c 2 U-B---- 46652 100760 375 375 100.00 3007d6b8 3 U-B---- 46653 1008d7 375 375 100.00 3007d6d4 4 U-B---- 46654 100a4e 375 375 100.00 3007d6f0 5 U-B---- 46655 100bc5 375 375 100.00 3007d70c 6 U-B---- 46656 100d3c 375 375 100.00 3007d728 7 U-B---- 46657 100eb3 375 375 100.00 3007d744 8 U-B---- 46658 10102a 375 375 100.00 3007d760 9 U-B---- 46659 1011a1 375 228 60.80 3007d77c 10 U-B---- 46660 101318 375 36 9.60 3007d798 11 U-B---- 46661 10148f 375 160 42.67 3007d7b4 12 U-B---- 46662 101606 375 375 100.00 3007d7d0 13 U-B---- 46663 10177d 375 12 3.20 3007d7ec 14 U-B---- 46664 1018f4 375 375 100.00 3007d808 15 U-B---- 46665 101a6b 375 375 100.00 3007d824 16 U-B---- 46666 101be2 375 12 3.20 3007d840 17 U-B---- 46667 101d59 375 375 100.00 3007d85c 18 U-B---- 46668 101ed0 375 375 100.00 3007d878 19 U-B---- 46669 102047 375 247 65.87 3007d894 20 U-B---- 46670 1021be 375 375 100.00 3007d8b0 21 U-B---- 46671 102335 375 375 100.00 3007d8cc 22 U-B---- 46672 1024ac 375 375 100.00 3007d8e8 23 U-B---- 46673 102623 375 204 54.40 3007d904 24 U-B---- 46674 10279a 375 375 100.00 3007d920 25 U-B---- 46675 102911 375 375 100.00 3007d93c 26 U-B---- 46676 102a88 375 375 100.00 3007d958 27 U-B---- 46677 102bff 375 375 100.00 3007d974 28 U-B---- 46678 102d76 375 35 9.33 3007d990 29 U-B---- 46679 102eed 375 375 100.00 3007d9ac 30 U-B---- 46680 103064 375 375 100.00 3007d9c8 31 U-B---- 46681 103833 375 375 100.00 3007d9e4 32 U-B---- 46682 1039aa 375 375 100.00 3007da00 33 U-B---- 46683 103b21 375 156 41.60 3007da1c 34 U-B---- 46684 103c98 375 375 100.00 3007da38 35 U-B---- 46685 103e0f 375 375 100.00 3007da54 36 U-B---- 46686 103f86 375 375 100.00 3007da70 37 U-B---- 46687 1040fd 375 375 100.00 3007da8c 38 U-B---- 46688 104274 375 375 100.00 3007daa8 39 U-B---- 46689 1043eb 375 108 28.80 3007dac4 40 U-B---- 46690 104562 375 375 100.00 3007dae0 41 U-B---- 46691 1046d9 375 375 100.00 3007dafc 42 U-B---- 46692 104850 375 375 100.00 3007db18 43 U-B---- 46693 1049c7 375 375 100.00 3007db34 44 U-B---- 46694 104b3e 375 129 34.40 3007db50 45 U-B---- 46695 104cb5 375 375 100.00 3007db6c 46 U-B---- 46696 104e2c 375 375 100.00 3007db88 47 U-B---- 46697 104fa3 375 375 100.00 3007dba4 48 U---C-L 46698 10511a 375 172 45.87 3007dbc0 49 U-B---- 46639 105291 375 67 17.87 3007dbdc 50 U-B---- 46640 105408 375 64 17.07 3007dbf8 51 U-B---- 46641 10557f 375 16 4.27 3007dc14 52 U-B---- 46642 1056f6 375 25 6.67 3007dc30 53 U-B---- 46643 10586d 375 375 100.00 3007dc4c 54 U-B---- 46644 1059e4 375 375 100.00 3007dc68 55 U-B---- 46645 105b5b 375 375 100.00 3007dc84 56 U-B---- 46646 105cd2 375 375 100.00 3007dca0 57 U-B---- 46647 105e49 375 375 100.00 3007dcbc 58 U-B---- 46648 105fc0 375 375 100.00 3007dcd8 59 U-B---- 46649 600003 375 375 100.00 3007dcf4 60 U-B---- 46650 60017a 375 375 100.00 I don’t understand one thing: Why some of the logs are less than 100% with status ‘B’ (backed up). Every time I execute ‘onstat –l’ on our system I get something like this: Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 8 45902 5763 7.96 phybegin physize phypos phyused %used 100107 5000 2445 0 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-1 0 8 1344795 101205 12717 13.3 8.0 Subsystem numrecs Log Space used OLDRSAM 1344795 392039264 address number flags uniqid begin size used %used 30048edc 1 U-B---- 205 10148f 6375 6375 100.00 30048ef8 2 U-B---- 206 102d76 6375 6375 100.00 30048f14 3 U-B---- 207 10465d 6375 6375 100.00 30048f30 4 U-B---- 208 105f44 6375 6375 100.00 30048f4c 5 U---C-L 209 10782b 6375 5663 88.83 30048f68 6 U-B---- 204 109112 6375 6375 100.00 All the logs (except the active one) are 100% and ‘B’. Is having those logs below 100% with status ‘B’ indicates a problem. Could it be related to slower performance? Thank you, Miroslaw.