onunload/onload issue

has anyone noticed any problems using onunload/onload to move a database from a 7.31 instance to a 2000 instance? i get the following error messages when i try to import a dump file created with 7.31 into 2000: "Error inserting system catalog record." "ISAM error: duplicate value for a record with unique key." thanks for the input. Ty O'Kelly tokelly@my-deja.com Sent via Deja.com http://www.deja.com/ Before you buy.

tokelly@my-deja.com wrote: > has anyone noticed any problems using onunload/onload to move a database > from a 7.31 instance to a 2000 instance? i get the following error > messages when i try to import a dump file created with 7.31 into 2000: > "Error inserting system catalog record." > "ISAM error: duplicate value for a record with unique key." You're pretty lucky to get that far - onunload/onload cannot be used to move databases across versions. You can, very easily, migrate your entire 7.3 instance to ids2000. Or, use dbexport/dbimport. Rudy

tokelly@my-deja.com wrote: > > has anyone noticed any problems using onunload/onload to move a database > from a 7.31 instance to a 2000 instance? i get the following error > messages when i try to import a dump file created with 7.31 into 2000: > "Error inserting system catalog record." > "ISAM error: duplicate value for a record with unique key." Onload/onunload are binary import/export utilities that read and write page images. You cannot use them to migrate between platforms or between different versions on the same platform. Use dbimport/dbexport, my myexport/myimport utilities, dbaccess load/unload commands, or Jonathan Leffler's sqlcmd load/unload or sqlload/sqlreload utilities. All are text based. In addition if the two servers can talk to each other you can use my dbcopy utility to do a high speed server-to-server copy. Art S. Kagel

tokelly@my-deja.com wrote: > > has anyone noticed any problems using onunload/onload to move a database > from a 7.31 instance to a 2000 instance? i get the following error > messages when i try to import a dump file created with 7.31 into 2000: > "Error inserting system catalog record." > "ISAM error: duplicate value for a record with unique key." Are you sure that you can use onunload / onload between versions? The Migration Guide says that original and target databases must be on the same version of the server (p.11-66) -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */