Re: Transaction log not defined !
Art S. Kagel wrote:
>
> Steffen Lude wrote:
> >
> > Hi Johan
> >
> > > But how do I add a transaction log to a existing database ?
> >
> > The only way I know to change log to buffered mode is to backup
your
> > existing database with:
> >
> > ontape -s -B databasename>
> Or ontape -s -U databasename for Unbuffered logging
> Or ontape -s -A databasename for ANSI Mode logging
>
> Also this needs to be a level 0 backup and the engine needs to be in
> QUIESCENT mode for the logging mode change to take effect.
Or ONLINE mode. :-)
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+