Re: Upgrade from IDS7.30 to IDS2000 (9.20) - Issues found

"Carlson@WHSmith" <carlson1@bellsouth.net> wrote in message news:38EDF6F1.B35C619E@bellsouth.net... > Richard Lewis wrote: > > > > Subject extension : When a database not considered good enough to export > > > > Hi, > > > > I have just migrated one of our machines from IDS7.30 to IDS2000 (9.20). > > There was a problem during the conversion and sysmaster was not built > > properly. When rebuilt everything was ok. > > > > Great! > > > However, as an extra backup, I have a script running at night that takes a > > copy of selected databases using "onunload". Would you believe that a > > database converted from an earlier version of IDS is not considered suitable > > by onunload !!!??? Here is the message: > > > > ERROR: Onunload is not capable of unloading a database converted > > from a previous version. Please use another Informix unload/load > > mechanism to export this database. > > Dump failed > > > > What does this tell you about the database in use by your application ? Is > > it any good ? > > > > Yes it is still good. My understanding of onunload (don't use it much > in our shop) is that it isn't used to migrate data from one version to > another. According to the manual, you must use the same version to load > it as you used to unload it. Yes, but my problem is that I cannot use onunload for one of the older databases because they were created using an older version of IDS. I have never had this problem moving from 7.1 to 7.2 to 7.3 (and all the minor movements in between). I have to use dbexport and dbimport to create new databases, then I can use onunload again. I have a workaround, but it just does not seem sensible. I have to perform another migration for every database, even though IDS2000 has already done some migration work on the databases. > > > In addition, if you create a new database and migrate the data across, then > > change your mind and want to go back to 7.30, you cannot do so. The reason > > given in the Migration Guide is that you cannot migrate a database created > > by 9.20 to an earlier version. > > > > But you can: > 1. Reinstall an earlier version of Informix. > 2. Restore a previous full backup (taken before the migration) of your > data. > > > I have made up a script to use for each database that needs migrating to > > 9.20 that uses dbexport/dbimport. I will have to schedule a time to migrate > > the databases properly to 9.20. > > > > -- > John Carlson > Informix DBA > WHSmith USA > > #include std_disclaimer.h /* These are my opinions, not my company's > opinion */