June Tong wrote:
>
> Sujit.Pal@alltel.com wrote:
>
> > You would need to increase the number of logical logs. The reason is
> > that DDL statements such as ALTER are always logged regardless of
> > whether your database is logged or not.
>
> Yes, that's true, but the ALTER statement by itself is not what's filling up the
> logical logs; it's all the individual INSERT statements that result from the ALTER,
> as the engine copies all the rows from the original table to the new table. These
> would not be logged if the database had logging turned off.
>
Above situation was true for IDS up to 7.2X. From IDS 7.30 onwards
Informix handles it in a different way, by altering table information
and leaving the data virtually untouched. This avoids the creation of
a new table and duplication of all the data, before dropping the
original.
So those using 7.30, have one less thing to worry.
--
Have a nice day
Felix K. Mathews
mailto:fmathews@systems.dhl.com