Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Paul Watson — — source: Usenet: comp.databases.informix
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 #
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.