IDS Forum

Re: Migration to 9.4

Posted By: Martin Fuerderer
Date: Thursday, 4 March 2004, at 10:10 a.m.

In Response To: RE: Migration to 9.4 (NormaJean.Sebastian@tellabs.com)

Hi,

no. It's not expected to work.

You would have to use dbexport/dbimport for that
kind of operation.
Or use High Performance Loader to get things
done faster than with dbexport/dbimport.

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich
Data Management Solutions




Ljiljana Zivanovic <ljiljana@mizuhocap.com>
04.03.2004 15:45

To
Martin Fuerderer/Germany/IBM@IBMDE
cc
forum.subscriber@iiug.org, ids@iiug.org, NormaJean.Sebastian@tellabs.com
Subject
Re: Migration to 9.4 [2601]






Hi,

the way I asked question might be little bit confusing. Let me put it
this way. We will normally do "in place migration" it is not the
question. But lets say I have machine with IDS 9.3 and the other one
with IDS 9.4. Can I onunload database on 9.3 and onload it on 9.4 ?
Does that work? For 9.2-->9.3 as I stated previously it doesn't.

--
Ljiljana


Martin Fuerderer wrote:
>
> Hi,
>
> Norma Jean is right (and Madison too, of course).
>
> And it's not only that you can do the migration forward, i.e. from
> 9.20 to 9.30 to 9.40 (and I even think for 9.20 to 9.40 you might not
> need 9.30 as an intermediate step, but I'm not sure).
>
> Generally you can even go backwards, i.e. revert backwards,
> unless you start using new features in 9.40 that didn't exist in the
> earlier version ...
>
> You can read all about this in detail in the "IBM Informix Migration
> Guide" manual (make sure you're looking at this manual's edition
> for IDS 9.40).
>
> Additionally I would recommend doing a level 0 backup before
> starting the migration, but that is described in the manual as well.
>
> [ No need for onunload/onload at all. These utilities write and read
> data in a binary format that is (in parts) specific to the version
> of IDS in use. Therefore they are not useful for migration, because
they
> will not "adapt" the data to the new binary format of the new version.
> But this is exactly what is done by the "in place migration", i.e. the
> normal and recommended way of migration, that Norma Jean and
> Madison are talking about. ]
>
> Regards,
> Martin
> --
> Martin Fuerderer
> IBM Informix Development Munich
> Data Management Solutions
>
> "NormaJean.S...." <NormaJean.Sebastian@tellabs.com>
> Sent by: forum.subscriber@iiug.org
> 04.03.2004 02:29
>
> To
> ids@iiug.org
> cc
>
> Subject
> RE: Migration to 9.4 [2601]
>
> I'm confused.
> Why would you use onunload/onload to migrate when it's so easy to do
> inplace Informix upgrades?
>
> Don't people generally stop the DB, install the new binaries in
> $INFORMIXDIR, make any environment/system changes per Informix machine
> notes, then start the engine.... and informix converts. Informix is so
> cool that way.
>
> Generally we do not do "in place" upgrades of Oracle cuz it's so much
> more complex and glitchy.
>
> Norma Jean
>
> -----Original Message-----
> From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com]
> Sent: Wednesday, March 03, 2004 6:10 PM
> To: ids@iiug.org; forum.subscriber@iiug.org
> Subject: Re: Migration to 9.4 [2600]
>
> 9.3->9.4 should work with no problem.
>
>
>
> "Ljiljana Zi...."
>
> <ljiljana@mizuhoc To: ids@iiug.org
>
> ap.com> cc:
>
> Sent by: Subject: Migration to
> 9.4 [2599]
> forum.subscriber@
>
> iiug.org
>
>
>
>
>
> 03/03/2004 02:24
>
> PM
>
>
>
> Hi,
> we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use
> onunload/onload for migrating databases? I know that for 9.20 -> 9.30
> it is not working. How about 9.30 -> 9.40?
> Thanks.
> Ljiljana Zivanovic
>
> -----------------------------------------
> ============================================================
> The information contained in this message may be privileged
> and confidential and protected from disclosure. If the
> reader of this message is not the intended recipient, or an
> employee or agent responsible for delivering this message to
> the intended recipient, you are hereby notified that any
> reproduction, dissemination or distribution of this
> communication is strictly prohibited. If you have received
> this communication in error, please notify us immediately by
> replying to the message and deleting it from your computer.
>
> Thank you.
> Tellabs
> ============================================================[attachment
"ljiljana.vcf" deleted by Martin Fuerderer/Germany/IBM]
---------------------------------------------------------

This e-mail contains information some or all of which may be

confidential, proprietary and/or legally privileged. If an

addressing or transmission error has misdirected this e-mail,

please notify the sender by replying to this e-mail. If you

are not the intended recipient you must not use, disclose,

distribute, copy, print or rely on this e-mail.

---------------------------------------------------------

Messages In This Thread

• Migration to 9.4
  Ljiljana Zivanovic -- Wednesday, 3 March 2004, at 5:24 p.m.
  • Re: Migration to 9.4
    Madison Pruet -- Wednesday, 3 March 2004, at 7:09 p.m.
    • RE: Migration to 9.4
      NormaJean.Sebastian@tellabs.com -- Wednesday, 3 March 2004, at 8:29 p.m.
      • RE: Migration to 9.4
        Martin Fuerderer -- Thursday, 4 March 2004, at 7:05 a.m.
        • RE: Migration to 9.4
          Darren_Jacobs@carmax.com -- Thursday, 4 March 2004, at 8:45 a.m.
          • Fwd: RE: Migration to 9.4
            ART KAGEL, BLOOMBERG/ 499 PARK -- Thursday, 4 March 2004, at 10:35 a.m.
            • Antw: IDS: Fwd: RE: Migration to 9.4
              Andreas.KUTSCHE@spar.at -- Saturday, 6 March 2004, at 10:43 a.m.
        • Re: RE: Migration to 9.4
          MAHESH DASHORA -- Thursday, 4 March 2004, at 10:17 p.m.
      • RE: Migration to 9.4
        NormaJean.Sebastian@tellabs.com -- Thursday, 4 March 2004, at 8:21 a.m.
        • RE: Migration to 9.4
          cberner99@juno.com -- Friday, 5 March 2004, at 9:27 a.m.
      • Re: Migration to 9.4
        Ljiljana Zivanovic -- Thursday, 4 March 2004, at 9:49 a.m.
      • Re: Migration to 9.4
        Martin Fuerderer -- Thursday, 4 March 2004, at 10:10 a.m.
    • RE: Migration to 9.4
      Madison Pruet -- Wednesday, 3 March 2004, at 11:23 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.