RE: Logging with CREATE INDEX

Posted in 2003

Alexey Sonkin — Tue, 29 Jul 2003 16:53:26 -0400 — source: Usenet: comp.databases.informix

AFAIK also 'chunk extent allocation' records are logged during the index creation in non-logged database ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: rkusenet [mailto:rkusenet@sympatico.ca] > Sent: Tuesday, July 29, 2003 3:11 PM > To: informix-list@iiug.org > Subject: Re: Logging with CREATE INDEX > > > "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. sending to informix-list