Informix, Migrating from 7.31 FC2 to 7.31 FC6

Migrating from 7.31 FC2 to 7.31 FC6

Author	Message
Masa #1 / 5	Migrating from 7.31 FC2 to 7.31 FC6 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!
Wed, 18 Jun 1902 08:00:00 GMT

Art S. Kage #2 / 5	Migrating from 7.31 FC2 to 7.31 FC6 Quote: > 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
Wed, 18 Jun 1902 08:00:00 GMT

smooth #3 / 5	Migrating from 7.31 FC2 to 7.31 FC6 Quote: >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)
Wed, 18 Jun 1902 08:00:00 GMT

bwh.. #4 / 5	Migrating from 7.31 FC2 to 7.31 FC6 Quote: > >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? Quote: > 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.
Wed, 18 Jun 1902 08:00:00 GMT

Bernstein, Ric #5 / 5	Migrating from 7.31 FC2 to 7.31 FC6 Look at PTS 129463 - ROLLFORWARD OF ROLLBACK OPERATIONS ON BTREES CAUSES ASSERT FAILURE AND LEADS TO AN ENGINE HANG. Its impact is not limited to HDR. Quote: -----Original Message----- Sent: Tuesday, August 08, 2000 07:10 Subject: Re: Migrating from 7.31 FC2 to 7.31 FC6 > >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.
Wed, 18 Jun 1902 08:00:00 GMT

Page 1 of 1

[ 5 post ]