RE: Help! - transaction log file

I suspect that this would not be wise. Not real sure about it, but for some strange reason..... cheers j. > -----Original Message----- > From: Vusani.Mapuke@icl.com [mailto:Vusani.Mapuke@icl.com] > Sent: Monday, December 18, 2000 8:20 AM > To: informix-list@iiug.org > Subject: 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/ >

In the year of Our Lord Mon, 18 Dec 2000 10:57:56 -0500, "Parker, Jack" <JParker@engage.com> broke a vow of silence to utter: > >I suspect that this would not be wise. Not real sure about it, but for some >strange reason..... On SE? Used to do it all the time. I even think it was a supported and documented approach at one stage. >> -----Original Message----- >> From: Vusani.Mapuke@icl.com [mailto:Vusani.Mapuke@icl.com] >> Sent: Monday, December 18, 2000 8:20 AM >> To: informix-list@iiug.org >> Subject: 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/ >>

"Parker, Jack" wrote: > I suspect that this would not be wise. Not real sure about it, but for some > strange reason..... > > > -----Original Message----- > > From: Vusani.Mapuke@icl.com [mailto:Vusani.Mapuke@icl.com] > > Sent: Monday, December 18, 2000 8:20 AM > > To: informix-list@iiug.org > > Subject: RE: Help! - transaction log file > > > > > > Using dbaccess > > > > SELECT * FROM systables WHERE tabtype = 'L'; The biggest problem with this is that DB-Access can't connect to the database to execute a SELECT statement. > > 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'; -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"