For completeness sake, there also might be this most simple option
7. switch old machine's Informix storage to new machine any continue there with that same physical storage
This of course depends on a few factors, like raw/cooked files, logical volumes, storage simple to unmount here and mount there, etc...
Of course the new machine had to see the chunks under same names, wether as actual file names or as symbolic links.
BR,
Andreas Legner
------------------------------
Andreas Legner
------------------------------
Original Message:
Sent: Mon March 28, 2022 01:36 AM
From: Markus Holzbauer
Subject: Migrate database from Solaris 10 to Solaris 11
What's about:
6. Continous log restore (CLR).
https://www.ibm.com/docs/en/informix-servers/14.10?topic=data-configuring-continuous-log-restore-by-using-bar
Cheers,
Markus
------------------------------
Markus Holzbauer
Original Message:
Sent: Fri March 25, 2022 02:13 PM
From: Layth Yousif
Subject: Migrate database from Solaris 10 to Solaris 11
Hello,
Need some advice.
I trying to find what is the best way to migrate the same version of Informix.
We do have 2 different Solaris servers, the current one is Solaris 10 and the another ( new ) is with Solaris 11.
Inormix server is running in the current one with Solaris 10, as a single instance using Veritas for the cluster.
We install Solaris 11 on a new server and we would like to migrate Informix from the current machine (Solaris 10) to the new machine (Solaris 11).
I tried to find on IBM documentation the best way to migrate Informix in the same OS but different version, I could not find exact what I was searching for.
So my question is, what is the best way to do it with very short downtime.
I have the following thoughts
- I can not use Export/Import cose the database is 1.5 TB and it will take to long time.
- Shutdown the database and copy the chunks/cooked files from the current server to the new server, both file system is UFS is it a possible way?
- Configure the current database server using HDR and run a physical restore of the database to the new server and then sync both databases Using HDR, and when it is time to cut over, make the new server the primary and the old server to be the secondary, note that the filesystem is UFS on both servers, is it a posible way technically?
- A physical restore to the new server and then sync both server using ER, might take time to check all tables PK,FK.
- Just a cold backup from the old server and restore it on the new server, this will take long time but is it possible?
Best Regards
//Layth
------------------------------
Layth Yousif
------------------------------
#Informix