RE: Assistance with getting DB memory usage over 2 gigs

Have you looked in your release notes? ($INFORMIXDIR/release/en_us/0333/ids_unix_release.....) The maximum shared memory segment size for UC should say 2Gb, and for FC 4Tb. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of > shaun.patrick.wallace@gmail.com > Sent: Wednesday, 7 September 2005 11:37 p.m. > To: informix-list@iiug.org > Subject: Re: Assistance with getting DB memory usage over 2 gigs > > Ok, I finally figured out what is happening. > > Shared memory base is currently set to 0x50000000L this is in > hex, translating this back to decimal we get 1342177280 bytes > (1.28 gigs) as the starting address for memory usage within > the process space for the database. 32 Bit Linux allows for 4 > gigs to be addressed by a process: > 1 gig is reserved for kernel and 3 gigs for user. Since we > set the start base address to 0x50000000L we have 3 gig - > 1.28 gig = 1.72 gigs available for database memory! > > Does this mean the only way I can use more is by pushing > mapped base address for the currently started process down? > > Are there any other ways of having more memory available to > the database as it is frequently running low on memory and > trying to allocate more than is available. It did this when I > had SHMTOTAL set to 0 or 3500000, I am currently trying to > limit this by setting the value to 1800000 to keep it within > the limit. > > Obviously I'd like the database to be able to use more of the > currently available memory. Would I need to run seperate > instances to achieve this? sending to informix-list

I looked in those release notes but I couldn't find anything relating to memory limitations. I know the the machine notes said I could increase usage to 2.5Gb by changing the mapped base address.