Informix: transit to new host

[Uli_3]

Hello Ralph,

one part of my job is do such migrations, and I have done this a lot of times (more than 30 times). And I agree to 100% with Seth: It sounds easy but it is not. I never used dd, dbexport or onunload to do this (to slow, to much data). I used sometimes ontape (it works fine), but the most times I use onbar (with omniback). All what I can say, if you have no experience with this tings, get a specialist to this for you.

Kind regards
Uli

[Carlos Roberto Schimidt]

We have done a migrate from Informix (250GB) for AIX .4.3.3 fo AIX 5.2 64 bits using dd.
It´s supported by Informix.

For better perfomance create a filesystem in remote machine and export.

logged as user informix, and:

onmode -c block

Mount filesystem in source machine, and create script for read all raw devices, and make dd, for example:

dd if=${chunk} of=/testmigra/`basename $chunk`.bak bs=512k

where testmigra is NFS in remote machine.

In remote machine run:

dd if=/testmigra/`basename $chunk`.bak bs=512k of=${chunk}

After transfer all chunks, log as informix in remote machine and run:

onbar -r -e

How long time for migrate 250GB? Two hours.

It´s recomended run oncheck after migration, but we don´t had errors.


dd if=${chunk} | remsh "dd of=${chunk} bs=512k" it´s take much more time. I hav

[Tim D Fulford]

Here how I'd do it... cowboy boots & spurs a jangling an' all

1 - create users (you've done this)
2 - copy over Informix binaries over network
# tar cf - /usr/informix | gzip - | remsh " gunzip - | tar xf -"
ALTERNATIVELY, do a proper install of Informix (same version as the original system!!)
3 - edit $INFORMIXDIR/etc/sqlhosts to point at new host
4 - stop live system
% onmode -yuk
5 - backup host to tape
% ontape -s -L 0
6 - Restore on other host (after moving the tape over)
% ontape -r
7 - wait till it has finished fast recovery
% onstat - ... ook for quiesent
8 - bring on-line
% onmode -m

Tim

[Tim D Fulford]

oops forgot, put in the required informix links in /usr/lib, on the origoinal host look for what links are required....

# cd /usr/lib
# ls -l | egrep -i informix

Then simply re-create them on target system...
# cd /usr/lib
# ln -s /usr/informix/lib/iosm09a.sl .
# ln -s /usr/informix/lib/ipldd09a.sl .

etc...

Regards

Tim