John:
Pretty much, yes. Slight modifications:
0- take a full backup including also /etc/hosts services , ixbar files, oncfg files ...Etc
1- stop Informix (onmode -ky)
2- updrade OS
3- upgrade Informix -
Best practice is to not upgrade Informix in place but to install the new release in a separate directory. Then, since BP is to use a symbolic link for INFORMIXDIR, relink that to the new release's directory, copy ONCONFIG, and ixbar files to the new $INFORMIXDIR/etc (or transfer the ONCONFIG settings to a copy of the new onconfig.std file or add any new parameters in there that were not in the onconfig.std from the older release to the copied ONCONFIG file - either way). Your sqlhosts file should be in the parent directory that holds the INFORMIXDIR link so that you don't have to copy it ever and use INFORMIXSQLHOSTS to point to its path. If you want to keep the sqlhosts file in the default location ($INFORMIXDIR/etc) then copy that from the previous release to the new one as well.
4- start informix
5- update statistics - Best practice is to DROP DISTRIBUTIONS in all databases for all tables then rebuild the distributions from scratch after any version upgrade. If you are using dostats you can just include the --drop-distributions option. If you want to use drive_dostats to process multiple tables in a database in parallel then use --clean-distributions instead as that option drops distributions table by table rather than via a single global command avoiding the possibility that one thread will destroy the distributions created by another thread.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Tue February 09, 2021 06:23 AM
From: John Smith
Subject: OS upgrade and Informix Server
Hi Art
Similar subject so i think no need to another topic :)
in General when we have OS/Informix Migration , on a same server, please advice for the steps below :
of course , according to IBM Compatibility Matrix (https://www.ibm.com/support/pages/informix-server-system-requirements#:~:text=Content&text=IBM%20Informix%20runs%20on%20most,and%20256%20MB%20of%20memory)
0- take a full backup including also /etc/hosts services , ixbar files, oncfg files ...Etc
1- stop Informix (onmode -ky)
2- updrade OS
3- upgrade Informix
4- start informix
5- update statistics ?
best regards
------------------------------
John Smith
Original Message:
Sent: Tue January 19, 2021 02:50 PM
From: Art Kagel
Subject: OS upgrade and Informix Server
My recommendation:
- Take the Informix engine down to single user mode (onmode -s)
- Take an archive and copy the archive file to another machine for safety.
- Shutdown Informix (onmode -ky)
- Upgrade the OS
- Restart Informix
If there are any problems, you can restore the engine from the archive.
I don't expect any problems, however.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Tue January 19, 2021 02:33 PM
From: Celso Freitas de Andrade
Subject: OS upgrade and Informix Server
Hi everyone!
I have an Informix Server version 12.10.FC10WE running in a RHEL 6.5 machine, and we are planning to upgrade the OS version to RHEL 7.0.
So, in order to do this OS upgrade, what would be the best option? Should I move the Informix Server to another machine and then upgrade the OS, or could I just stop the Informix Server, upgrade the OS version, and then start the Informix Server again?
Thanks a lot,
Celso Freitas
------------------------------
Celso Freitas
------------------------------
#Informix