We are running OnLine Informix7.22 on a unix machine. We have problems on turning off the transaction protocol as user informix with the commands ontape -N, ontape -s -L 0 -N, ontape -s -N. We set the TAPEDEV to /dev/null, but nothing changed. We always get the error code "Invalid logging change to mydbs". The same message appears when we are trying to change the logging with onmonitor. What could be the problem? Any idea?
Thank you,

murkesilence

I guess that your database is "mode ansi". If this is the case
your are not allowed to turn logging off, no way.
Bad luck.

You can check if your database is in "mode ansi" with the following select against the sysmaster database:

select name, is_ansi
from sysdatabases
where name = <mydbname>;

HTH.

Best regards

Eric
--
IT-Consulting Herber
www.herber-consulting.de

This isn't our problem, because our database is not ansi.

Any other idea?
Murkesilence

7.22 is a really old version, I would recommend an update to
7.31....

Create the stores7 database:

- dbaccessdemo7 -log

Try to turn logging off afterwards:

- ontape -N stores7

Does this work ?

If yes, switch your databaseserver to quiescent mode
(onmode -uy) and try it once again for your database.

If it doesn't work, open a case with informix tech support.


HTH.

Best regards

Eric
--
IT-Consulting Herber
www.herber-consulting.de

Yes, I agree with Eric. I know version 7.23 had a similiar problem with ontape and logging. Have you check your release notes ? Version 7.31 - I believe uc5 or higher is a very stable datbase.

They are working on a 7.31.UD3 version already...

Thank you, we will see if we can update our system.

What about Informix 7.31-UC4-1?
Regards,

murkesilence

The 2 I worked with the must were uc5/uc7 and I believe there was some major changes after uc4 - I believe in regards to backups/restores. Both uc5/uc7 were extremely stable environments.

Good luck.

If you have a maintenance agreement, the upgrade to 7.31.UD3 is free...

I get this same error when using the command:

Where "mydb" is a freshly created database. The details from the systemmaster table for this databases record are:

The Informix server version is 10. Anyone have any ideas where I am going wrong?

Thanks in advance,

Gareth.