FW: In-place upgrade IDS 10.0.FC3 -> 11.10.FC2
We have upgraded a development instance with approx 120 small databases total 10Gb. The actual upgrade took half an hour (to Informix process to upgrade System database and our 120 databases - excluding backup and onchecks). With only a couple of databases the upgrade would be about 5 minutes. Make sure you have plenty of available space in rootdbs as sysadmin database grew considerably for us after the upgrade. We ended moving sysadmin to another dbspace - there is a function to execute to do this which we ran with users online. MW -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Martin Fuerderer Sent: Saturday, 15 December 2007 3:02 a.m. To: Lello, Nick Cc: informix-list-bounces@iiug.org; informix-list@iiug.org Subject: Re: In-place upgrade IDS 10.0.FC3 -> 11.10.FC2 Hi, I usually do not perform upgrades, so no experience to tell from me. The upgrade (the in-place is the normal) usually does minimal changes only. But the devil is in the detail, so I can't give estimates for your scenario ... What you should do in any case is to take a backup BEFORE you upgrade. If necessary for speed, this can be an external backup. If you have a spare machine with enough space, you could take a test tour ...: Take a backup from production machine and restore it on the test machine with the old version. Then perform the test upgrade there ... it will give you a good idea how long it takes, etc. Then you can work out a plan for the real upgrade of the production server. You cannot have HDR running between servers of different version. So it's possible to upgrade Secondary and re-establish HDR between the upgraded Secondary and the (not yet upgraded) Primary. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Chairman of the Supervisory Board: Hans Ulrich Märki Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael Diemer Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 informix-list-bounces@iiug.org wrote on 14.12.2007 14:35:02: > Has anyone perform the same (or similar) in-place upgrade yet, and > what was the experience in doing so ? > > I have a reasonably large data warehouse (400Gb) that would benefit > from the increased performance of IDS 11.1 but it?s constantly being > updated and we have a maximal 1 hour downtime window --- nowhere > near enough to unload/reload into a newly initialised instance. > > This is also a pair of HDR?d servers ? can I upgrade the secondary > and have it still work in the HDR pair for a few days before > upgrading the primary ? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list