We need to move an Informix Database (Standard Engine) that currently
resides on a box with HP-UX as the operating system to one with SCO
Openserver 5.0.7.

I dumped the database directory to a tape and then copied it onto the new
machine but when I try to access it I get a "database not found or no system
permission" error.

All the permissions are fine and all the tables are present and correct.

Does anyone have any idea as to what I'm missing? Is it that the 2 OS's have
done something different with the tables and there's a compatibility issue?

Would I be better using the DBEXPORT/DBIMPORT utilities and not specifying
the -ss option?

Any ideas would be gratefully received
Clegg

Mark said:
Well, that's not going to work -- the file formats won't be compatible. I
doubt the tape formats are compatible either.

You will have to dbexport the database, then copy that across using FTP
then dbimport it on the other side.

Yes.

--

Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule"
- Coluche

A smile is a gift that is free to the giver and precious to the recipient.
But giving someone the finger is free too, and I find it more personal and
sincere.
sending to informix-list

Mark wrote:

dbexport/dbimport is always preferred. It is Standard Engine, so -ss
option should not be used.
Make sure you have DBDATE set exactly the same on both machines, or
unset it before export and before import.

HTH

Michael

Hi,

dbexport/dbimport is not only "preferred" - in this case
it is quite "mandatory". Keep in mind that between the
HP-UX box and the SCO box you have byte swapping
(big endian vs little endian).

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

owner-informix-list (AT) iiug (DOT) org wrote on 25.08.2005 19:41:41: