Re: Falling back from 7.23 to 7.14

In article <6dermh$fgg@freepress.anasazi.com>, Malcolm McNeill <mcneill@ds9.anasazi.com> writes >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. > >The reason we are considering falling back to 7.14 is, we have found >resource use to be somewhat greater with 7.23. We are in the process >of tuning kernel parameters where we can, however until we have sufficient >resources to handle the new load, we are proceding with caution. There are >several instances of informix that we will be migrating and at any time >we may need to fall back from a 7.23 version to a 7.14. > I would a) Take a level 0 archive under 7.14 b) Install 7.23 in a new $INFORMIXDIR. If you need to go back to 7.14 just a) shutdown 7.23 b) point $INFORMIXDIR back ti 7.14 c) restore the level 0 archive. Simple! There is an onmode option to revert back but it only goes back to 6.0!! >Please feel free to contact me at mcneill@anasazi.com. > >Regards, > >Malcolm McNeill >Database Administrator >Anasazi, Inc. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care