HP-UX to SCO

[clegg]

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

 

[stanhubble]

are you accessing the database directly or thru a port?
if it is thru a port you may need to update the /etc/services file. does the server process start? anything in syslog?
i'm not all that familiar with informix so i am guessing at a client/server or a self serving client model.

 

[Hemo]

We just moved a large Informix SE based database from OpenServer to HP-UX using the 'dbexport/dbimport' method. Took almost as long to backup/restore from tape as it did to unload/reload data.

Your method 'should' have worked out fine if moving between same OS and Informix engines/version. Not sure what differences between the HP flavor of standard engine and the SCO flavor.

I guess we just have always used the dbexport and dbimport utilities to this extent and never thought of trying it your method.