Re: no logging database - long transaction aborted

Posted in 1998

Family Jurkovic — Thu, 30 Jul 1998 16:05:31 -0400 — source: Informix-list mailing list archive (1991-1998)

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? > > Thanks, > > Lauren > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum 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 ! Dragan Jurkovic MRRM (Canada) Inc. jurkd@mrrm.ca