RE: NOLRUPRIO / LRUPRIORITY IDS 7.31_UC2
>>Note we are running unbuffered logging.
>Yup. But you need a bigger log buffer.
OK point taken, thanks for the tip, will increase.
> >>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?
> >>CKPTINTVL 1200
>Try dropping this to 300. Your checkpoints are a bit long.
Will do...
Thanks again for the tips.
Regards
Matthew,.