Re: no logging database - long transaction aborted

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. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)