Re: Memory allocation failed during query processing -AIX 5.1

We are on 32-bit. I really doubt that the process is using up 2GB of shared memory....I haven't seen any notices in the log file about any more segments being added or attempted dynamically during this time. This is what I see. Informix Dynamic Server Version 7.31.UD6 -- On-Line -- Up 1 days 16:30:49 -- 334672 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 1 1381386241 30000000 166739968 22248 R 20346 8 2 1381386242 40000000 153600000 2948 V 10350 8400 3 1381386243 50000000 7454720 720 M 905 5 4 1381386244 60000000 7454720 720 M 902 8 5 1381386245 70000000 7454720 720 M 902 8 Total: - - 342704128 - - 33405 8429 C Geier St. Paul, MN <nat@camaratacentral.com> 06/22/2004 12:47 PM To CKGeier@nwc.edu cc Subject Re: Memory allocation failed during query processing -AIX 5.1 Are you on 32-bit or 64-bit AIX? The 32-bit AIX has a limit of 2GB of shared memory per process. It also has a limit of 11 shared memory segments per process. Look at the size and number of your virtual shared memory segments. If you have many of them you may want the change the size of you initial and next virtual shared memory segments. ---- Original message ---- >Date: Tue, 22 Jun 2004 11:56:09 -0500 >From: CKGeier@nwc.edu >Subject: Memory allocation failed during query processing - AIX 5.1 >To: <informix-list@iiug.org> > >A process failed on AIX 5.1, IDS 7.31 UD6 with this error: > >-208 Memory allocation failed during query processing. > >The database server needed to allocate data-space memory in order to >process the query, but none was available. This error may reflect a >hardware limit, an operating-system configuration limit, or a temporary >shortage of space. > >We had PLENTY of memory left so I'm not sure why the process couldn't get >data-space memory. What can I tweak and how can I see the problem >happening? > >C Geier >St. Paul, MN > >sending to informix-list sending to informix-list