Turn LOG on

Posted in 2000

Mike Vogeleer — Fri, 21 Jan 2000 08:57:21 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, is it possible to turn [buffered] logging on, after the database has been created. Normally, logging is turned on, when the database is CREATEd: CREATE DATABASE foobar WITH BUFFERED LOG; But I created the database, I forgot the "WITH BUFFERED LOG" clause. Any ideas? Thanks, Mike.

↪ replying to Mike Vogeleer

Serguei I. Ivantsov — Fri, 21 Jan 2000 13:26:38 +0200 — source: Informix-list mailing list archive (1991-1998)

"Mike Vogeleer" <mike.vogeleer@teleatlas.com> wrote in message news:38881F70.A88C0AD3@teleatlas.com... > is it possible to turn [buffered] logging on, after the database has > been created. > Yes of course! You can turn logging on with command "ondblog buf database_name". After which you have to perfom the whole level 0 backup of your system "onbar -b -w". -- Serguei I. Ivantsov, Research Institute Of System Technologies

↪ replying to Mike Vogeleer

Bashar Chalabi — Fri, 21 Jan 2000 11:27:21 -0000 — source: Informix-list mailing list archive (1991-1998)

Possible. depending on your version, 'ondblog' will do it. Otherwise, 'ontape' will do it. -- Bashar Chalabi CTL, London Mike Vogeleer <mike.vogeleer@teleatlas.com> wrote in message news:38881F70.A88C0AD3@teleatlas.com... > Hi, > > is it possible to turn [buffered] logging on, after the database has > been created. > > Normally, logging is turned on, when the database is CREATEd: > > CREATE DATABASE foobar WITH BUFFERED LOG;> > But I created the database, I forgot the "WITH BUFFERED LOG" clause. > > Any ideas? > Thanks, > Mike. >

↪ replying to Mike Vogeleer

Pablo Herrero — Fri, 21 Jan 2000 11:50:40 GMT — source: Informix-list mailing list archive (1991-1998)

Sure, ontape -s -L 0 -B database In article <38881F70.A88C0AD3@teleatlas.com>, Mike Vogeleer <mike.vogeleer@teleatlas.com> wrote: > Hi, > > is it possible to turn [buffered] logging on, after the database has > been created. > > Normally, logging is turned on, when the database is CREATEd: > > CREATE DATABASE foobar WITH BUFFERED LOG;> > But I created the database, I forgot the "WITH BUFFERED LOG" clause. > > Any ideas? > Thanks, > Mike. > > -- Pablo F Herrero Fernandez Gijon Asturias (Spain) Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Mike Vogeleer

Fabrice Dubosc — Tue, 25 Jan 2000 17:46:29 GMT — source: Informix-list mailing list archive (1991-1998)

Yes you can turn on or off logging, with ontape command and only when running a full backup. example: # ontape -s -B stores7 will run a full backup and then will turn logging on on database stores7. See the usage of ontape command. Regards Mike Vogeleer a écrit: > Hi, > > is it possible to turn [buffered] logging on, after the database has > been created. > > Normally, logging is turned on, when the database is CREATEd: > > CREATE DATABASE foobar WITH BUFFERED LOG;> > But I created the database, I forgot the "WITH BUFFERED LOG" clause. > > Any ideas? > Thanks, > Mike.