Re: "Transaction too long", but no logging

Posted in 1996

Monika Huk — 31 Oct 1996 08:11:55 GMT — source: Informix-list mailing list archive (1991-1998)

In article <554ktg$akk@boell.softcon.de>, monika@softcon.de (Monika Huk) writes: >Hi, > >I have the following problem: > >I want to create an index on a table which contains 25.000.000 rows. >The index is of the type "varchar" with a max. length of 60 bytes. > >Because I got a "transaction too long" error, I turned logging off. >Nevertheless I got the same error again (error-no. 458). > >The statement: > isql $DATABASE - <<! > CREATE INDEX titel_desk ON titel_worte (desk) IN dbs_4;> ! > >I use Informix-Onl v7.12, Operating-System is SINIX 5.42 Thanks to everybody who answered. Increasing the logging-space solved the problem. Monika