Re: Shared Memory allocation error

<SNIP> > I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. > When I run a query on a view that joins many tables online begins > allocating additional shared memory until it hits an illegal address. <SNIP> > SHMVIRTSIZE 8000 # initial virtual shared memory segmentsize > SHMADD 8192 # Size of new shared memory segments (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited > Thanks,> > > Mark Stannard > Ameritech > Indianapolis, IN 46204 > > > From what I remember reading in this group a little while ago you might try increasing the SHMVIRTSIZE 8000 # initial virtual shared memory segment and SHMADD 8192 # Size of new shared memory segments I seem to recall that you should size the SHMVIRTSIZE so that additional memory segments are only added very occasionally, if at all. There was also a suggestion that there is a limited number of shared memory segments that can be added. Remember that these additional segments are not freed when they are no longer in use, onmode -F will free them, perhaps run from cron.(RTFM) Have you checked in deja news http://www.dejanews.com Peter Brueton