logical logs at 100%
For some reason the networker software, legato is having some trouble -
and the following output from onstat -l gives me concern.
In the interim, while the legato software is being worked on,
is there anything i should do ?
do a fake level 0?
INFORMIX-Universal Server Version 9.12.UC2 -- On-Line -- Up 145 days
03:47:29 -- 45760 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 16 263312 33540 7.85
phybegin physize phypos phyused %used
10003f 2000 146 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 16 39667157 946394 137043 41.9 6.9
Subsystem numrecs Log Space used
OLDRSAM 39667157 1748597052
address number flags uniqid begin size used %used
c3e65f90 1 U------ 651 10080f 4000 4000 100.00
c3e65fac 2 U------ 652 1017af 4000 4000 100.00
c3e65fc8 3 U------ 653 10274f 4000 4000 100.00
c3e65fe4 4 U------ 654 1036ef 4000 4000 100.00
c3e66000 5 U---C-L 655 10468f 4000 3423 85.58
c3e6601c 6 U-B---- 646 10562f 4000 4 0.10
c3e66038 7 U------ 647 1065cf 4000 4000 100.00
c3e66054 8 U------ 648 10756f 4000 4000 100.00
c3e66070 9 U------ 649 10850f 4000 4000 100.00
c3e6608c 10 U------ 650 1094af 4000 4000 100.00
You could do an ontape -a to clear the logs. When you have Legato
cleaned up tape a level 0 archive since onbar cannot use the logs that
ontape saves. Also seriously consider adding more logspace, 10 8MB
logs is just not enough for realworld servers. I use 76 100MB logs for
our servers and I know installations that typically use 70 + 500MB logs.
Art S. Kagel
edward rosenthal wrote:
>
> For some reason the networker software, legato is having some trouble -
> and the following output from onstat -l gives me concern.
> In the interim, while the legato software is being worked on,
> is there anything i should do ?
> do a fake level 0?
>
> INFORMIX-Universal Server Version 9.12.UC2 -- On-Line -- Up 145 days
> 03:47:29 -- 45760 Kbytes
>
> Physical Logging
> Buffer bufused bufsize numpages numwrits pages/io
> P-2 0 16 263312 33540 7.85
> phybegin physize phypos phyused %used
> 10003f 2000 146 0 0.00
>
> Logical Logging
> Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> L-1 0 16 39667157 946394 137043 41.9 6.9
> Subsystem numrecs Log Space used
> OLDRSAM 39667157 1748597052
>
> address number flags uniqid begin size used %used
> c3e65f90 1 U------ 651 10080f 4000 4000 100.00
> c3e65fac 2 U------ 652 1017af 4000 4000 100.00
> c3e65fc8 3 U------ 653 10274f 4000 4000 100.00
> c3e65fe4 4 U------ 654 1036ef 4000 4000 100.00
> c3e66000 5 U---C-L 655 10468f 4000 3423 85.58
> c3e6601c 6 U-B---- 646 10562f 4000 4 0.10
> c3e66038 7 U------ 647 1065cf 4000 4000 100.00
> c3e66054 8 U------ 648 10756f 4000 4000 100.00
> c3e66070 9 U------ 649 10850f 4000 4000 100.00
> c3e6608c 10 U------ 650 1094af 4000 4000 100.00
thanks.
in the meantime, i have noticed some backups took place, although the
100% statistic remains in place i.e.;
address number flags uniqid begin size used %used
c3e65f90 1 U-B---- 651 10080f 4000 4000 100.00
c3e65fac 2 U-B---- 652 1017af 4000 4000 100.00
c3e65fc8 3 U-B---- 653 10274f 4000 4000 100.00
c3e65fe4 4 U-B---- 654 1036ef 4000 4000 100.00
c3e66000 5 U------ 655 10468f 4000 4000 100.00
c3e6601c 6 U---C-L 656 10562f 4000 2279 56.98
c3e66038 7 U-B---- 647 1065cf 4000 4000 100.00
c3e66054 8 U-B---- 648 10756f 4000 4000 100.00
c3e66070 9 U-B---- 649 10850f 4000 4000 100.00
c3e6608c 10 U-B---- 650 1094af 4000 4000 100.00
wonder why that is?
"Art S. Kagel" wrote:
> You could do an ontape -a to clear the logs. When you have Legato
> cleaned up tape a level 0 archive since onbar cannot use the logs that
> ontape saves. Also seriously consider adding more logspace, 10 8MB
> logs is just not enough for realworld servers. I use 76 100MB logs for
> our servers and I know installations that typically use 70 + 500MB logs.
>
> Art S. Kagel
>
> edward rosenthal wrote:
> >
> > For some reason the networker software, legato is having some trouble -
> > and the following output from onstat -l gives me concern.
> > In the interim, while the legato software is being worked on,
> > is there anything i should do ?
> > do a fake level 0?
> >
> > INFORMIX-Universal Server Version 9.12.UC2 -- On-Line -- Up 145 days
> > 03:47:29 -- 45760 Kbytes
> >
> > Physical Logging
> > Buffer bufused bufsize numpages numwrits pages/io
> > P-2 0 16 263312 33540 7.85
> > phybegin physize phypos phyused %used
> > 10003f 2000 146 0 0.00
> >
> > Logical Logging
> > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > L-1 0 16 39667157 946394 137043 41.9 6.9
> > Subsystem numrecs Log Space used
> > OLDRSAM 39667157 1748597052
> >
> > address number flags uniqid begin size used %used
> > c3e65f90 1 U------ 651 10080f 4000 4000 100.00
> > c3e65fac 2 U------ 652 1017af 4000 4000 100.00
> > c3e65fc8 3 U------ 653 10274f 4000 4000 100.00
> > c3e65fe4 4 U------ 654 1036ef 4000 4000 100.00
> > c3e66000 5 U---C-L 655 10468f 4000 3423 85.58
> > c3e6601c 6 U-B---- 646 10562f 4000 4 0.10
> > c3e66038 7 U------ 647 1065cf 4000 4000 100.00
> > c3e66054 8 U------ 648 10756f 4000 4000 100.00
> > c3e66070 9 U------ 649 10850f 4000 4000 100.00
> > c3e6608c 10 U------ 650 1094af 4000 4000 100.00
Once the log has been used, it shows 100% (or whatever value it was at) until
it is reused.
Vic
edward rosenthal wrote:
> thanks.
> in the meantime, i have noticed some backups took place, although the
> 100% statistic remains in place i.e.;
> address number flags uniqid begin size used %used
> c3e65f90 1 U-B---- 651 10080f 4000 4000 100.00
> c3e65fac 2 U-B---- 652 1017af 4000 4000 100.00
> c3e65fc8 3 U-B---- 653 10274f 4000 4000 100.00
> c3e65fe4 4 U-B---- 654 1036ef 4000 4000 100.00
> c3e66000 5 U------ 655 10468f 4000 4000 100.00
> c3e6601c 6 U---C-L 656 10562f 4000 2279 56.98
> c3e66038 7 U-B---- 647 1065cf 4000 4000 100.00
> c3e66054 8 U-B---- 648 10756f 4000 4000 100.00
> c3e66070 9 U-B---- 649 10850f 4000 4000 100.00
> c3e6608c 10 U-B---- 650 1094af 4000 4000 100.00
> wonder why that is?
>
> "Art S. Kagel" wrote:
>
> > You could do an ontape -a to clear the logs. When you have Legato
> > cleaned up tape a level 0 archive since onbar cannot use the logs that
> > ontape saves. Also seriously consider adding more logspace, 10 8MB
> > logs is just not enough for realworld servers. I use 76 100MB logs for
> > our servers and I know installations that typically use 70 + 500MB logs.
> >
> > Art S. Kagel
> >
> > edward rosenthal wrote:
> > >
> > > For some reason the networker software, legato is having some trouble -
> > > and the following output from onstat -l gives me concern.
> > > In the interim, while the legato software is being worked on,
> > > is there anything i should do ?
> > > do a fake level 0?
> > >
> > > INFORMIX-Universal Server Version 9.12.UC2 -- On-Line -- Up 145 days
> > > 03:47:29 -- 45760 Kbytes
> > >
> > > Physical Logging
> > > Buffer bufused bufsize numpages numwrits pages/io
> > > P-2 0 16 263312 33540 7.85
> > > phybegin physize phypos phyused %used
> > > 10003f 2000 146 0 0.00
> > >
> > > Logical Logging
> > > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > > L-1 0 16 39667157 946394 137043 41.9 6.9
> > > Subsystem numrecs Log Space used
> > > OLDRSAM 39667157 1748597052
> > >
> > > address number flags uniqid begin size used %used
> > > c3e65f90 1 U------ 651 10080f 4000 4000 100.00
> > > c3e65fac 2 U------ 652 1017af 4000 4000 100.00
> > > c3e65fc8 3 U------ 653 10274f 4000 4000 100.00
> > > c3e65fe4 4 U------ 654 1036ef 4000 4000 100.00
> > > c3e66000 5 U---C-L 655 10468f 4000 3423 85.58
> > > c3e6601c 6 U-B---- 646 10562f 4000 4 0.10
> > > c3e66038 7 U------ 647 1065cf 4000 4000 100.00
> > > c3e66054 8 U------ 648 10756f 4000 4000 100.00
> > > c3e66070 9 U------ 649 10850f 4000 4000 100.00
> > > c3e6608c 10 U------ 650 1094af 4000 4000 100.00
>
> ------------------------------------------------------------------------
>
> Ed Rosenthal <erosenthal@mfi.com>
> Database Administrator
> Miller Freeman Inc.
> Web Services
>
> Ed Rosenthal
> Database Administrator <erosenthal@mfi.com>
> Miller Freeman Inc.
> Web Services
> 600 Harrison St. Pager: (888) 274-7679@skytel.com
> San Fransisco Cellular: (707) 332-5558
> California Home: (707) 782-0766
> 94107 Work: (415) 905-2431
> USA
> Additional Information:
> Last Name Rosenthal
> First Name Edward
> Version 2.1
Informix no longer marks the logs free (flag 'F') until immediately
before they are reused or if by some weird coincidence when the log is
backed up there are no current sessions with transactions open in that
particular log, which almost never happens. The 'F' flag can only be
set immediately after the log is backed up or immediately before it is
reused so in practice it never is.
Art S. Kagel
edward rosenthal wrote:
>
> thanks.
> in the meantime, i have noticed some backups took place, although the
> 100% statistic remains in place i.e.;
> address number flags uniqid begin size used %used
> c3e65f90 1 U-B---- 651 10080f 4000 4000 100.00
> c3e65fac 2 U-B---- 652 1017af 4000 4000 100.00
> c3e65fc8 3 U-B---- 653 10274f 4000 4000 100.00
> c3e65fe4 4 U-B---- 654 1036ef 4000 4000 100.00
> c3e66000 5 U------ 655 10468f 4000 4000 100.00
> c3e6601c 6 U---C-L 656 10562f 4000 2279 56.98
> c3e66038 7 U-B---- 647 1065cf 4000 4000 100.00
> c3e66054 8 U-B---- 648 10756f 4000 4000 100.00
> c3e66070 9 U-B---- 649 10850f 4000 4000 100.00
> c3e6608c 10 U-B---- 650 1094af 4000 4000 100.00
> wonder why that is?
>
> "Art S. Kagel" wrote:
>
> > You could do an ontape -a to clear the logs. When you have Legato
> > cleaned up tape a level 0 archive since onbar cannot use the logs that
> > ontape saves. Also seriously consider adding more logspace, 10 8MB
> > logs is just not enough for realworld servers. I use 76 100MB logs for
> > our servers and I know installations that typically use 70 + 500MB logs.
> >
> > Art S. Kagel
> >
> > edward rosenthal wrote:
> > >
> > > For some reason the networker software, legato is having some trouble -
> > > and the following output from onstat -l gives me concern.
> > > In the interim, while the legato software is being worked on,
> > > is there anything i should do ?
> > > do a fake level 0?
> > >
> > > INFORMIX-Universal Server Version 9.12.UC2 -- On-Line -- Up 145 days
> > > 03:47:29 -- 45760 Kbytes
> > >
> > > Physical Logging
> > > Buffer bufused bufsize numpages numwrits pages/io
> > > P-2 0 16 263312 33540 7.85
> > > phybegin physize phypos phyused %used
> > > 10003f 2000 146 0 0.00
> > >
> > > Logical Logging
> > > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > > L-1 0 16 39667157 946394 137043 41.9 6.9
> > > Subsystem numrecs Log Space used
> > > OLDRSAM 39667157 1748597052
> > >
> > > address number flags uniqid begin size used %used
> > > c3e65f90 1 U------ 651 10080f 4000 4000 100.00
> > > c3e65fac 2 U------ 652 1017af 4000 4000 100.00
> > > c3e65fc8 3 U------ 653 10274f 4000 4000 100.00
> > > c3e65fe4 4 U------ 654 1036ef 4000 4000 100.00
> > > c3e66000 5 U---C-L 655 10468f 4000 3423 85.58
> > > c3e6601c 6 U-B---- 646 10562f 4000 4 0.10
> > > c3e66038 7 U------ 647 1065cf 4000 4000 100.00
> > > c3e66054 8 U------ 648 10756f 4000 4000 100.00
> > > c3e66070 9 U------ 649 10850f 4000 4000 100.00
> > > c3e6608c 10 U------ 650 1094af 4000 4000 100.00