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