Re: alter table in-place algorithm

On Jul 30, 11:46 am, Carsten Haese <cars...@uniqsys.com> wrote: > On Mon, 2007-07-30 at 08:31 -0700, mohitanch...@gmail.com wrote: > > Sorry for not giving you the version of IDS, I thought my questions is > > very general. > > Yes, but the universe of possible answers gets larger for more recent > engine versions. When asking for help on a product, as a rule of thumb, > *always* mention the version of that product. > > > We are using IDS 10. > > That means that you could try turning the table in question into a raw > table. Note that I'm not sure whether that's going to help for an ALTER > TABLE, but it's worth a try. > > HTH, > > -- > Carsten Haesehttp://informixdb.sourceforge.net other options if making a table raw doesn't help with the in place alters 1) create a new table that is raw with the columns as you want them and then insert into the new raw table drop the old table and then rename the new table to the old table name change it to type standard. Create the indexes on the new tables rebuild any constraints. I know that the inserts into the raw table won't log in the raw table. 2) Add log space 3) muck with high water marks for long tx (at your own risk) 4) turn logging off on the database.