HP-UX to SCO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 25 Aug 2005 15:31 GMT

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

Reply to this Message

Obnoxio The Clown - 25 Aug 2005 16:52 GMT

Mark said:

> 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
[quoted text clipped - 4 lines]
> system
> permission" error.

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.

> All the permissions are fine and all the tables are present and correct.
>
[quoted text clipped - 5 lines]
> Would I be better using the DBEXPORT/DBIMPORT utilities and not specifying
> the -ss option?

Yes.

Signature

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

Reply to this Message

Michael Krzepkowski - 25 Aug 2005 18:41 GMT

> 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
[quoted text clipped - 14 lines]
> Any ideas would be gratefully received
> Clegg

Hi,

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

Reply to this Message

Martin Fuerderer - 26 Aug 2005 09:06 GMT

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@iiug.org wrote on 25.08.2005 19:41:41:

> Mark wrote:
> > 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?
> >
[quoted text clipped - 11 lines]
>
> Michael

sending to informix-list

Reply to this Message