RE: buffer usage

No one else seems to have responded so I will share my guesses. There are quite a few views in the sysmaster. If you were collecting other statistical information from the sysmast er it is quite likely the partnum 0 usage might have been the monitoring. Run oncheck -pe and this number seems to go up as well. 3% does not seem like a large number of your buffers either. Will >===== Original Message From "Parker, J" <JParker@WescoDist.com> ===== >Was hoping all you geniuses could lend a hand. > >Thanks in advance > >onstat -P>shows a large usage of buffers (14,874) on our system to be associated with >partnum=0 >i.e. >here's a summary of onstat -P, reverse sort on total buffers >partnum Total Btree Data Other Resident Dirty > >2098060 86106 16023 70082 1 0 0 >7340034 69052 735 68315 2 0 1 >2098155 57817 863 56954 0 0 0 >9437187 48451 2138 46312 1 0 24 >8388613 22969 0 22969 0 0 0 >13631502 15008 15008 0 0 0 1 >0 14874 866 2164 11844 0 268 >... > >Totals: 450000 115041 322918 12041 0 6920 > >Percentages: >Data 71.76 >Btree 25.56 >Other 2.68 > >I query systables for partnum =0 and get: > > partnum tabid tabname tabtype flags > > 0 90 GL_COLLATE 0 > 0 91 GL_CTYPE 0 > 0 99 VERSION 0 > 0 1608 stgkmstr V 0 > 0 1077 stgamstr V 0 > 0 1078 stxcolsv V 0 > 0 1609 stgcmstr V 0 > > >What is happening with partnum=0 taking so many buffers? The views are not >commonly used. >Is there anything special about partnum=0 for the engine? >Why are multiple entities all associated with partnum=0 ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------