Re: Logs filling up on reports

In <4e40a0$pbb@ixnews6.ix.netcom.com> rbrizz@ix.netcom.com(Ray Brizzi ) writes: > >We have a table that has billions and billions (almost) rows in it. >Users can query this raw data to do their own reporting criteria. >Purely for reporting, these queries build temporary tables for order >by's and writing to these fills up the logs so the transaction ends up >abending. Is there any way to turn logging off on these temporary >tables that Informix allocates internally? > >We are on 5.03 right now, moving to 5.06. Ray Ray: I hope I'm not asking a stupid question: but, are you creating your temp. tables "with no log". This should keep your logs from filling up. regards, ed schaefer