Re: "Transaction too long", but no logging

monika@softcon.de (Monika Huk) wrote: >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;> ! >By the way: the creation on an index for a "smallint"-field worked >fine for the same table. There also already exists a unique composit Index >consisting of the above mentioned varchar "desk" and the a.m. >"smallint"-field, which was created when the table was created. >There should be enough space for the index in dbs_4 (3GB). >The sysmaster-table has "unbuffered logging", but I think that's not >important. >I use Informix-Onl v7.12, Operating-System is SINIX 5.42 >I can't really experiment with this one because of the size of the >table (and actually the size of the whole database). >Thanks a lot >Monika >monika.huk@softcon.de Since creating indexes uses a lot of temp space I would check there. I have seen a lot of wierd things happen with logging if you forgot to set the temp flag on any dbspaces that are define in your tempdbspace parameter. What I have experience is that all the temp tables the sort builds are logged if you do not set the temp flag correctly. Hope this helps -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com