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.
PFB the onstat -p output and my thoughts on the same. Please provide your
valuable inputs.
The %cached for buffered read is a low number?it should be well above 95%.
Adding more buffers should solve this problem.
bufwaits can be brought down by reducing the RA_PAGES and RA_THRESHOLD.
params.This can be further checked from the RA stats below?.RA-pgsused is
greater than sum of ixda-RA ids-RA n da-RA
onstat ?p
IBM Informix Dynamic Server Version 9.30.FC6W4 -- On-Line -- Up 8 days
10:22:5
0 -- 1746404 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1525587639 2242129221 16409885204 90.70 13386474 31272626 96935964 86.19
isamtot open start read write rewrite delete commit
rollbk
16611229372 161354924 870540973 12672021046 19719184 21971728 1518044
10158667
12809
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
706929 14664 3254021 14152 0 0 4
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 102375.25 31659.65 608 1801
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
131086405 5097807 2429049027 3 0 903 1938576 94027
ixda-RA idx-RA da-RA RA-pgsused lchwaits
38469248 109333718 748405431 894562606 4758183
--
Message posted via http://www.dbmonster.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.