Best Practice to upgrade edition (not version)
I have a system currently installed with 12.10FC8W1 Express Edition (OS is Red Hat Enterprise Linux 7.3 x86_64). I need to change the Informix Edition to be Workgroup but I am staying with the same version. What is the recommended way to accomplish this - is it still to install to a new INFORMIXDIR and then just start the existing instance using the new INFORMIXDIR? Are there any objects in the instance that would need to be upgraded or changed with an edition change? I feel like this should be covered in the docs but all I found was version upgrade info. If I've overlooked it, please let me know! Thanks -Pete McDonnell
Treat an Edition upgrade just like a version upgrade. Just install in a new INFORMIXDIR, configure it copying the critical entries from the existing ONCONFIG file, copy the sqlhosts file (unless you are using INFORMIXSQLHOSTS to point to a file not stored in INFORMIXDIR), shudown the existing instance, point whatever symbolic link you are using as the actual INFORMIXDIR to the new installation (that should also take care of PATHs and library paths, etc), and restart the instance. That's it. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jul 12, 2017 at 2:53 PM, PETE MCDONNELL < pete.mcdonnell@ejustsystems.com> wrote: > I have a system currently installed with 12.10FC8W1 Express Edition (OS is > Red > Hat Enterprise Linux 7.3 x86_64). I need to change the Informix Edition to > be > Workgroup but I am staying with the same version. What is the recommended > way > to accomplish this - is it still to install to a new INFORMIXDIR and then > just > start the existing instance using the new INFORMIXDIR? > > Are there any objects in the instance that would need to be upgraded or > changed with an edition change? > > I feel like this should be covered in the docs but all I found was version > upgrade info. If I've overlooked it, please let me know! > > Thanks > > -Pete McDonnell > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Just start the instance with the other binaries.
There should not be any conversion if you stay at the same version,
you should adjust the buffers/shared memory for the new possibilities in
comparison to express edition....
( 12.10FC8WE, also with patched version W1 (we have a W2 version, but I don't
remember what was fixed)).
Shutdown old instance, save the content of informix directory in an archive,
install the new version in same dir, make sure you have the correct version of
onconfig, sqlhosts, alarm shell script and start it with oninit.
Marcus Haarmann
Von: "PETE MCDONNELL" <pete.mcdonnell@ejustsystems.com>
An: "ids" <ids@iiug.org>
Gesendet: Mittwoch, 12. Juli 2017 21:53:30
Betreff: Best Practice to upgrade edition (not version) [39563]
I have a system currently installed with 12.10FC8W1 Express Edition (OS is Red
Hat Enterprise Linux 7.3 x86_64). I need to change the Informix Edition to be
Workgroup but I am staying with the same version. What is the recommended way
to accomplish this - is it still to install to a new INFORMIXDIR and then just
start the existing instance using the new INFORMIXDIR?
Are there any objects in the instance that would need to be upgraded or
changed with an edition change?
I feel like this should be covered in the docs but all I found was version
upgrade info. If I've overlooked it, please let me know!
Thanks
-Pete McDonnell
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
The fix lists are at http://www-01.ibm.com/support/docview.wss?uid=swg27014361
Regards,
David.
> On 12 July 2017 at 21:00 Marcus Haarmann <marcus.haarmann@midoco.de> wrote:
>
>
> Just start the instance with the other binaries.
> There should not be any conversion if you stay at the same version,
> you should adjust the buffers/shared memory for the new possibilities in
> comparison to express edition....
> ( 12.10FC8WE, also with patched version W1 (we have a W2 version, but I don't
> remember what was fixed)).
>
> Shutdown old instance, save the content of informix directory in an archive,
> install the new version in same dir, make sure you have the correct version
of
> onconfig, sqlhosts, alarm shell script and start it with oninit.
>
> Marcus Haarmann
>
> Von: "PETE MCDONNELL" <pete.mcdonnell@ejustsystems.com>
> An: "ids" <ids@iiug.org>
> Gesendet: Mittwoch, 12. Juli 2017 21:53:30
> Betreff: Best Practice to upgrade edition (not version) [39563]
>
> I have a system currently installed with 12.10FC8W1 Express Edition (OS is
Red
> Hat Enterprise Linux 7.3 x86_64). I need to change the Informix Edition to be
> Workgroup but I am staying with the same version. What is the recommended way
> to accomplish this - is it still to install to a new INFORMIXDIR and then
just
> start the existing instance using the new INFORMIXDIR?
>
> Are there any objects in the instance that would need to be upgraded or
> changed with an edition change?
>
> I feel like this should be covered in the docs but all I found was version
> upgrade info. If I've overlooked it, please let me know!
>
> Thanks
>
> -Pete McDonnell
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>