Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.