Re: Upgrade Procedures
In article <5g6nbm$hle@cssun.mathcs.emory.edu>, Dale Forrey <forrey@wsu.edu> writes > When a new version of Informix Online is received by your shop what >is your standard installation procedure? For example, let's assume that you >currently have Online 7.20 installed on a UNIX box and you receive version >7.22. Let's also assume that you have ESQL/C and perhaps CLI also installed >on this machine. Do you install 7.22 as a completely separate instance of >Online and test it out and then install it again over the top of the >production 7.20 version? If you run a separate test instance of Online then >have you also installed separate copies of ESQL/C and so on? Are there any >dangers in running multiple instances of Online on the same machine? > I have looked at the Informix Migration Guide and chapter 5 deals >with some of my questions. I suppose I am looking for practicle suggestions >from those of you who have spent some time working with these products. >Thanks for your advice. > >Dale Forrey, DBA email: forrey@wsu.edu >Information Technology FAX: (509) 335-0540 >Washington State University Phone: (509) 335-7098 >Pullman, WA 99164-1222 > > My normal procedure for upgrading Informix is Test against demo ----------------- 0. Backup everything (UNIX full backup + level 0 archives). 1 Install new version of Informix in another directory. 2. Check release notes for any kernel parameter changes/known bugs/ functionality changes. 3 Configure demo instance on Online to use new engine (Change . demo script to point to new $INFORMIXDIR etc. 4. Start demo Online engine and allow it to upgrade sysmaster etc. 4. Run update statistics on demo to update to new index structures etc + redo optimzer stats (Good time to do update stats whilst no-one is on it). 5. Compile + Test applications against new version of Informix. Then install again (0-5 above) for live instance, Move live $INFORMIXDIR to $INFORMIXDIR.old before upgrading- allows fast restore of previous version of Informix if required, I can just undo the move then ask the client to put the level-0 archive tape back in and do a cold restore. Makes you look good if you need to revert back to previous version fast. Easy! -- David Williams