Re: Help! - transaction log file

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/

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/

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/

Tsutomu Ogiwara wrote: > In article <91jg1p$eas$1@nnrp1.deja.com>, > 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. Tsutomu's suggestion is basically correct. Check that the permissions on the file are correct (660, group informix). Also, on many systems, /tmp is cleared on reboot -- all files are deleted. This is not a good place to put a database transaction log; if the machine crashes, you want that transaction log! > Regards. > > r_hao@hotmail.com wrote: > > 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: > > > 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. -- 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!"

Hi, Jonathan; Thank you for your Informix DBD. It works great! Tsutomu was right. The log file is called 'dblog' instead of 'syslog' as I thought. We fixed SE problem. However, the IDS, which runs on the same machine, still hangs after executing dbaccess. Any hints? Thanks - Randy In article <3A3EBFFE.62879644@informix.com>, Jonathan Leffler <jleffler@informix.com> wrote: > Tsutomu Ogiwara wrote: > > In article <91jg1p$eas$1@nnrp1.deja.com>, > > 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.> > Tsutomu's suggestion is basically correct. > > Check that the permissions on the file are correct (660, group > informix). > > Also, on many systems, /tmp is cleared on reboot -- all files are > deleted. This is not a good place to put a database transaction log; if > the machine crashes, you want that transaction log! > > > Regards. > > > > r_hao@hotmail.com wrote: > > > 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: > > > > 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.> > -- > 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!" > Sent via Deja.com http://www.deja.com/