Not using the 100% logical log page size alloacted to informix

Hi Jst need to know the problem as the informix (9.3 UC3) does not uses the full capacity of the logical log space provided.Any thing that need to tweaked so that it starts using the full 100% pages size it is allocated or AM i missing some other parameter rgds Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 2 16 176720 13031 13.56 phybegin physize phypos phyused %used 100107 256000 232411 2 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-1 0 16 2980120 124899 35199 23.9 3.5 Subsystem numrecs Log Space used OLDRSAM 2980120 211989012 address number flags uniqid begin size used %used 251a7798 10 U-B---- 590 300035 25600 9779 38.20 251a77d0 11 U-B---- 591 306435 25600 8610 33.63 251a7808 12 U-B---- 592 30c835 25600 10698 41.79 251a7840 13 U-B---- 593 312c35 25600 9490 37.07 251a7878 14 U-B---- 594 319035 25600 11944 46.66 251a78b0 15 U-B---- 595 31f435 25600 4692 18.33 251a78e8 16 U-B---- 596 325835 25600 1515 5.92 251a7920 17 U-B---- 597 32bc35 25600 12145 47.44 251a7958 18 U-B---- 598 332035 25600 11456 44.75 251a7990 19 U-B---- 599 338435 25600 12530 48.95 251a79c8 20 U-B---- 600 33e835 25600 14735 57.56 251a7a00 21 U-B---- 601 344c35 25600 11857 46.32 251a7a38 22 U-B---- 602 34b035 25600 6351 24.81 251a7a70 23 U-B---- 603 351435 25600 1774 6.93 251a7aa8 24 U-B---- 604 357835 25600 14162 55.32 251a7ae0 25 U-B---- 605 35dc35 25600 10103 39.46 251a7b18 26 U-B---- 606 364035 25600 7191 28.09 251a7b50 27 U-B---- 607 36a435 25600 9756 38.11 251a7b88 1 U-B---- 608 600035 25600 725 2.83 251a7bc0 28 U-B---- 609 370835 25600 15164 59.23 251a7bf8 29 U-B---- 610 376c35 25600 25600 100.00 251a7c30 2 U-B---- 611 606435 25600 5538 21.63 251a7c68 3 U-B---- 612 60c835 25600 7331 28.64 251a7ca0 4 U-B---- 613 612c35 25600 3347 13.07 251a7cd8 5 U-B---- 614 619035 25600 13716 53.58 251a7d10 6 U-B---- 615 61f435 25600 18082 70.63 251a7d48 7 U-B---- 616 625835 25600 10271 40.12 251a7d80 8 U-B---- 617 62bc35 25600 2958 11.55 251a7db8 9 U-B---- 618 632035 25600 11043 43.14 251a7df0 30 U-B---- 619 638435 25600 6679 26.09 251a7e28 31 U-B---- 620 63e835 25600 4538 17.73 251a7e60 32 U---C-L 621 644c35 25600 644 2.52 251a7e98 33 A------ 0 64b035 25600 0 0.00 251a7ed0 34 A------ 0 651435 25600 0 0.00 251a7f08 35 A------ 0 657835 25600 0 0.00 35 active, 35 total

Anand Iyer wrote: > Hi > > Jst need to know the problem as the informix (9.3 UC3) does not uses > the full capacity of the logical log space provided.Any thing that need > to tweaked so that it starts using the full 100% pages size it is > allocated or > > AM i missing some other parameter > > rgds buried somewhere in your machine (pay particular attention to cron jobs, or maybe something fired by ALARMPROGRAM) there's something that does onmode -l. hunt it down, see why the decision was made to have something do onmode -l's, and if the case needs be, get it out of the way > > > Physical Logging > Buffer bufused bufsize numpages numwrits pages/io > P-2 2 16 176720 13031 13.56 > phybegin physize phypos phyused %used > 100107 256000 232411 2 0.00 > > Logical Logging > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-1 0 16 2980120 124899 35199 23.9 3.5 > Subsystem numrecs Log Space used > OLDRSAM 2980120 211989012 > > address number flags uniqid begin size used %used > 251a7798 10 U-B---- 590 300035 25600 9779 38.20 > 251a77d0 11 U-B---- 591 306435 25600 8610 33.63 > 251a7808 12 U-B---- 592 30c835 25600 10698 41.79 > 251a7840 13 U-B---- 593 312c35 25600 9490 37.07 > 251a7878 14 U-B---- 594 319035 25600 11944 46.66 > 251a78b0 15 U-B---- 595 31f435 25600 4692 18.33 > 251a78e8 16 U-B---- 596 325835 25600 1515 5.92 > 251a7920 17 U-B---- 597 32bc35 25600 12145 47.44 > 251a7958 18 U-B---- 598 332035 25600 11456 44.75 > 251a7990 19 U-B---- 599 338435 25600 12530 48.95 > 251a79c8 20 U-B---- 600 33e835 25600 14735 57.56 > 251a7a00 21 U-B---- 601 344c35 25600 11857 46.32 > 251a7a38 22 U-B---- 602 34b035 25600 6351 24.81 > 251a7a70 23 U-B---- 603 351435 25600 1774 6.93 > 251a7aa8 24 U-B---- 604 357835 25600 14162 55.32 > 251a7ae0 25 U-B---- 605 35dc35 25600 10103 39.46 > 251a7b18 26 U-B---- 606 364035 25600 7191 28.09 > 251a7b50 27 U-B---- 607 36a435 25600 9756 38.11 > 251a7b88 1 U-B---- 608 600035 25600 725 2.83 > 251a7bc0 28 U-B---- 609 370835 25600 15164 59.23 > 251a7bf8 29 U-B---- 610 376c35 25600 25600 100.00 > 251a7c30 2 U-B---- 611 606435 25600 5538 21.63 > 251a7c68 3 U-B---- 612 60c835 25600 7331 28.64 > 251a7ca0 4 U-B---- 613 612c35 25600 3347 13.07 > 251a7cd8 5 U-B---- 614 619035 25600 13716 53.58 > 251a7d10 6 U-B---- 615 61f435 25600 18082 70.63 > 251a7d48 7 U-B---- 616 625835 25600 10271 40.12 > 251a7d80 8 U-B---- 617 62bc35 25600 2958 11.55 > 251a7db8 9 U-B---- 618 632035 25600 11043 43.14 > 251a7df0 30 U-B---- 619 638435 25600 6679 26.09 > 251a7e28 31 U-B---- 620 63e835 25600 4538 17.73 > 251a7e60 32 U---C-L 621 644c35 25600 644 2.52 > 251a7e98 33 A------ 0 64b035 25600 0 0.00 > 251a7ed0 34 A------ 0 651435 25600 0 0.00 > 251a7f08 35 A------ 0 657835 25600 0 0.00 > 35 active, 35 total > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm

"Marco Greco" <marco@4glworks.com <mailto:marco@4glworks.com>> wrote in message <news:mailman.64.1142156014.18205.informix-list@iiug.org>...> Anand Iyer wrote: >> Hi >> >> Jst need to know the problem as the informix (9.3 UC3) does not uses >> the full capacity of the logical log space provided.Any thing that need >> to tweaked so that it starts using the full 100% pages size it is >> allocated or >> >> AM i missing some other parameter >> >> rgds > > buried somewhere in your machine (pay particular attention to cron jobs, > or > maybe something fired by ALARMPROGRAM) there's something that does > onmode -l.> hunt it down, see why the decision was made to have something do > onmode -l's,> and if the case needs be, get it out of the way Or did he mean that the logical log dbspace is not full maybe?

it seems the alarmprogram executes the onbar commands onbar -b -l TIA

No, i meant the logical log page file that i have appended in my query.

How often do your logs fill? Do any of your databases in the instance use logging? How often do you run a DB backup? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Anand Iyer" <iyeranandmail@gmail.com> >To: informix-list@iiug.org >Subject: Not using the 100% logical log page size alloacted to informix >Date: 11 Mar 2006 23:51:41 -0800 > >Hi > >Jst need to know the problem as the informix (9.3 UC3) does not uses >the full capacity of the logical log space provided.Any thing that need >to tweaked so that it starts using the full 100% pages size it is >allocated or > >AM i missing some other parameter > >rgds > > >Physical Logging >Buffer bufused bufsize numpages numwrits pages/io > P-2 2 16 176720 13031 13.56 > phybegin physize phypos phyused %used > 100107 256000 232411 2 0.00 > >Logical Logging >Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-1 0 16 2980120 124899 35199 23.9 3.5 > Subsystem numrecs Log Space used > OLDRSAM 2980120 211989012 > >address number flags uniqid begin size used %used >251a7798 10 U-B---- 590 300035 25600 9779 38.20 >251a77d0 11 U-B---- 591 306435 25600 8610 33.63 >251a7808 12 U-B---- 592 30c835 25600 10698 41.79 >251a7840 13 U-B---- 593 312c35 25600 9490 37.07 >251a7878 14 U-B---- 594 319035 25600 11944 46.66 >251a78b0 15 U-B---- 595 31f435 25600 4692 18.33 >251a78e8 16 U-B---- 596 325835 25600 1515 5.92 >251a7920 17 U-B---- 597 32bc35 25600 12145 47.44 >251a7958 18 U-B---- 598 332035 25600 11456 44.75 >251a7990 19 U-B---- 599 338435 25600 12530 48.95 >251a79c8 20 U-B---- 600 33e835 25600 14735 57.56 >251a7a00 21 U-B---- 601 344c35 25600 11857 46.32 >251a7a38 22 U-B---- 602 34b035 25600 6351 24.81 >251a7a70 23 U-B---- 603 351435 25600 1774 6.93 >251a7aa8 24 U-B---- 604 357835 25600 14162 55.32 >251a7ae0 25 U-B---- 605 35dc35 25600 10103 39.46 >251a7b18 26 U-B---- 606 364035 25600 7191 28.09 >251a7b50 27 U-B---- 607 36a435 25600 9756 38.11 >251a7b88 1 U-B---- 608 600035 25600 725 2.83 >251a7bc0 28 U-B---- 609 370835 25600 15164 59.23 >251a7bf8 29 U-B---- 610 376c35 25600 25600 100.00 >251a7c30 2 U-B---- 611 606435 25600 5538 21.63 >251a7c68 3 U-B---- 612 60c835 25600 7331 28.64 >251a7ca0 4 U-B---- 613 612c35 25600 3347 13.07 >251a7cd8 5 U-B---- 614 619035 25600 13716 53.58 >251a7d10 6 U-B---- 615 61f435 25600 18082 70.63 >251a7d48 7 U-B---- 616 625835 25600 10271 40.12 >251a7d80 8 U-B---- 617 62bc35 25600 2958 11.55 >251a7db8 9 U-B---- 618 632035 25600 11043 43.14 >251a7df0 30 U-B---- 619 638435 25600 6679 26.09 >251a7e28 31 U-B---- 620 63e835 25600 4538 17.73 >251a7e60 32 U---C-L 621 644c35 25600 644 2.52 >251a7e98 33 A------ 0 64b035 25600 0 0.00 >251a7ed0 34 A------ 0 651435 25600 0 0.00 >251a7f08 35 A------ 0 657835 25600 0 0.00 > 35 active, 35 total > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list

Anand Iyer wrote: > it seems the alarmprogram executes the onbar commands > > onbar -b -l> > > TIA > Could be an onbar -b, which at the end of each dbspace forces a logical log switch, and you have BAR_MAX_BACKUP set to 0 (i.e. unlimited backup threads).