Logging with CREATE INDEX

Posted in 2003

Andy Kent — 29 Jul 2003 11:58:40 -0700 — source: Usenet: comp.databases.informix

Is it still the case that all DDL gets logged even if you have logging turned off, such that CREATE INDEX can still blow the logs, or was this changed? If so in which release? Andy Kent Bristol, UK

↪ replying to Andy Kent

rkusenet — Tue, 29 Jul 2003 15:10:38 -0400 — source: Usenet: comp.databases.informix

"Andy Kent" <andykent@cix.co.uk> wrote in message news:258e719e.0307291058.2c1c8de7@posting.google.com... > Is it still the case that all DDL gets logged even if you have logging > turned off, such that CREATE INDEX can still blow the logs, or was > this changed? If so in which release? > > Andy Kent > Bristol, UK Yes it is true that all DDL statements are logged. However the statement only is logged. The data as a result of the DDL is not logged. So in your case, it will log the CREATE INDEX statement and will apply it for rollforward, if requried. -- Email Address is Bogus.