 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Informix Topics / March 2008Create Database with logging enabled
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/ > I would like to be able to default all database to create with logging > enabled (unbuffered). [quoted text clipped - 3 lines] > 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 ...  SignatureJonathan 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 > I would like to be able to default all database to create with logging > enabled (unbuffered). [quoted text clipped - 3 lines] > 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. SignatureJonathan 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 >> I would like to be able to default all database to create with logging >> enabled (unbuffered). [quoted text clipped - 7 lines] > 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? SignatureCiao, 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.