Create Database with logging enabled
Jarrod Teale asked for an environment variable or onconfig parameter making CREATE DATABASE in old scripts default to unbuffered logging. Jonathan Leffler knew of no way to set a default logging mode and floated I-Spy to rewrite the statements; Marco Greco suggested simply running awk over the scripts. No server-side setting was found.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, I would like to be able to default all database to create with logging enabled (unbuffered). We have a number of historical scripts with "CREATE DATABASE bob IN data01;" in them, and we now need these to be logged when created. Is there an environmental variable / onconfig parameter that I can set to make database created with the above syntax to be unbuffered logging? Thanks Jarrod Teale DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/
Jarrod Teale wrote: > I would like to be able to default all database to create with logging > enabled (unbuffered). > We have a number of historical scripts with "CREATE DATABASE bob IN > data01;" in them, and we now need these to be logged when created. > > Is there an environmental variable / onconfig parameter that I can set > to make database created with the above syntax to be unbuffered logging? AFAIK, there is no way to set a default logging mode for newly created databases. I could have been asleep again (I probably should be asleep now, too), but ... -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-2862 ripemd128 2008-03-28 06:00:08 0C9DAE2812851C606B29546F8B24F1F5
Jarrod Teale wrote: > I would like to be able to default all database to create with logging > enabled (unbuffered). > We have a number of historical scripts with "CREATE DATABASE bob IN > data01;" in them, and we now need these to be logged when created. > > Is there an environmental variable / onconfig parameter that I can set > to make database created with the above syntax to be unbuffered logging? I wonder if you want to think about using I-Spy to edit your CREATE DATABASE statements on the fly? Probably not - the overhead is likely too great for everything else. But that is one of the things it could do. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-2862 tiger2 2008-03-28 06:00:08 0E524C5AB80ECA5EF3567973D041106FBF1D1E07E15D1408
Jonathan Leffler wrote: > Jarrod Teale wrote: >> I would like to be able to default all database to create with logging >> enabled (unbuffered). >> We have a number of historical scripts with "CREATE DATABASE bob IN >> data01;" in them, and we now need these to be logged when created. >> >> Is there an environmental variable / onconfig parameter that I can set >> to make database created with the above syntax to be unbuffered logging? > > I wonder if you want to think about using I-Spy to edit your CREATE > DATABASE statements on the fly? Probably not - the overhead is likely > too great for everything else. But that is one of the things it could do. > > Why set up I-spy when you can awk the scripts on the fly? -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm