Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Upgrade to 14.10.FC10

    Posted Tue April 11, 2023 01:16 PM

    Anybody run across this issue, trying to upgrade from 14.10.FC5 to 14.10.FC10. As root user, I copied the FC5 directory as a new FC10 directory, Extracted the FC10 install into the new directory and export the INFORMIXDIR to the new directory. I then ran ./ids_install, but it ends with this error:

    ===============================================================================
    Installer running as incorrect user
    -----------------------------------
    
    The selected directory contains a private installation
    Only the user informix can upgrade this installation
    
      ->1- Select a different installation directory
        2- Cancel the installation
    
    ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS <ENTER> TO ACCEPT THE
       DEFAULT: 2


    ------------------------------
    Pete Rushie
    ------------------------------


  • 2.  RE: Upgrade to 14.10.FC10

    Posted Tue April 11, 2023 02:01 PM
    Edited by Art Kagel Tue April 11, 2023 02:02 PM

    Pete:

    It is complaining that you tried to install FC10 over a copy of FC5 as a user other than informix or root. Also, better method:

    - Wipe out the copy of FC5.
    - Create the new directory empty with the proper permissions (owner and group informix and permissions 755 or 775.
    - Unpack the installer in a different directory somewhere (NOT THE NEW INFORMIXDIR!)
    - export INFORMiXDIR=<new informixdir path>
    - From the directory with the installer, run the installer: ./ids_install as root
    - Go through the prompts.
    - Copy the following files from the .FC5 installation:
        - $INFORMIXDIR/etc/$ONCONFIG
        - $INFORMIXDIR/etc/alarmprogram.sh  if you made any changes to it.
        - Any libraries you have installed in $INFORMIXDIR/extend that are not already in the .FC10 directory
    - Shutdown the .FC5 instance
    - Change the global INFORMIXDIR to point to the new .FC10 installation.

    NOTE: Best practice is to use a symbolic link for INFORMIXDIR so you do not ever have to change multiple environment scripts when you upgrade. For example, I use /opt/informix/infmx pointing to the actual installation, so for example ln -s /opt/informix/ids_14.10.FC10 /opt/informix/infmx. Then my INFORMIXDIR is always set to /opt/informix/infmx and when I install 14.10.FC11 I will just have to do:
    rm $INFORMIXDIR
    ln -s /opt/informix/ids_14.10.FC11 $INFORMIXDIR

    and all is well.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: Upgrade to 14.10.FC10

    Posted Tue April 11, 2023 02:13 PM
    Don't forget the license key

    On 4/11/2023 1:01 PM, Art Kagel via IBM Community wrote:
    01000187717aa8f0-eef7d9ab-21a4-4200-a7b0-e29925f062e6-000000@email.amazonses.com">
    Pete: It is complaining that you tried to install FC10 over a copy of FC5 as a user other than informix or root. Also, better method: - Wipe out... -posted to the "Informix" group
    IBM Community

    Informix

    Post New Message
    Re: Upgrade to 14.10.FC10
    Reply to Group Reply to Sender
    Art Kagel
    Apr 11, 2023 2:01 PM
    Art Kagel

    Pete:

    It is complaining that you tried to install FC10 over a copy of FC5 as a user other than informix or root. Also, better method:

    - Wipe out the copy of FC5.
    - Create the new directory empty with the proper permissions (owner and group informix and permissions 755 or 775.
    - Unpack the installer in a different directory somewhere (NOT THE NEW INFORMIXDIR!)
    - export INFORMiXDIR=<new informixdir path>
    - From the directory with the installer, run the installer: ./ids_install
    - Go through the prompts.
    - Copy the following files from the .FC5 installation:
        - $INFORMIXDIR/etc/$ONCONFIG
        - $INFORMIXDIR/etc/alarmprogram.sh  if you made any changes to it.
        - Any libraries you have installed in $INFORMIXDIR/extend that are not already in the .FC10 directory
    - Shutdown the .FC5 instance
    - Change the global INFORMIXDIR to point to the new .FC10 installation.

    NOTE: Best practice is to use a symbolic link for INFORMIXDIR so you do not ever have to change multiple environment scripts when you upgrade. For example, I use /opt/informix/infmx pointing to the actual installation, so for example ln -s /opt/informix/ids_14.10.FC10 /opt/informix/infmx. Then my INFORMIXDIR is always set to /opt/informix/infmx and when I install 14.10.FC11 I will just have to do:
    rm $INFORMIXDIR
    ln -s /opt/informix/ids_14.10.FC11 $INFORMIXDIR

    and all is well.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  




     
    You are subscribed to "Informix" as paul@oninit.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.



    Original Message:
    Sent: 4/11/2023 2:01:00 PM
    From: Art Kagel
    Subject: RE: Upgrade to 14.10.FC10

    Pete:

    It is complaining that you tried to install FC10 over a copy of FC5 as a user other than informix or root. Also, better method:

    - Wipe out the copy of FC5.
    - Create the new directory empty with the proper permissions (owner and group informix and permissions 755 or 775.
    - Unpack the installer in a different directory somewhere (NOT THE NEW INFORMIXDIR!)
    - export INFORMiXDIR=<new informixdir path>
    - From the directory with the installer, run the installer: ./ids_install as root
    - Go through the prompts.
    - Copy the following files from the .FC5 installation:
        - $INFORMIXDIR/etc/$ONCONFIG
        - $INFORMIXDIR/etc/alarmprogram.sh  if you made any changes to it.
        - Any libraries you have installed in $INFORMIXDIR/extend that are not already in the .FC10 directory
    - Shutdown the .FC5 instance
    - Change the global INFORMIXDIR to point to the new .FC10 installation.

    NOTE: Best practice is to use a symbolic link for INFORMIXDIR so you do not ever have to change multiple environment scripts when you upgrade. For example, I use /opt/informix/infmx pointing to the actual installation, so for example ln -s /opt/informix/ids_14.10.FC10 /opt/informix/infmx. Then my INFORMIXDIR is always set to /opt/informix/infmx and when I install 14.10.FC11 I will just have to do:
    rm $INFORMIXDIR
    ln -s /opt/informix/ids_14.10.FC11 $INFORMIXDIR

    and all is well.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 4.  RE: Upgrade to 14.10.FC10

    Posted Tue April 11, 2023 03:46 PM

    That was my intent to install FC10 over FC5 and I am doing it as the root user. We have always been able to do this in the past. According to the documentation here: https://www.ibm.com/docs/en/informix-servers/14.10?topic=installation-directory
    You can install in a non-empty directory if you are just upgrading fix packs of the same version.
    We are using symbolic links also. My reasoning for doing it this way, was so I do not have to re-install all the other Informix tools (CSDK, SQL, etc.).
    What do you mean by "Wipe out the copy of FC5"?

    Thanks,

    Pete



    ------------------------------
    Pete Rushie
    ------------------------------



  • 5.  RE: Upgrade to 14.10.FC10

    Posted Tue April 11, 2023 04:08 PM

    By "Wipe out the copy of FC5" I just meant to clean out the failed installation of .FC10 and start from scratch.

    Also, there were several improvements in the CSDK v4.50.FC7 including a fix to a long standing (since early 4.10) bug affecting the ability to use LVARCHAR effectively under some circumstances. So upgrading that to .FC10 as well is not a bad thing.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------