Previuously you also said:

---
Any reason not to just shutdown 9.21, point 10.0 at the same disk space and bring up IDS 10.0 and let it convert the disk pages in-place? Then you only have to run some update statistics and you're done!
---

For example if I have 9.4 on Hp-Ux PA-RISC 64 Bits and plan to migrate to 10.0 on Hp-Ux Itanium the same apply?

I won't change any of the storage. So bringing up IDS 10 attached to the original dbspaces/chunks will do the magic?

How log will it take?


J.

PD: If this works it will rock!


-----Original Message-----
From: "Art S. Kagel" <kagel@bloomberg.net>
To: informix-list@iiug.org
Date: Tue, 19 Apr 2005 18:23:44 -0400
Subject: Re: Migration question

David E. Grove wrote:
>>>We would like to migrate from 9.21 to 10.0 on a new machine. We are
>
> also
>
>>>changing the storage regime.
>>
>>Any reason not to just shutdown 9.21, point 10.0 at the same disk space
>
> and
>
>>bring up IDS 10.0 and let it convert the disk pages in-place? Then you
>
> only
>
>>have to run some update statistics and you're done!
>>
>
>
>
> The existing storage is an A1000 attached to an E3500. The new is 3310
> attached to V480. Would you be suggesting attaching the A1000 to the new
> IDS server on the new V480? Wouldn't that mean retaining the existing
> dbspaces on the A1000? We're running out of space on the A1000, and will

OK, I missed where you said the migration included moving to another
machine. You can use multiple copies of my dbcopy utility to copy the data
directly from the old server to the new one once the DB is setup. The
utils4_ak package has awk scripts that post-process dbschema/myschema output
to produce a dbcopy script (among others).

> have plenty on the 3310, so would like to migrate to new storage. We're
> also simplifying our storage and administration (at the possible expense of
> some performance) by following the Oracle S.A.M.E. (Stripe And Mirror
> Everything) strategy by making one big dbspace that is on the new 3310,
> configured as RAID10. In other words, instead of about 15 dbspaces carved
> out of A1000 and internal drives, we're putting everything in a single 60GB
> rootdbs, that's striped across 6 mirrored pairs in our new 3310.

I'd still carve that up and make multiple dbspaces. The engine parallelizes
dirty page flushes by dbspace during checkpoints, archives can be restored
for a single dbspace, and other reasons mostly having to do with ease of
managing things later on.

> I can't quite connect the dots in your suggestion to get from where we are
> to where we want to be, but if we can accomplish it with only the need to do
> an UPDATE STATISTICS, that would be phenomenal.

IFF you want to keep the current disk configuration, set up the same chunks
on the new machine, and install 9.21 there. Take an archive on the old
machine, restore it using 9.21 on the new machine, then perform the update
in-place on the new machine. If you have your heart set on a simpler (or at
least different) disk setup then you cannot do this.

Art S. Kagel

> Thank you.
>
>
> DG
>
>
>


Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com

sending to informix-list