Re: Informix upgrade 7.30 to 7.31

navdeep virk wrote: > We are planning to upgrade from Informix 7.30 to 7.31 (I Know!!!). > after the upgrade if we encounter any problems and if we need to go > back to 7.30, what would be cleanest and quickest way to do it. I > would think unload of tables and reinstall on Informix 7.30 and load > the tables back. Quickest and fastest way: * Install 7.31 in a separate directory along with CSDK and anything else (like ISQL or 4GL) that you need in there. * To upgrade: 1. Copy sqlhosts from the 7.30 directory tree to the 7.31 tree. 2. Copy ONCONFIG file from 7.30 tree to 7.31 tree and make any changes you want. 3. Shutdown 7.30 4. Change INFORMIXDIR link to point to the 7.31 install directory 5. Start up 7.31 oninit 6. Update statistics with DROP DISTRIBUTIONS for all databases & tables 7. Update statistics to replace distributions for all databases and tables 8. Update statistics for all stored procedures in all databases to recompile them. * To downgrade: 1. Run 'onmode -b 7.30' to revert to 7.30 structures 2. Shutdown 7.31 3. Change INFORMIXDIR link to point to the 7.30 4. Start up 7.30 oninit 5. Repeat steps 6-8 in the upgrade section above If you are not using a link for INFORMIXDIR you'll have to change all of your scripts that specify INFORMIXDIR in order to change versions. It might be easier to rename the 7.30 directory tree and just recreate the name as a link to 7.31 or 7.30 as needed. > It is possible that some transactions would have been inserted after > the 7.31 comes up.We would want to retain the transactions. If you do the conversion/reversion in place this is not a problem. > > Also, will the ESQL binaries need a recompile if this upgrade is done. Probably not, as long as you install the same version of ESQL or the CSDK as you had before. If you want to also upgrade your CSDK/ESQL-C version what you can do is to have older apps that have not yet been recompiled continue to use the old INFORMIXDIR location of the 7.30 engine where the older library are installed and once an app has been recompiled with the newer release it's startup environment can then be changed to point to the new 7.31 INFORMIXDIR containing the newer CSDK libraries. Done carefully, upgrade and reversion are relatively quick and nearly painless - especially between such closely related releases. Art S. Kagel Oninit > > Navdeep =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================