Re: Falling back from 7.23 to 7.14

In article <6dermh$fgg@freepress.anasazi.com>, Malcolm McNeill <mcneill@ds9.anasazi.com> wrote: >If anyone out there has performed a migration from Informix 7.14 to 7.23 >and had to fall back, I would like to discuss any problems that you might >have encountered. I am particularly interested in finding out just what >structural changes happen to the sysmaster database during a migration and >whether falling back is a simple matter of pointing the instance back to >the 7.14 environment. Well, going forward from 7.14 to 7.23, sysmaster is rewritten in its entirety, and you get a sysutils database as well. It also sets things up for in-place alter and various other bits of new functionality introduced in 7.2x. If you have to fall back to 7.14, but want to preserve your own data, issue the command onmode -b 7.1UD1 This will revert all disk structures back to what 7.14 expects. You can then launch your 7.14 instance without difficulty. If you don't do this, the server will probably get hopelessly lost during initialisation. The next time you launch 7.23, it will update all of the structures again. All this is covered in the Migration Guide. It's dry reading, but it walks you through all that you need to do to move from one version to another. Jim -- W. Jim Jordan, Nortel, Stop 314 Qualicum, PO Box 3511 Stn C, Ottawa, ON K1Y 4H7 Canada I do not speak for Nortel. Unsolicited commercial or bulk e-mail may attract an invoice.