RE: Memory allocation failed during query processing -AIX 5.1

you may need to issues few onstat commands (onstat -g seg, onstat -g mgm, onstat -g mem, onstat -u, onstat -g ses, onstat -g sql ) to see what exactlyis happening with the query, it may be also possible that the kernel parameters are not set right. you may also set DS_MAX_QUERIES and DS_TOTAL_MEMORY to some values in the onconfig, to start with i would set DS_MAX_QUERIES to 10 and DS_TOTAL_MEMORY to 200000. also, make sure there are no hung shared memory segments, may issue 'ipcs' command to find this. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of CKGeier@nwc.edu Sent: Wednesday, June 23, 2004 1:57 PM To: informix-list@iiug.org Subject: 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 sending to informix-list