how to start a transaction log
Wahyu Cahyadi got error 256 (Transaction not available) on begin work in dbaccess on IDS 9.40 FC5, HP-UX 11.23. H.G suggested a level 0 ontape archive with unbuffered logging. Jonathan Leffler explained the database must be archived and converted from unlogged to logged, or recreated. Wahyu ran ontape -s -B with the database name and it worked.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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
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/
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 :)