Re: informix logical logfiles
I suspect either you just restarted your database engine or may have
run onstat -z which might? zero out these statistics. Are either
of these true?
-Bill
}
} > We use informix online 7.11 and I think our applicaton behave a bit strange.
} >
} > After
} > onstat -l
} >
} > Buffer bufused bufsize numpages numwrits pages/io
} > P-1 0 16 0 0 0.00
} > phybegin physize phypos phyused %used
} > 108b75 10000 5728 0 0.00
} >
} > Logical Logging
} > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
} > L-2 0 16 1 1 1 1.0 1.0
} >
} > address number flags uniqid begin size used %used
} > c09bd218 1 U-B---- 829 1013c7 2500 2500 100.00
} > c09bd234 2 U-B---- 830 101d8b 2500 2500 100.00
} > c09bd250 3 U-B---- 831 10274f 2500 2500 100.00
} > c09bd26c 4 U-B---- 832 103113 2500 2500 100.00
} > c09bd288 5 U-B---- 833 103ad7 2500 2500 100.00
} > c09bd2a4 6 U-B---- 834 10449b 2500 2500 100.00
} > c09bd2c0 7 U-B---- 835 104e5f 2500 2500 100.00
} > c09bd2dc 8 U-B---- 836 105823 2500 2500 100.00
} > c09bd2f8 9 U-B---- 837 1061e7 2500 2500 100.00
} > c09bd314 10 U-B---- 838 106bab 2500 2500 100.00
} > c09bd330 11 U---C-L 839 10756f 2500 1704 68.16
} > c09bd34c 12 U-B---- 828 107f33 2500 2500 100.00
} >
} > is this normal?
} >
}
}
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com ennis@accesschicago.net