Re: Logs filling up on reports

Ray Brizzi wrote: > > 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 Since this is a reporting app., you could try setting the isolation to dirty read and selecting without transactions. If I try that in dbaccess, my selects are not logged. If you are creating temp tables explicitely, use the no log option. HTH - Atul.