RE: Help! - transaction log file
Using dbaccess
SELECT * FROM systables WHERE tabtype = 'L';
Delete this record using
DELETE FROM systables WHERE tabtype = 'L';
This changes you r database to no logging.
Restart logging on your database using
START DATABASE dbname WITH log in '/tmp/syslog';
Should resolve your problem.
God bless.
/Vus
-----Original Message-----
From: Tsutomu Ogiwara [mailto:tsutoo@my-deja.com]
Sent: Monday, December 18, 2000 2:47 AM
To: informix-list@iiug.org
Subject: Re: Help! - transaction log file
In article <91jg1p$eas$1@nnrp1.deja.com>,
Hi Hao.
Here is my test the fllowing command.
1. dbaccessdemo5 ogi
2. start database ogi with in "/tmp/syslog".
3. run query "delete from state"
4. rm /tmp/syslog
5. dbaccess -> D/Database -> S/Select -> ogi
get the folloing message.
224: Cannot open transaction log file.
120: ISAM error: cannot open log file.
6. cp /dev/null /tmp/syslog or
touch /tmp/syslog
7. dbaccess -> D/Database -> S/Select -> ogi
run correctly.
Regards.
r_hao@hotmail.com wrote:
> Hi, Tsutomu;
>
> Thank you for your kind help.
>
> The transaction log is '/tmp/syslog'. I did your way and also tried
> copying it from another server. It doesn't work.
>
> Randy
>
> In article <91irf1$v53$1@nnrp1.deja.com>,
> Tsutomu Ogiwara <tsutoo@my-deja.com> wrote:
> > Hi Randy.
> >
> > Please try this command as following.
> >
> > In SE case
> > cp /dev/null <transaction log file>.
> > And dbaccess -> D/Database -> S/Select.
> >
> > Regrads.
> > --
> > Tsutomu Ogiwara from Japan.
> >
> > In article <91ikav$q18$1@nnrp1.deja.com>,
> > r_hao@hotmail.com wrote:
> > > Hi, all;
> > >
> > > I need your help again! I deleted the transaction log file in /tmp
> > > mistakenly. Right now I can not select the database. It shows the
> > > message as following. Please help me to let me know what I should
> do.
> > >
> > > It is SE and IDS on the same machine. SE shows me the error message
> and
> > > IDS just hangs
> > >
> > > 224: Cannot open transaction log file.
> > > 120: ISAM error: cannot open log file.> > >
> > > Thanks million
> > >
> > > Randy
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>
--
Tsutomu Ogiwara from Japan.
Sent via Deja.com
http://www.deja.com/