RE: onstat -p Funny
Payl,
Just make 'onstat -z' to correct the problem,
which is caused by the 'bufreads' couter overflow
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: Paul Watson [mailto:paul@oninit.com]
> Sent: Saturday, October 04, 2003 6:59 AM
> To: informix-list@iiug.org
> Subject: onstat -p Funny
>
> OS: Solaris 9
>
> Everything is working fine, no problems as far I can tell then
> all of a sudden our monitoring picks up a read cache drop and
> I get the following onstat -p. The DBserver is for a website,
> traffic levels haven't changed, and there are no background jobs,
> and I'm seeing very little disk activity but the cache still
> reads 0%. The stats have not be cleared down
>
> Any ideas
>
> informix: onstat -p
>
> Informix Dynamic Server Version 9.40.UC1 -- On-Line -- Up 17 days
> 22:08:25 -- 2493440 Kbytes
>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 194114421 312676058 177660467 0.00 39720009 67800818 485224646 91.81
>
> isamtot open start read write rewrite delete commit
> rollbk
> 827519294 710678029 1555618190 1316756590 153621187 53758451 29505132
> 19735797 4021
>
> gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> 26 0 0 0 0 0 0
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 7 0 0 699372.01 77315.73 1378 3785
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 10238808 14188 2996100352 0 0 1737 2063363 1506506
>
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
> 9209658 16758888 27476541 51934399 6011213
>
>
>
> --
> Paul Watson #
> Oninit Ltd # Growing old is mandatory
> Tel: +44 1436 672201 # Growing up is optional
> Fax: +44 1436 678693 #
> Mob: +44 7818 003457 #
> www.oninit.com #
sending to informix-list