Posting from the Informix-list

Whenever i run following query having 149495 rows in a table - (index is dist_code,fund_code,trans_type) select new_app_prg_code,sum(doc_total) from lppas_tran where trans_type = 'A' and dist_code = 64733 and fund_code = 657 group by 1 order by 1 i receive an error 208 -208 Memory allocation failed during query processing. The database server needed to allocate data space memory in order to process the query, and none was available. This may reflect a hardware limit, or an operating system configuration limit, or a temporary shortage of space. Same query runs fine without sum function and group clause ! Can somebody help Mukund

Hi, Can you try measuring the free tempspace during processing, I think your machine has run out of this. Greetings, Rob Prop Database Consultant Informa Automatisering B.V. "Shevkar, Mukund" wrote: > Whenever i run following query having 149495 rows in a table - > (index is dist_code,fund_code,trans_type) > > select new_app_prg_code,sum(doc_total) > from lppas_tran > where trans_type = 'A' and dist_code = 64733 > and fund_code = 657 > group by 1 > order by 1> > i receive an error 208 > > -208 Memory allocation failed during query processing. > > The database server needed to allocate data space memory > in order to process the query, and none was available. This > may reflect a hardware limit, or an operating system > configuration limit, or a temporary shortage of space. > > Same query runs fine without sum function and group clause ! > Can somebody help > > Mukund