Re: Altering large table

Posted in 2001

dave_g37uk@my-deja.com — Tue, 16 Jan 2001 13:41:32 GMT — source: Informix-list mailing list archive (1991-1998)

In article <9414lq$ekum$1@as121.tel.hr>, "Karmen Karlusi'" <Karmen.Karlusic@hfp.hr> wrote: > > > Nebojsa Sevo <mips@zg.tel.hr> wrote in message > news:d6086ts63igea6da5eltagqcgl84essbu0@4ax.com... > > I have to alter one of my tables. I will change logging mode of database > to NO > > LOGGING so nobody can work on system. Because of that I have to do that in > less > > time as possible. > > > > Does anybody have advice which Informix parametars should I change to > speed up > > the process? > > > > Thanks > > > > Nebojsa > You can use High Performance loader. I have good experience with it. You > don't have to change logging mode of database. > Karmen > > Will turning logging off stop users working on the system? I thought it would just stop transactions being logged although it should stop writes to log files. I have an Alter to do on 1.6M rows so would be interested in any replies. Does High Performance Loader do Table Alters ? /Dave Sent via Deja.com http://www.deja.com/