RE: Memory allocation failed during query processing -AIX 5.1

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: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of CKGeier@nwc.edu Sent: Tuesday, June 22, 2004 11:56 AM To: informix-list@iiug.org Subject: Memory allocation failed during query processing -AIX 5.1 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