Hi,
Following is output of onstat -p.
The server is on-line around from last 45 days.
Do you feel is there any performace improvement scope available.

Thanks in advance .


$ onstat -p

IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line (Prim) -- Up 43 days 18:04:09 -- 1555456 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1207777402 1848385703 82131387175 98.53 17938268 60864268 361695842 95.04

isamtot open start read write rewrite delete commit rollbk
78811622900 61914074 4459710405 51686930067 43065538 29180250 12643704 19164560 14472

gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0

ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 1075792.65 207593.41 7492 21881

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
76658318 6894 7940745633 12 0 28515 2539939 31475968

ixda-RA idx-RA da-RA RA-pgsused lchwaits
468742342 290523 19181348 480718889 74544365

$

There certainly may be room for improvement, however, onstat -p does not provide sufficient information to make that determination. IDS is issuing foreground writes, buffer waits are high and there is some sequential scanning going on.

A thorough health check of your system could help you determine what actions can be taken to improve performance.

Christine

If you post your onconfig file others may be able to make suggestions and you may find information at this site that will help:

http://www.oninit.com/

bufwaits is too high.

Use the Buffer Turnover Ratio and Bufwaits Ratio formulas to determine the acceptable ratio.

Hi,

We have restarted server on 26/Jul

following is output for Buffer ration and Buffer Ternover Ration for Last 2 days

Buffer Ration
Last two days Buffer Ration is from 2.75 to 3.62 Prcentrage

Buffer Turnover Rate is

Last two days buffer Trunover rate is 1.07 to 10.15 Percentage

Output from for AIO I/O queues is as per following.



AIO I/O queues:
q name/id len maxlen totalops dskread dskwrite dskcopy
adt 0 0 0 0 0 0 0
msc 0 0 2 182429 0 0 0
aio 0 0 25 99 15 0 0
pio 0 0 1 16937 0 16937 0
lio 0 0 1 46593 0 46593 0
gfd 3 0 3 4240 2665 1575 0
gfd 4 0 2 8763 8763 0 0
gfd 5 0 2 6229 6229 0 0
gfd 6 0 1 13030 13030 0 0
gfd 7 0 2 7399 7399 0 0
gfd 8 0 1 11 11 0 0
gfd 9 0 16 64249 25892 38357 0
gfd 10 0 79 12235675 12044342 191333 0
gfd 11 0 28 12146761 11942366 204395 0
gfd 12 0 1 5 5 0 0
gfd 13 0 1 5 5 0 0
gfd 14 0 26 10396166 10394590 1576 0
gfd 15 0 24 6212951 6180019 32932 0
gfd 16 0 39 582442 560095 22347 0
gfd 17 0 22 8683059 8601889 81170 0
gfd 18 0 21 13356523 13252155 104368 0
gfd 19 0 24 2852414 2687299 165115 0
gfd 20 0 1 5 5 0 0
gfd 21 0 22 148575 127422 21153 0
gfd 22 0 19 1296503 1287295 9208 0