RE: logical logs at 100%
Do a continuous logical log backup to /dev/null and do a REAL LEVEL 0
archive. This will protect you in case while they are fixing the legato
system the system crashes you will have a full archive
Howard E. Rock
Informix Database Administrator
Insurance Services Office
2 Blue Hill Plaza
Pearl River, NY 10965
Email - hrock@iso.com <mailto:hrock@iso.com>
Telephone # 914-620-4088
Fax # 914-620-4050
----------
From: edward rosenthal [SMTP:erosenthal@mfi.com]
Sent: Tuesday, July 13, 1999 1:47 PM
To: informix-list@iiug.org
Subject: logical logs at 100%
This is a multi-part message in MIME format.
--------------3DF6D6DDAC8B6B37EC579C37
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
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
--------------3DF6D6DDAC8B6B37EC579C37
Content-Type: text/x-vcard; charset=us-ascii;
name="erosenthal.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for edward rosenthal
Content-Disposition: attachment;
filename="erosenthal.vcf"
begin:vcard
n:Rosenthal;Edward
tel;pager:(888) 274-7679@skytel.com
tel;cell:(707) 332-5558
tel;home:(707) 782-0766
tel;work:(415) 905-2431
x-mozilla-html:FALSE
url:www.mfi.com
org:Miller Freeman Inc.;Web Services
adr:;;600 Harrison St.;San Fransisco;California;94107;USA
version:2.1
email;internet:erosenthal@mfi.com
title:Database Administrator
fn:Ed Rosenthal
end:vcard
--------------3DF6D6DDAC8B6B37EC579C37--