RE: Problem with logging.

You have reloaded the database with the incorrect logging mode.
Somewhere you have a client that is connecting to multiple databases
through the single session handle, using remote syntax
@:

This only works in the logging mode of the two databases is the same.

Use onmonitor (maybe tbmonitor in your environment - what version and
what platform are you on?) to have a look at the database logging modes.
Then you can use ontape (with TAPEDEV set to /dev/null on UNIX or NUL on
Windows) to alter the logging modes of the databases.

If you can't find the utility, run "SELECT * FROM sysdatabases" from the
sysmaster database - it shows the same thing.

Find which database is incorrect and change it's logging mode to match
the other one used by the client.

Jarrod Teale
Fonterra New Zealand

-----Original Message-----
From: informix-list-bounces-at-iiug.org
[mailto:informix-list-bounces-at-iiug.org] On Behalf Of Pietia
Sent: Monday, 10 November 2008 5:11 a.m.
To: informix-list-at-iiug.org
Subject: Problem with logging.

Hi,
Sorry about my english... It is not so good, i need help about informix.

I have some database, i happen to remove one Database. After load database
from backup (tbload -l ...) informix show an error 568 Cannot reference
an external database without logging. What i do wrong ?
Any ideas?
--
Pietia
_______________________________________________
Informix-list mailing list
Informix-list-at-iiug.org
http://www.iiug.org/mailman/listinfo/informix-list


DISCLAIMER:
This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email.
You may not use, disclose or copy this email or its attachments in any way.
Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group.
http://www.fonterra.com/

Jarrod Teale:

> Use onmonitor (maybe tbmonitor in your environment - what version and
> what platform are you on?) to have a look at the database logging modes.
> Then you can use ontape (with TAPEDEV set to /dev/null on UNIX or NUL on
> Windows) to alter the logging modes of the databases.

I have INFORMIX-SQL Version 5.10.UC1 on Linux 2.2.
Can you show me step by step what i must to do?

i have tbmonitor, i set in tbconfig
TAPEDEV /dev/null

what next?

> If you can't find the utility, run "SELECT * FROM sysdatabases" from the
> sysmaster database - it shows the same thing.

i try but database sysmater isnt on my Database select list. If i try run
"dbaccess sysmaster" on shell (logged as informix) i have error:

329: Database not found or no system permission.
No such file or directory


Thanks for answer.

--
Pietia