Re: Logging with CREATE INDEX

Andy, Yes, all system level activity is still logged but dat level activity is not. That includes database schema changes and space allocation, even if the database has NO LOG. You can easily confirm this by doing the CREATE INDEX and then using onlog to look at the output. And each extent allocation counts as a singleton transaction and flushed the logical log buffer, or at least it did when I last looked at it. Malcolm ----- Original Message ----- From: "Andy Kent" <andykent@cix.co.uk> To: <informix-list@iiug.org> Sent: Tuesday, July 29, 2003 7:58 PM Subject: Logging with CREATE INDEX > 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 sending to informix-list