dbimport Failure

I hava a database that I want to move from one Informix server to
another. They both reside on the same machine with the same Informix
version.

SunOS 5.8 sparc Ultra-80
IBM Informix Dynamic Server Version 9.40.UC5

I set up my initial Informix environment and exported data from the
original IDS database via dbexport -q -o <dir> -ss <dbname>.

I changed to the new Informix environment and then attempted to import
data from that output directory into the new IDS database via dbimport
-q -i <dir> -d <DfltDbSpace> <dbname>. However, I received the
following output:

*** prepare sqlobj
329 - Database not found or no system permission.

111 - ISAM error: no record found.

After the failed dbimport, I found that the database was created in the
new IDS. I ran a database comparison via Server Studio and found that
all of the database tables had been created, but 5 synonyms were not
created and 340 routines were not created.

Has anyone seem a similar situation? Did you get a resolution to the
problem?

Thanks,
Gary Andrus

.

Relevant Pages