Hi,

Is it possible to load the full ontape level zero backup from ifx 10 xC4
on to a 11 xC2 version? Both would be running on 32bit linux boxes.

Or is the only way for upgrade to install ifx 11 instead of ifx 10 and
then give ifx 11 the path to the ifx 10 data on disk and just start it up?

Regards,

--
Aleksander Kamenik
system administrator
+372 6659 649
aleksander (AT) krediidiinfo (DOT) ee

Krediidiinfo AS
http://www.krediidiinfo.ee/

On 18/12/2007, Aleksander Kamenik <aleksander (AT) krediidiinfo (DOT) ee> wrote:
Aleksander

It is (almost) never possible to restore an ontape archive from one
version of IDS to another, even down to restoring between different Ux
levels.
Two ways to upgrade. First Install IDS11 in a new directory and point
rootdbs, loglogdbs and physlogdbs in the config file to the old chunks
and then start up. This is call an 'in place' upgrade. Has one or two
initial requirements (such as no outstanding 'in place alters'), but
is generally reliable, quick and simple. There is a back out procedure
that allows reverse conversion.
Second is to install IDS11, create a new config file and a new
instance on fresh disk and then unload/reload all your data. Takes
much longer but has the advantage of enabling new placement of data
and indexes, defragmenting the data and generally tidying the
instance. Your old instance is always available in the event of major
issues and this method is easier to test as it is non-destructive of
your data.
Look at the Migration Guide, this is why it was written !!

Keith

Hi,

backups are not to be used for restore in a different version of IDS.
Therefore they are not useable for upgrades.

You are adviced to take a backup before upgrade, but that is just
for data safety. To restore it you'd first have to go back to the version
with which the backup was taken.

Right. After taking the backup you start IDS with the new version.
This may be installed in a different directory, but then at a minimum
you'd have to copy over the sqlhosts file and the onconfig file.
The new IDS will do any necessary conversion of the data.
After that the upgrade is finished.

At this point I advice you to again take a backup - with the new version.

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland GmbH
Chairman of the Supervisory Board: Hans Ulrich Märki
Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian
Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael
Diemer
Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart,
HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940

informix-list-bounces (AT) iiug (DOT) org wrote on 18.12.2007 14:56:51:

Martin Fuerderer wrote:
Right, thanks everybody. I just wanted to know if a server migration
from one box to another with an ifx upgrade is possible without
installing the old ifx version first.

Unless it's possible to move the data too. Like when it's installed on
raw partitions and separate drive and the drive is moved to the new box
too. Then there's no point in installing ifx 10 first, correct?

Regards,

--
Aleksander Kamenik
system administrator
+372 6659 649
aleksander (AT) krediidiinfo (DOT) ee

Krediidiinfo AS
http://www.krediidiinfo.ee/

Yes, if you move the physical chunks to the new machine one way or
another, you can just bring the engine up with the new version and it
will perform an in-place upgrade. However, if that fails or there are
any bugs or performance problems you can't get around you may want to
downgrade back to the original version. In that case it would be good
to have already installed the earlier release on the box so you can
just run the onmode reversion option, shutdown, and restart the older
release quickly.

Art S. Kagel
Oninit

Aleksander Kamenik wrote: