Oninit cdi / Archive
Talk to an expert →

Migrating from 7.31 FC2 to 7.31 FC6

Posted in 2000

Topics: Migration, Import/Export & Data Conversion

Masa — — source: Informix-list mailing list archive (1991-1998)

I'm going to migrate a very large Informix instance from 7.31 FC2 to 7.31 FC6. I have done migrations before but with smaller instances. (and test databases) Now I need some expert advices how migrating is done in practise. - What are steps before migration (oncheck etc) ? - How migration must be done? - What must be done after migration (update statistics etc) ? Thanks for your advice!

↪ replying to Masa
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Masa wrote: > > I'm going to migrate a very large Informix instance from 7.31 FC2 to 7.31 > FC6. > I have done migrations before but with smaller instances. (and test > databases) > > Now I need some expert advices how migrating is done in practise. > > - What are steps before migration (oncheck etc) ? > > - How migration must be done? > > - What must be done after migration (update statistics etc) ? For migration between sub releases of the same major release all that is needed is to shutdown, change the environment to point to the new software (I always install in different directory so I can easily and quickly revert if there are any problems, and start up the new version. It is prudent, read sane, to take a level zero archive as close before the upgrade as feasible. Feasible in that, for example, I just upgraded over the W/E a server that it takes 30 hours to archive so I was happy to rely on the week old LEVEL 0, a level2 from Wednesday, and my log backups as the best I was going to do since I could not take the server off-line for two days for the upgrade. Art S. Kagel

↪ replying to Masa
smooth1 — — source: Informix-list mailing list archive (1991-1998)

Masa wrote in message <8mjti8$k81$1@news.kolumbus.fi>... >I'm going to migrate a very large Informix instance from 7.31 FC2 to 7.31 >FC6. Don't! There is a bug in UC6 where if you create an index and the create index gets rolled back then a) The rollback fails b) The engine then Assert Fails and shuts down c) The engine will NOT restart due to the corruption and IT IS RESTORE FROM BACKUP TIME!! UC6 is NO NO I am moving customers to UC5-1. I have heard this has optimizer problems (can anyone say more about this e.g. a Bug ID from the Techinfo Centre and a description so I can find it??). Is UC7/UC8 out yet?? Does anyone have the release notes?? David Williams (FAQ www.smooth1.demon.co.uk)

↪ replying to smooth1
bwhite@deroyal.com — — source: Informix-list mailing list archive (1991-1998)

In article <398f4fcb_3@news2.vip.uk.com>, "smooth1" <smooth1@iclway.co.uk> wrote: > > Masa wrote in message <8mjti8$k81$1@news.kolumbus.fi>... > >I'm going to migrate a very large Informix instance from 7.31 FC2 to 7.31 > >FC6. > > Don't! There is a bug in UC6 where if you create an index and > the create index gets rolled back then > > a) The rollback fails > b) The engine then Assert Fails and shuts down > c) The engine will NOT restart due to the corruption > > and IT IS RESTORE FROM BACKUP TIME!! > > UC6 is NO NO Does anyone have a Bug ID and/or description from Techinfo on this UC6 index bug? > > I am moving customers to UC5-1. I have heard this has optimizer > problems (can anyone say more about this e.g. a Bug ID from > the Techinfo Centre and a description so I can find it??). > > Is UC7/UC8 out yet?? Does anyone have the release notes?? > > David Williams (FAQ www.smooth1.demon.co.uk) > > Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary