RE: Memory allocation failed during query processing -AIX 5.1

here is what we have in our onconf file: # Parallel Database Queries (pdq) MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority (was 100) DS_MAX_QUERIES # Maximum number of decision supportqueries DS_TOTAL_MEMORY # Decision support memory (Kbytes) DS_MAX_SCANS 1048576 # Maximum number of decision support scans DATASKIP off # List of dbspaces to skip C Geier St. Paul, MN "Savio Pinto (s)" <spinto@cap.org> 06/22/2004 04:42 PM To "'CKGeier@nwc.edu'" <CKGeier@nwc.edu>, informix-list@iiug.org cc Subject 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