Re: no logging database - long transaction aborted

Nils.Myklebust@nmdata.com (Nils Myklebust) offerred: +On Thu, 30 Jul 1998 16:05:31 -0400, Family Jurkovic +<jurkovic@ican.net> wrote: + +>lblau@my-dejanews.com wrote: +> +>> I am trying to build an index on a very large table (> 1,000,000 records). +>> The database is in "no logging" mode and the table is locked in exclusive +>> mode. I am getting an error: 458: Long transaction aborted. +>> +>> Does anyone know what else could be causing the abort? + +>Sometimes reading the manuals helps! OnLine Administrator's guide, page 20-6 +>says explicitly that CREATE INDEX activities are always logged regardless of +>database logging mode! +> +>Add some more logical logs ! + +It may also be enough to set the log backup tape device in the +onconfig file to /dev/null if that isn't allready done. Then logs will +be "backed up" into oblivion automatically and freed. If the database +isn't loged anyway you hardly need the logs of such statements. If you are encountering long transactions, it means you hit a point where the transaction would span more of the log space than is safe to avoid filling the logs up. The fact that a log has not been backed up will not change that long transaction point; it is the amount of space spanned by the transaction relative to the total amount of space available. A log involved in a long transaction would not be reused even if it was backed up, as it is needed on disk in the event the transaction needs to be rolled back. So setting the log backup device to /dev/null would NOT eliminate long transactions in any circumstance. One could increase LTXHWM and LTXEHWM, but without knowing a lot of details about how IDS works and how log space is used, you could put your system into a totally screwed-up state by doing so. Best bet is to add more log space, at least temporarily. Dave ** Dave Kosenko <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training