how to start a transaction log

Posted in 2006

Topics: Server Administration, Transactions, Locking & Isolation, Platform-Specific Issues, Versions, Editions & End-of-Life

Wahyu Cahyadi — Mon, 18 Dec 2006 05:49:10 — source: IIUG Forums & Mailing Lists

I am running dbaccess and then running command ' begin work', the error message I get is : 256: Transaction not available. so I find the error with finderr 256 that I must start a transaction log. Could u help to give me solution how to start a transaction log? IDS 9.40 FC5 HP-UX 11.23

↪ replying to Wahyu Cahyadi

H.G — Mon, 18 Dec 2006 06:06:22 — source: IIUG Forums & Mailing Lists

As unser informix, run on command prompt: ontape -s -L 0 -U <database name> NB: 1. Make sure TAPEDEV parameter in ONCONFIG is pointing to /dev/null otherwise it will take long time. 2. -U = Unbuffered You can use -B for buffered as well. 3. Better refer manual and will depend upon your business requirement Cheers. ----- Original Message ---- From: Wahyu Cahyadi <wahyu@takaful.com> To: ids@iiug.org Sent: Monday, December 18, 2006 4:49:11 PM Subject: how to start a transaction log [8019] I am running dbaccess and then running command ' begin work', the error message I get is : 256: Transaction not available. so I find the error with finderr 256 that I must start a transaction log. Could u help to give me solution how to start a transaction log? IDS 9.40 FC5 HP-UX 11.23 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

↪ replying to Wahyu Cahyadi

Jonathan Leffler — Mon, 18 Dec 2006 06:16:35 — source: IIUG Forums & Mailing Lists

On 12/17/06, Wahyu Cahyadi <wahyu@takaful.com> wrote: > I am running dbaccess and then running command ' begin work', the > error message I get is : 256: Transaction not available. > so I find the error with finderr 256 that I must start a transaction log. > Could u help to give me solution how to start a transaction log? > > IDS 9.40 FC5 > HP-UX 11.23 You are going to have to convert your database from unlogged to logged, which means doing an archive and changing the mode after doing so. You'll need to look up the details for ON-Bar and ON-Tape in the manuals. Alternatively, create a new (logged) database, cross-loading the data from the old. That might be DB-Export and DB-Import, or other methods of your choosing. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

↪ replying to H.G

Wahyu Cahyadi — Mon, 18 Dec 2006 06:26:14 — source: IIUG Forums & Mailing Lists

H.G wrote: > As unser informix, run on command prompt: > > ontape -s -L 0 -U <database name>> > NB: > > 1. Make sure TAPEDEV parameter in ONCONFIG is pointing to /dev/null otherwise > it will take long time. > > 2. -U = Unbuffered > > You can use -B for buffered as well. > > 3. Better refer manual and will depend upon your business requirement > > Cheers. > > ----- Original Message ---- > From: Wahyu Cahyadi <wahyu@takaful.com> > To: ids@iiug.org > Sent: Monday, December 18, 2006 4:49:11 PM > Subject: how to start a transaction log [8019] > > I am running dbaccess and then running command ' begin work', the > error message I get is : 256: Transaction not available. > so I find the error with finderr 256 that I must start a transaction log. > Could u help to give me solution how to start a transaction log? > > IDS 9.40 FC5 > HP-UX 11.23 > > > ok thanks, I run ontape -s -B databasename and everything is a OK :)

Glossary

dbaccess