IDS Forum

RE: Migration to 9.4

Posted By: NormaJean.Sebastian@tellabs.com
Date:

Hello,
I believe some concerns on inplace upgrades may come from oracle
experience (or other DB vendors?) I don't mean to bash oracle, I have
only been working with it a year or so. However, it seems that standard
for oracle upgrades is to freshly install binaries in a new directory,
then export the old-version database and import it to the new-version
database. sure makes a pig of filesystem space if left unchecked. i
believe this is standard oracle practice because oracle is not very
concerned with maintaining "under the hood" functionality/etc as
ibm/informix (I can't speak for db2, but informix was/is awesome at it).
for example there doesn't seem to be much similarity between oracle 8
and oracle 9 (especially under the hood) which is probably why "inplace
upgrade" may be a foreign phrase for oracle-ites.

A further comment on Gerd's statement: "You must have plenty of
physical log (if this runs short during migration you have to restore
the old version)"

PLEASE do read the Informix release/machine notes that come with your
binaries. typically these are found in $INFORMIXDIR/release/en_us/0333.
I am upgrading from 7.31 to 9.30 (I'm on SAP... SAP hasn't blessed
Informix 9.4 yet). I have a 1.2TB database, my physical log was too
small. SAP didn't know the answer (we pay them, not ibm for support)).
I found the answer in the Informix machine notes. I did not have to
increase the size of my physical log, i merely had to define a new
ONCONFIG parameter called PLOG_OVERFLOW_PATH. This parameter may only
be for 9.3, I don't know... thus the recommendation to read the informix
provided machine/release notes when you plant the binaries, and before
you start the engine.

have fun....
no doubt, if you prep properly, your inplace upgrade will work like a
charm.... it's and informix database... it will come up ;)

Norma Jean


-----Original Message-----
From: MARTINFU@de.ibm.com [mailto:MARTINFU@de.ibm.com]
Sent: Thursday, March 04, 2004 6:01 AM
To: ljiljana@mizuhocap.com
Cc: forum.subscriber@iiug.org; ids@iiug.org; Sebastian, NormaJean
Subject: RE: Migration to 9.4 [2601]


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
============================================================







-----------------------------------------
============================================================
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
============================================================

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.