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.
Brian Hampson — — source: Informix-list mailing list archive (1991-1998)
It appears, from an onstat -p, that about my only bottlenecks is
"bufwaits"
Is there a way that I can reduce the waits? What parameter needs to be
twiddled?
Onstat -p output (note some numbers have rolled over..showing incorrect
cache numbers)
INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 41 days 22:38:10 -- 57984 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
25560000 63513837 36185941 29.36 8964466 35165552 122598911 92.69
isamtot open start read write rewrite delete commit rollbk
2414132832 27171184 136937552 1757719100 35850121 1755389 473948 1849956 9
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 441158.86 89765.19 1879 8040
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
3005610 936 3233912260 2 0 2109 7633098 3122129
ixda-RA idx-RA da-RA RA-pgsused lchwaits
6626719 47054 2294107 8903552 524623
--
Please send administrative requests to admin@ASL.CA
Brian P. Hampson ASL Analytical Service Laboratories Ltd
System Administrator, Vancouver, BC (604)253-4188
----------------- http://www.ASL.CA/ ----------------------------
*****Help Support the 40th Marpole Scouts' Fundraising Drive!!*****
Buy Delicious Top Grade Popcorn and Help Send a Scout to Camp!!!
Email me for details!!
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.