onstat -p

The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 20795263 58934860 20848973036 99.90 93132867 49158773 167127066 44.34 isamtot open start read write rewrite delete commit rollbk 17987109280 435591414 483314376 15084500284 20461897 38698023 13258836 44840774 7236 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 22015 5134 61297 4633 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 150746.95 45588.85 2325 4650 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 429970 52799 16725001373 0 0 2683 2754044 2928429 ixda-RA idx-RA da-RA RA-pgsused lchwaits 1278775 497465 1742174 2935546 25715219

2683 sessions had to pause during 2325 checkpoints. No conflict. Some checkpoints nothing waits, some many sessions are blocked. Art S. Kagel ----- Original Message ----- From: Frank <ids@iiug.org> At: 3/21 16:16:06 The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 20795263 58934860 20848973036 99.90 93132867 49158773 167127066 44.34 isamtot open start read write rewrite delete commit rollbk 17987109280 435591414 483314376 15084500284 20461897 38698023 13258836 44840774 7236 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 22015 5134 61297 4633 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 150746.95 45588.85 2325 4650 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 429970 52799 16725001373 0 0 2683 2754044 2928429 ixda-RA idx-RA da-RA RA-pgsused lchwaits 1278775 497465 1742174 2935546 25715219 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.