Re: tbstat -p - bufreads -ve value and %cached is zero

Cynthia Leong (cynthia@hpsgcip1.sgp.hp.com) wrote: : Hi netters, : I'm currently facing a strange happening..... : Just recently, I've found out that the statistics shown with <stuff deleted) : Thanks in advance. : regards, : cynthia leong : Hewlett-Packard, Singapore : cynthia@hpsgcip1.sgp.hp.com Cynthia, You're getting an overflow condition on the integers for your bigger numbers. Indicates that your system has been up for a looooooooong time without either being shut down or having a tbstat -z. This probably has no real effect on your ***real*** performance, but the large numbers are confusing tbstat. Either shut down and restart (not a bad idea anyway just to clear out the cobwebs occasionally) or run a tbstat -z. Run a tbcheck -pe > last_tbcheckpe and look at the last_tbcheckpe file. I wouldn't be surprised to see a lot of table fragmentation. There doesn't seem to be any real problem in your tbstat -p output. Your write cache ratio is a little low, but within reason. Has anything changed in your system recently? Joe -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) BancTec Service Corportation 214-450-9894 Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================