Buffer Turnover Ratio (BTR)

Hello, Can anybody explain that what is meant by the variable 'elasped' in the below mentioned formula. Which value should I put against this variable? I guess its the total # of hours that a instance is online/Up. BTR = (((bufwrits + pagreads) / BUFFERS) / elapsed) Regards, Anees Ahmad

The 'elapsed' is the fractional hours since the server was started or since the last time that onstat -z was run to zero out the statistics. So if your server has been online for 15 days 10 hours and 18 minutes and stats haven't been zero'd since then: elapsed = ((15 * 24) + 10.3) = 370.3 The results of the BTR calculation therefore are expressed in (cache) turns per hour. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Apr 22, 2009 at 3:28 AM, ANEES AHMAD <aanees@i2cinc.com> wrote: > Hello, > > Can anybody explain that what is meant by the variable 'elasped' in the > below > mentioned formula. Which value should I put against this variable? > > I guess its the total # of hours that a instance is online/Up. > > BTR = (((bufwrits + pagreads) / BUFFERS) / elapsed) > > Regards, > Anees Ahmad > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b52be3581504682634da

Art Thanks for the information. Consider the following two blocks of outputs from the instance-1 and instance-2 two. -------------------- Instance-1 BR=0.565 RAU=98.6 BTR=7.36 BUFFERPOOL size=2K,buffers=120000,lrus=46,lru_min_dirty=50.000000,lru_max_dirty=60.000000 -------------------- Instance 2 BR=1.99 RAU=99.88 BTR=2137 BUFFERPOOL size=2K,buffers=6000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000 --------------------- The point which is disturbing me a lot is that the Instance-2 is showing very good query/procedural performance where as the Instance-1 is showing very bad performance and DB requests are getting timed out. Does it mean that the bufferpool and LRU settings of Insatnce-1 are still not tuned? Why the Insatace-2 with too few buffers is showing good performance? The load of activities is very high at Instance-2 as compared to Instance-1. Say if Instance-2 is executing 15000 requests a day then Insartance-1 is just executing less than 500 requests a day. Where might be the bottle neck? Same application is deployed on both instances. The difference is only that Instance-1 is running with 4 databases with 821 maximum concurrent Instance-2 is running with only 1 database with 308 maximum concurrent. See the following outputs of onstat -p for both instances Instance-1 IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 19 days 21:40:28 -- 1548288 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 62227661 362878768 5326958137 98.83 9279279 19347443 59636292 87.01 isamtot open start read write rewrite delete commit rollbk 4369875770 204876627 363233569 2906055279 7540938 3295430 506526 3119073 492 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 347692.07 42132.09 5704 5735 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 2390527 2412 4432863050 0 0 614 3508280 13477435 ixda-RA idx-RA da-RA RA-pgsused lchwaits 10370317 53200 15847828 25901168 1221946 ----------------------------------------------------------------------------- Instance-2 IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 34 days 20:46:59 -- 1527808 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 7668590970 10289375428 42917152205 82.13 45635154 136785986 442875348 90.43 isamtot open start read write rewrite delete commit rollbk 39605469811 351650681 818427987 34798426922 40611296 15311936 6025699 19016271 6137 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 3634949.86 865140.29 10836 11129 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 213692299 14652 42599333339 0 0 3572 30374193 103282201 ixda-RA idx-RA da-RA RA-pgsused lchwaits 1445033543 1565761 701870740 2145951638 130851848

Both instances are running on the same machine and the same environment. Instance-1 with 821 maximum concurrent connections. Instance-2 with 308 maximum concurrent connections.

You obviously have something other than a buffer cache problem going on in the instance#1. You can try posting other information and we'll try to help, but I suspect that this is going to take a deeper analysis. If you are interested in having someone look into this for you, contact me directly to my email (art@oninit.com) and we'll work that out. Meanwhile, post the following: onstat -p onstat -P onstat -D onstat -d onstat -g iov onstat -g glo onstat -c onstat -g iof The community will take a look and see if there's anything obvious there and try to help. Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Apr 23, 2009 at 7:17 AM, ANEES AHMAD <aanees@i2cinc.com> wrote: > Art Thanks for the information. > > Consider the following two blocks of outputs from the instance-1 and > instance-2 two. > > -------------------- > Instance-1 > > BR=0.565 > RAU=98.6 > BTR=7.36 > > BUFFERPOOL> > size=2K,buffers=120000,lrus=46,lru_min_dirty=50.000000,lru_max_dirty=60.000000 > > -------------------- > > Instance 2 > > BR=1.99 > RAU=99.88 > BTR=2137 > > BUFFERPOOL > size=2K,buffers=6000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000> > --------------------- > > The point which is disturbing me a lot is that the Instance-2 is showing > very > good query/procedural performance where as the Instance-1 is showing very > bad > performance and DB requests are getting timed out. > Does it mean that the bufferpool and LRU settings of Insatnce-1 are still > not > tuned? Why the Insatace-2 with too few buffers is showing good performance? > The load of activities is very high at Instance-2 as compared to > Instance-1. > Say if Instance-2 is executing 15000 requests a day then Insartance-1 is > just > executing less than 500 requests a day. > Where might be the bottle neck? Same application is deployed on both > instances. > The difference is only that > Instance-1 is running with 4 databases with 821 maximum concurrent > Instance-2 is running with only 1 database with 308 maximum concurrent. > > See the following outputs of onstat -p for both instances > > Instance-1 > IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 19 > days 21:40:28 -- 1548288 Kbytes> > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 62227661 362878768 5326958137 98.83 9279279 19347443 59636292 87.01 > > isamtot open start read write rewrite delete commit rollbk > 4369875770 204876627 363233569 2906055279 7540938 3295430 506526 3119073 > 492 > > 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 347692.07 42132.09 5704 5735 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 2390527 2412 4432863050 0 0 614 3508280 13477435 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 10370317 53200 15847828 25901168 1221946 > > > ----------------------------------------------------------------------------- > > Instance-2 > > IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 34 > days 20:46:59 -- 1527808 Kbytes> > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 7668590970 10289375428 42917152205 82.13 45635154 136785986 442875348 90.43 > > isamtot open start read write rewrite delete commit rollbk > 39605469811 351650681 818427987 34798426922 40611296 15311936 6025699 > 19016271 > 6137 > > 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 3634949.86 865140.29 10836 11129 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 213692299 14652 42599333339 0 0 3572 30374193 103282201 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 1445033543 1565761 701870740 2145951638 130851848 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b31486ae03046837dc20

The Outputs are as follows onstat -g iov IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:38:57 -- 1548288 Kbytes AIO I/O vps:class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors tempops msc 0 i 0.7 1147469 0 0 0 1144991 1.0 0 1147469 aio 0 i 21.6 37452469 35650434 1801668 0 36708958 1.0 0 1988 aio 1 i 3.1 5384505 5150842 233649 0 5445682 1.0 0 516 aio 2 i 0.5 842074 662674 179393 0 719715 1.2 0 25 aio 3 i 0.3 463958 296716 167237 0 342645 1.4 0 5 aio 4 i 0.2 363956 205779 158176 0 261226 1.4 0 3 aio 5 i 0.2 316479 165640 150837 0 231247 1.4 0 3 aio 6 i 0.2 284546 139390 145154 0 211520 1.3 0 3 aio 7 i 0.1 252649 113369 139278 0 195123 1.3 0 2 aio 8 i 0.1 227720 93375 134344 0 180255 1.3 0 2 aio 9 i 0.1 207336 77346 129989 0 167261 1.2 0 1 aio 10 i 0.1 187348 61945 125403 0 153269 1.2 0 1 aio 11 i 0.1 169746 48705 121041 0 140114 1.2 0 1 aio 12 i 0.1 153348 37234 116114 0 126177 1.2 0 2 aio 13 i 0.1 139891 27808 112083 0 112298 1.2 0 1 aio 14 i 0.1 127518 20165 107353 0 98372 1.3 0 1 aio 15 i 0.1 116687 14639 102048 0 84006 1.4 0 1 aio 16 i 0.1 109887 10370 99517 0 69367 1.6 0 1 aio 17 i 0.1 104409 7060 97349 0 59116 1.8 0 2 aio 18 i 0.1 102756 5422 97334 0 50101 2.1 0 2 pio 0 i 0.0 32898 0 32898 0 32899 1.0 0 32898 lio 0 i 1.8 3168308 0 3168308 0 3168305 1.0 0 3168308 onstat –c IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:39:37 -- 1548288 Kbytes Configuration File: /u/informix11.5-3/etc/onconfig_01 #################################################################### Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # Copyright IBM Corporation 1996, 2008 All rights reserved. # # Title: onconfig.std # Description: IBM Informix Dynamic Server Configuration Parameters # # Important: $INFORMIXDIR now resolves to the environment # variable INFORMIXDIR. Replace the value of the INFORMIXDIR # environment variable only if the path you want is not under # $INFORMIXDIR. # # For additional information on the parameters: # http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp ################################################################### ################################################################### # Root Dbspace Configuration Parameters ################################################################### # ROOTNAME - The root dbspace name to contain reserved pages and # internal tracking tables. # ROOTPATH - The path for the device containing the root dbspace # ROOTOFFSET - The offset, in KB, of the root dbspace into the # device. The offset is required for some raw devices. # ROOTSIZE - The size of the root dbspace, in KB. The value of # 200000 allows for a default user space of about # 100 MB and the default system space requirements. # MIRROR - Enable (1) or disable (0) mirroring # MIRRORPATH - The path for the device containing the mirrored # root dbspace # MIRROROFFSET - The offset, in KB, into the mirrored device # # Warning: Always verify ROOTPATH before performing # disk initialization (oninit -i or -iy) to # avoid disk corruption of another instance ################################################################### ROOTNAME rootdbs_01 ROOTPATH /u1/ids_space/rootdbs_01 ROOTOFFSET 0 ROOTSIZE 256000MIRROR 0 MIRRORPATH MIRROROFFSET 0 ################################################################### # Physical Log Configuration Parameters ################################################################### # PHYSFILE - The size, in KB, of the physical log on disk. # If RTO_SERVER_RESTART is enabled, the # suggested formula for the size of PHSYFILE # (up to about 1 GB) is: # PHYSFILE = Size of BUFFERS * 1.1 # PLOG_OVERFLOW_PATH - The directory for extra physical log files # if the physical log overflows during recovery # or long transaction rollback # PHYSBUFF - The size of the physical log buffer, in KB ################################################################### PHYSFILE 150000 PLOG_OVERFLOW_PATH PHYSBUFF 256 ################################################################### # Logical Log Configuration Parameters ################################################################### # LOGFILES - The number of logical log files # LOGSIZE - The size of each logical log, in KB # DYNAMIC_LOGS - The type of dynamic log allocation. # Acceptable values are: # 2 Automatic. IDS adds a new logical log to the # root dbspace when necessary. # 1 Manual. IDS notifies the DBA to add new logical # logs when necessary. # 0 Disabled # LOGBUFF - The size of the logical log buffer, in KB ################################################################### LOGFILES 23 LOGSIZE 50000 DYNAMIC_LOGS 0 LOGBUFF 256 ################################################################### # Long Transaction Configuration Parameters ################################################################### # If IDS cannot roll back a long transaction, the server hangs # until more disk space is available. # # LTXHWM - The percentage of the logical logs that can be # filled before a transaction is determined to be a # long transaction and is rolled back # LTXEHWM - The percentage of the logical logs that have been # filled before the server suspends all other # transactions so that the long transaction being # rolled back has exclusive use of the logs # # When dynamic logging is on, you can set higher values for # LTXHWM and LTXEHWM because the server can add new logical logs # during long transaction rollback. Set lower values to limit the # number of new logical logs added. # # If dynamic logging is off, set LTXHWM and LTXEHWM to # lower values, such as 50 and 60 or lower, to prevent long # transaction rollback from hanging the server due to lack of # logical log space. # # When using Enterprise Replication, set LTXEHWM to at least 30% # higher than LTXHWM to minimize log overruns. ################################################################### LTXHWM 50 LTXEHWM 60 ################################################################### # Server Message File Configuration Parameters ################################################################### # MSGPATH - The path of the IDS message log file # CONSOLE - The path of the IDS console message file ################################################################### MSGPATH /u/informix11.5-3/online_01.log CONSOLE /u/informix11.5-3/online_01.con ################################################################### # Tblspace Configuration Parameters ################################################################### # TBLTBLFIRST - The first extent size, in KB, for the tblspace # tblspace. Must be in multiples of the page size. # TBLTBLNEXT - The next extent size, in KB, for the tblspace # tblspace. Must be in multiples of the page size. # The default setting for both is 0, which allows IDS to manage # extent sizes automatically. # # TBLSPACE_STATS - Enables (1) or disables (0) IDS to maintain

The Remaining outputs are as follows onstat –d IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:38:41 -- 1548288 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 11c65c028 1 0x40001 1 2 2048 N B informix rootdbs_05 11e43e588 2 0x40001 2 6 2048 N B informix datadbs_05 11e43e720 3 0x40001 3 1 2048 N B informix logdbs_05 11e43e8b8 4 0x42001 4 1 2048 N TB informix tempdbs_05 11e43ea50 5 0x40001 5 2 2048 N B informix datadbs_ 11e43ebe8 6 0x40001 6 2 2048 N B informix datadbs_07 11e43ed80 7 0x40001 7 2 2048 N B informix datadbs_01 11e43f028 8 0x40001 8 4 2048 N B informix datadbs_08 8 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 11c65c1c0 1 1 0 128000 24029 PO-B /u1/ids_space/rootdbs_05 11e43f3a8 2 2 0 1024000 160 PO-B /u1/ids_space/datadbs_05 11e43f590 3 3 0 1024000 51147 PO-B /u1/ids_space/logdbs_05 11e43f778 4 4 0 1024000 1023847 PO-B /u1/ids_space/tempdbs_05 11e43f960 5 5 0 1024000 1020997 PO-B /u1/ids_space/datadbs_ 11e43fb48 6 6 0 1024000 121878 PO-B /u1/ids_space/datadbs_07 11e43fd30 7 7 0 1024000 189343 PO-B /u1/ids_space/datadbs_01 11e440028 8 8 0 1024000 75 PO-B /u1/ids_space/datadbs_08 11e440210 9 2 0 512000 89 PO-B /u1/ids_space/datadbs_05_1 11e4403f8 10 2 0 512000 38 PO-B /u1/ids_space/datadbs_05_2 11e4405e0 11 7 0 1024000 1023997 PO-B /u2/ids_space/datadbs_01_1 11e4407c8 12 6 0 512000 511997 PO-B /u2/ids_space/datadbs_07_1 11e4409b0 13 2 0 1024000 23 PO-B /u3/ids_space/datadbs_05_3 11e440b98 14 8 0 1024000 17 PO-B /u1/ids_space/datadbs_08_1 11e440d80 15 5 0 512000 511997 PO-B /u3/ids_space/datadbs__1 11e445028 16 2 0 512000 16003 PO-B /u3/ids_space/datadbs_05_4 11e43f1c0 17 1 0 256000 176055 PO-B /u4/ids_space/rootdbs_05_1 11e445210 18 2 0 1024000 998397 PO-B /u4/ids_space/datadbs_05_5 11e4453f8 19 8 0 1024000 626591 PO-B /u4/ids_space/datadbs_08_2 12e006c50 20 8 0 1024000 1023997 PO-B /u4/ids_space/datadbs_08_3 20 active, 32766 maximum NOTE: The values in the "size" and "free" columns for DBspace chunks are displayed in terms of "pgsize" of the DBspace to which they belong. Expanded chunk capacity mode: always onstat –g glo IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:39:10 -- 1548288 Kbytes MT global info: sessions threads vps lngspins 686 845 70 18300 sched calls thread switches yield 0 yield n yield forever total: 878219248 486240727 387316958 101196202 94407372 per sec: 830 61 764 33 8 Virtual processor summary: class vps usercpu syscpu total cpu 23 339920.19 15664.65 355584.84 aio 19 3794.60 10940.91 14735.51 tli 23 6899.30 13864.57 20763.87 lio 1 238.30 908.07 1146.37 pio 1 20.03 255.10 275.13 adm 1 620.15 1018.74 1638.89 msc 1 111.38 88.34 199.72 encrypt 1 117.60 67.74 185.34 total 70 351721.55 42808.12 394529.67 Individual virtual processors: vp pid class usercpu syscpu total Thread Eff 1 10455 cpu 69954.32 3166.11 73120.43 126956.87 57% 2 10456 adm 620.15 1018.74 1638.89 0.00 0% 3 10607 cpu 62999.97 2074.48 65074.45 123887.64 52% 4 10689 cpu 34804.47 1292.09 36096.56 61725.86 58% 5 10697 cpu 20847.83 874.99 21722.82 32245.47 67% 6 10716 cpu 13818.35 630.37 14448.72 18597.55 77% 7 10748 cpu 10683.19 527.99 11211.18 13227.50 84% 8 10766 cpu 9575.84 501.81 10077.65 11119.82 90% 9 10787 cpu 9062.19 477.82 9540.01 10097.05 94% 10 10810 cpu 8103.15 451.35 8554.50 9244.25 92% 11 10824 cpu 8612.85 480.33 9093.18 9323.98 97% 12 10847 cpu 8784.05 491.57 9275.62 9449.85 98% 13 10864 cpu 8932.42 503.94 9436.36 9625.69 98% 14 10891 cpu 8805.64 518.35 9323.99 9448.45 98% 15 10917 cpu 8855.45 488.15 9343.60 9497.41 98% 16 10939 cpu 8207.39 478.09 8685.48 8786.32 98% 17 10964 cpu 8827.14 464.70 9291.84 9430.97 98% 18 10988 cpu 8191.54 461.32 8652.86 8725.33 99% 19 11012 cpu 7620.54 413.43 8033.97 8072.94 99% 20 11033 cpu 6504.71 376.44 6881.15 6881.15 100% 21 11056 cpu 5054.70 300.27 5354.97 5354.97 100% 22 11080 cpu 4979.28 274.84 5254.12 5254.12 100% 23 11095 cpu 3887.50 228.47 4115.97 4115.97 100% 24 11123 cpu 2807.67 187.74 2995.41 2995.41 100% 25 11149 lio 238.30 908.07 1146.37 2840.68 40% 26 11163 pio 20.03 255.10 275.13 766.67 35% 27 11165 aio 2581.19 7584.26 10165.45 25255.37 40% 28 11166 msc 111.38 88.34 199.72 256.31 77% 29 11167 aio 563.53 1495.07 2058.60 4859.64 42% 30 11236 tli 371.43 713.67 1085.10 NA NA 31 11237 tli 414.88 789.71 1204.59 NA NA 32 11238 tli 290.32 601.61 891.93 NA NA 33 11239 tli 248.76 542.84 791.60 NA NA 34 11240 tli 256.64 556.65 813.29 NA NA 35 11241 tli 233.46 512.90 746.36 NA NA 36 11242 tli 290.18 612.59 902.77 NA NA 37 11243 tli 283.87 584.40 868.27 NA NA 38 11245 tli 230.42 523.54 753.96 NA NA 39 11246 tli 246.20 531.78 777.98 NA NA 40 11247 tli 369.37 708.78 1078.15 NA NA 41 11248 tli 344.66 672.22 1016.88 NA NA 42 11249 tli 248.23 538.13 786.36 NA NA 43 11250 tli 238.91 536.64 775.55 NA NA 44 11251 tli 317.00 626.01 943.01 NA NA 45 11252 tli 288.16 589.10 877.26 NA NA 46 11254 tli 424.90 767.32 1192.22 NA NA 47 11255 tli 303.07 617.35 920.42 NA NA 48 11256 tli 327.40 571.46 898.86 NA NA 49 11257 tli 391.93 595.11 987.04 NA NA 50 11258 tli 238.88 533.98 772.86 NA NA 51 11259 tli 272.06 571.63 843.69 NA NA 52 11260 tli 268.57 567.15 835.72 NA NA 53 11284 aio 96.43 250.25 346.68 1642.14 21% 55 11285 aio 48.79 139.86 188.65 961.36 19% 54 11286 aio 59.00 162.09 221.09 1142.37 19% 57 11287 aio 41.03 115.49 156.52 883.54 17% 56 11288 aio 44.35 126.91 171.26 914.50 18% 58 11289 aio 38.75 110.84 149.59 862.52 17% 59 11290 aio 36.48 106.33 142.81 844.78 16% 60 11291 aio 34.80 98.98 133.78 830.30 16% 61 11292 aio 33.19 97.90 131.09 809.75 16% 69 11293 aio 24.07 74.22 98.29 583.26 16% 65 11294 aio 28.51 86.11 114.62 726.86 15% 62 11295 aio 31.34 90.70 122.04 786.28 15% 64 11296 aio 27.09 81.40 108.49 689.19 15% 66 11297 aio 26.13 77.36 103.49 633.32 16% 67 11298 aio 25.38 75.86 101.24 609.05 16% 68 11300 aio 24.54 75.59 100.13 593.51 16% 63 11301 aio 30.00 91.69 121.69 760.02 16% 70 16531 encrypt 117.60 67.74 185.34 185.34 100% tot 351721.55 42808.12 394529.67 onstat –g iof IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:39:54 -- 1548288 Kbytes AIO global files: gfd pathname bytes read page reads bytes write page writes io/s 3 rootdbs_05 62877841408 29950534 1226792960 599020 2246.1 op type count avg. time seeks 0 N/A reads 1117870 0.0003 writes 451955 0.0008 kaio_reads 0 N/A kaio_writes 0 N/A 4 rootdbs_05_1 250718208 122421 7672055808 3746121 128.8 op type count avg. time seeks 0 N/A reads 53485 0.0009 writes 53305 0.0147 kaio_reads 0 N/A kaio_writes 0 N/A 5 datadbs_05 64660652032 31545603 422496256 206297 1144.7 op type count avg. time seeks 0 N/A reads 5495343 0.0007 writes 182463 0.0055 kaio_reads 0 N/A kaio_writes 0 N/A 6 logdbs_05 322599147520 153630372 7473649664 3649243 1888.9 op type count a