RE: NOLRUPRIO / LRUPRIORITY IDS 7.31_UC2

From: "Matthew Byrne" <Matthew_Byrne@fmi.com> > > >>SHMVIRTSIZE 625000> > >Wow! That's quite big -- what's the output from onstat -g seg? > > > >Yes I know, but by the end of the day and or while running ontape and or >if > >we don't monitor it and run the occasional onmode -F it comes very very > >close to adding another segment, which is a bad thing when there's no >more > >free memory and your running HP KAIO. <ask me how I know this> > >So what does onstat -g seg say? > >Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 1 days >11:30:37 -- 1265160 Kbytes > >Segment Summary: >id key addr size ovhd class blkused blkfree >5 1381451778 80000000 640016384 10376 V 59487 18640 >66564 1381451777 c0cc4000 655507456 10916 R 80012 6 >6 1381451779 e7de8000 1130496 628 M 138 0 >7 1381451780 e7efc000 1130496 628 M 133 5 >8 1381451781 e8010000 1130496 628 M 131 7 >9 1381451782 e8124000 1130496 628 M 131 7 >10 1381451783 e8238000 1130496 628 M 131 7 >11 1381451784 e834c000 1130496 628 M 131 7 >12 1381451785 e8460000 1130496 628 M 131 7 >13 1381451786 e8574000 1130496 628 M 131 7 >14 1381451787 e8688000 1130496 628 M 131 7 >Total: - - 1305698304 - - 140687 18700 > > > > >Wouldn't you be better off decreasing this and giving more BUFFERS? > >I can keep a fair amount of blkfree by running onmode -F once or twice a >day, this would allow me to decrease SHMVIRTSIZE and increase BUFFERS does >that sound like a fair thing to do? Any downside of running onmode -F in >cron? Sounds like a good idea to me. Just make sure you have the right environment for your onmode -F. > > >>CKPTINTVL 1200> > >Try dropping this to 300. Your checkpoints are a bit long. > >Will do... >Thanks again for the tips. >Regards >Matthew,. > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.