NEED HELP ASAP! How to start transaction logging when a database has already been created

Posted in 2000

Summary

Jordan asked how to start transaction logging on an existing database in IDS 9.2. Michael Krzepkowski said to use ontape with -s for a backup and -B or -U to start buffered or unbuffered logging. Eric Chen added the ondblog utility, e.g. 'ondblog unbuf database', noting the change does not take effect until a full backup is done. The original poster thanked others for the help.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Transactions, Locking & Isolation

ASA GSI — Thu, 26 Oct 2000 09:22:48 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, I am using Dynamic server 9.2 and would like to start transaction logging. I know how to start it upon the database creation, but how do I start it if the database has already been created? Thank you Jordan

↪ replying to ASA GSI

ASA GSI — Thu, 26 Oct 2000 10:34:17 -0400 — source: Informix-list mailing list archive (1991-1998)

Thank you for the Help Brice and Obnoxio The Clown ASA GSI <jbruce@asaglobalserv.com> wrote in message news:rdWJ5.49551$Z2.706529@nnrp1.uunet.ca... > Hi, > > I am using Dynamic server 9.2 and would like to start transaction logging. > I know how to start it upon the database creation, but how do I start it if > the database has already been created? > > Thank you > Jordan > >

↪ replying to ASA GSI

Michael Krzepkowski — Thu, 26 Oct 2000 16:13:16 GMT — source: Informix-list mailing list archive (1991-1998)

Hi! You have to use ontape backup utility with -s (to backup all), and -U of -B to start Buffered or Unbuffered logging. HTH Michael ASA GSI wrote: > Hi, > > I am using Dynamic server 9.2 and would like to start transaction logging. > I know how to start it upon the database creation, but how do I start it if > the database has already been created? > > Thank you > Jordan

↪ replying to ASA GSI

Eric Chen — Tue, 31 Oct 2000 17:42:09 +0800 — source: Informix-list mailing list archive (1991-1998)

There is another utility for manage database log mode of IDS 2000 which name is "ondblog". Ex : ondblog unbuf database_name If your original database log mode is "not log" , after you using ondblog change log mode doesn't work until you execute full database backup. regards, Eric Chen "ASA GSI" <jbruce@asaglobalserv.com> '''g''l'' news:rdWJ5.49551$Z2.706529@nnrp1.uunet.ca... > Hi, > > I am using Dynamic server 9.2 and would like to start transaction logging. > I know how to start it upon the database creation, but how do I start it if > the database has already been created? > > Thank you > Jordan > >