Re: Memory allocation failed during query processing -AIX 5.1

CKGeier@nwc.edu wrote: > here is what we have in our onconf file: > > # Parallel Database Queries (pdq) > MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority (was 100) > [...] > "Savio Pinto (s)" <spinto@cap.org> wrote: >> have you turned on PDQ?, is the DS_TOTAL_MEMORY set greater than >> SHMTOTAL in the onconfig?. Also, may need to check SHMADD >> onconfig parameter. > > -----Original Message----- > From: CKGeier@nwc.edu > > 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? Is SHMBASE set correctly? If it is set wrong (and wrong can be too high, too low, zero, or non-zero, depending on platform), then the shared memory can interfere with other memory allocations, leading to error -208. Look in the machine notes (in $INFORMIXDIR/release/en_us/0333) for guidance. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/