Migrating from 7.31 FC2 to 7.31 FC6 
Author Message
 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
 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
 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
 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
 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
 
 [ 5 post ] 

 Relevant Pages 

1. Problem with procedures by downgrade from 7.31 FC2 to 7.30 FC6

2. Assert Fail / 7.31 FC2

3. Version 7.31 FC2 on HP_UX 11.0

4. 7.31 UD1 to 7.31 UD5

5. Migrating from Online 5 to IDS 7.31

6. Migrating from Online 5 to IDS 7.31

7. Migrating from 7.31 to 9.20

8. Migrating from 7.31 to 9.20

9. Migrating from 7.31 to 9.20

10. Migrating from 7.31 to 9.20

11. Replication between Informix Dynamic Server 7.31 and SQL Server 7

12. MSG 7347 Received when openquery from sql 2000 to informix 7.31


 
Powered by phpBB® Forum Software