Logical logs
Hi All,
I have a informix database of 7.30 where in the logical log is getting
full very frequently.
> What might be the reason. I think the "size" / "physize" of each log is
> very less. I am giving below the output of "onstat -l". Is there any
> parameters in onconfig that I can change now? Can I make the changes
> without affecting the database?
>
> thanks,Srini
>
>
>
>
> --------------------------------------------------------------------------
> -------------------------------------
> informix:/usr/informix>onstat -l
>
> Informix Dynamic Server Version 7.30.UC10X5 -- On-Line -- Up 06:21:42 --
> 19976 K
> bytes
>
> Physical Logging
> Buffer bufused bufsize numpages numwrits pages/io
> P-2 0 16 23012 1449 15.88
>
> phybegin physize phypos phyused %used
>
> 10003f 4096 1336 0 0.00
>
>
>
> Logical Logging
>
> Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
>
> L-1 0 16 2321074 73229 4620 31.7 15.9
>
> Subsystem numrecs Log Space used
>
> OLDRSAM 2321074 147532404
>
>
>
> address number flags uniqid begin size used %used
>
> c1fa0a64 1 U-B---- 97 10103f 4096 4096 100.00
>
> c1fa0a80 2 U-B---- 98 10203f 4096 4096 100.00
>
> c1fa0a9c 3 U-B---- 99 10303f 4096 4096 100.00
>
> c1fa0ab8 4 U-B---- 100 10403f 4096 4096 100.00
>
> c1fa0ad4 5 U------ 101 10503f 4096 4096 100.00
>
> c1fa0af0 6 U------ 102 10603f 4096 4096 100.00
>
> c1fa0b0c 7 U------ 103 10703f 4096 4096 100.00
>
> c1fa0b28 8 U------ 104 10803f 4096 4096 100.00
>
> c1fa0b44 9 U---C-L 105 10903f 4096 1554 37.94
>
> c1fa0b60 10 U-B---- 94 10a03f 4096 4096 100.00
>
> c1fa0b7c 11 U-B---- 95 10b03f 4096 4096 100.00
>
> c1fa0b98 12 U-B---- 96 10c03f 4096 4096 100.00
>
Srinivas Sreekumar wrote:
>
> Hi All,
>
> I have a informix database of 7.30 where in the logical log is getting
> full very frequently.
Is there a question in here?
Art S. Kagel
> > What might be the reason. I think the "size" / "physize" of each log is
> > very less. I am giving below the output of "onstat -l". Is there any
> > parameters in onconfig that I can change now? Can I make the changes
> > without affecting the database?
> >
> > thanks,Srini
> >
> >
> >
> >
> > --------------------------------------------------------------------------
> > -------------------------------------
> > informix:/usr/informix>onstat -l
> >
> > Informix Dynamic Server Version 7.30.UC10X5 -- On-Line -- Up 06:21:42 --
> > 19976 K
> > bytes
> >
> > Physical Logging
> > Buffer bufused bufsize numpages numwrits pages/io
> > P-2 0 16 23012 1449 15.88
> >
> > phybegin physize phypos phyused %used
> >
> > 10003f 4096 1336 0 0.00
> >
> >
> >
> > Logical Logging
> >
> > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> >
> > L-1 0 16 2321074 73229 4620 31.7 15.9
> >
> > Subsystem numrecs Log Space used
> >
> > OLDRSAM 2321074 147532404
> >
> >
> >
> > address number flags uniqid begin size used %used
> >
> > c1fa0a64 1 U-B---- 97 10103f 4096 4096 100.00
> >
> > c1fa0a80 2 U-B---- 98 10203f 4096 4096 100.00
> >
> > c1fa0a9c 3 U-B---- 99 10303f 4096 4096 100.00
> >
> > c1fa0ab8 4 U-B---- 100 10403f 4096 4096 100.00
> >
> > c1fa0ad4 5 U------ 101 10503f 4096 4096 100.00
> >
> > c1fa0af0 6 U------ 102 10603f 4096 4096 100.00
> >
> > c1fa0b0c 7 U------ 103 10703f 4096 4096 100.00
> >
> > c1fa0b28 8 U------ 104 10803f 4096 4096 100.00
> >
> > c1fa0b44 9 U---C-L 105 10903f 4096 1554 37.94
> >
> > c1fa0b60 10 U-B---- 94 10a03f 4096 4096 100.00
> >
> > c1fa0b7c 11 U-B---- 95 10b03f 4096 4096 100.00
> >
> > c1fa0b98 12 U-B---- 96 10c03f 4096 4096 100.00
> >