Upper limit to bufreads?

The subject says it all. Does anyone know what the maximum value for the "bufreads" field in onstat -p output is? From the output below I seemed to have reached it but I'd like to be certain that there aren't other issues lurking in the background. It sure made a mess of my read cache %. TIA. Larry Kemmerling Product Systems Engineer AT&T Wireless Services Aviation Communications Division informix@bear:3 /home1/informix%!! onstat -p Informix Dynamic Server Version 7.31.UC2A -- On-Line -- Up 1 days 03:07:32 -- 1822320 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 3744865 29599073 4010804500 99.91 3798185 5931060 24313745 84.38 isamtot open start read write rewrite delete commit rollbk 3687244532 1480019 13343706 3548376175 2504815 1158956 1917991 1387069 133063 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 313379.15 5499.58 149 298 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 223279 108 104515784 0 0 420 398079 8049 ixda-RA idx-RA da-RA RA-pgsused lchwaits 506748 104967 416751 1004536 25945925 informix@bear:3 /home1/informix%!! onstat -p Informix Dynamic Server Version 7.31.UC2A -- On-Line -- Up 1 days 05:03:54 -- 1822320 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 3827144 29785525 61884553 93.82 3982606 6167107 25377485 84.31 isamtot open start read write rewrite delete commit rollbk 3998363262 1597235 13882027 3852435239 2656275 1269058 1917991 1479062 142581 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 337285.94 5795.33 155 310 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 235929 113 108580974 0 0 428 425459 8355 ixda-RA idx-RA da-RA RA-pgsused lchwaits 542324 110328 416751 1045474 27593103

Since 2^32=4294967296 i assume that bufreads is stored in a 32-Bit variable. Regards Wolf Pichler Larry Kemmerling wrote: > The subject says it all. Does anyone know what the maximum value for > the "bufreads" field in onstat -p output is? From the output below > I seemed to have reached it but I'd like to be certain that there aren't > other issues lurking in the background. > > It sure made a mess of my read cache %. > > TIA. > > Larry Kemmerling > Product Systems Engineer > AT&T Wireless Services > Aviation Communications Division > > informix@bear:3 /home1/informix%!! > onstat -p> > Informix Dynamic Server Version 7.31.UC2A -- On-Line -- Up 1 days 03:07:32 -- 1822320 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 3744865 29599073 4010804500 99.91 3798185 5931060 24313745 84.38 > > isamtot open start read write rewrite delete commit rollbk > 3687244532 1480019 13343706 3548376175 2504815 1158956 1917991 1387069 133063 > > 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 313379.15 5499.58 149 298 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 223279 108 104515784 0 0 420 398079 8049 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 506748 104967 416751 1004536 25945925 > > informix@bear:3 /home1/informix%!! > onstat -p> > Informix Dynamic Server Version 7.31.UC2A -- On-Line -- Up 1 days 05:03:54 -- 1822320 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 3827144 29785525 61884553 93.82 3982606 6167107 25377485 84.31 > > isamtot open start read write rewrite delete commit rollbk > 3998363262 1597235 13882027 3852435239 2656275 1269058 1917991 1479062 142581 > > 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 337285.94 5795.33 155 310 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 235929 113 108580974 0 0 428 425459 8355 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 542324 110328 416751 1045474 27593103 -- Remove the uppercase words from my e-mail address to reply.