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.  ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Mon June 19, 2023 06:40 PM

    Hi Folks.

    I feel so stupid asking this and there is an easy solution to my little conundrum anyway.  But I've been away for too long and some things have just faded from my memory.  So here it is:

    Of course when I specify in my ENV:

    export ONCONFIG=onconfig.schmoe

    then when I try to connect to (or initialize) my server it looks in $INFORMIXDIR/etc for that file.  I have a memory from 2008 that the bank where I was working had set ONCONFIG=<Some other directory>/ONCONFIG.schmoe 

    I was trying to configure my environment similarly:

    export ONCONFIG=/ifmx/onconfig.schmoe

    but oninit -t tells me:

    unable to open /ifmx/ids.14.10.FC10/etc//ifmx/onconfig.schmoe

    That is: Looking under $INFORMIXDIR although I had specified a complete path.

    Obviously the solution is to just put that into $INFORMIXDIR/etc, set ONCONFIG= just the unembellished name of the file and toe the line like a nice little DBA.

    My memory aside: Is there a way to do it in a path independent of INFORMIXDIR?

    Why in blazes does he even want to do this?  Glad you ased that question! ;-)

    The aforementioned bank had many different releases of Informix on one box. As I recall it, all the ONCONFIG files were consolidated in one directory so I could upgrade one instance and not have to chase down its ONCONFIG file to copy into the INFORMIXDIR/etc  of the upgraded server.



    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------


  • 2.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc
    Best Answer

    Posted Mon June 19, 2023 06:59 PM

    Jacob:

    You can only do that with the sqlhosts file using the INFORMIXSQLHOSTS environment variable. There is no equivalent for the onconfig file. 

    Art



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

    Original Message


  • 3.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Tue June 20, 2023 04:12 AM

    You can create $INFORMIXDIR/etc/$ONCONFIG as a link to the file in your common config directory, and that might well have been what they did back in the day.

    Nowadays this probably would only work until your next 'onmode -wf' command, and even without it the server might decide to update onconfig which typically occurs through renaming the existing $INFORMIXDIR/etc/$ONCONFIG, in this location, and continuing with a modified copy - which isn't going to be a link any more.

    Andreas



    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


  • 4.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Tue June 20, 2023 05:25 AM

    Hi,

    From my side, I have never had a problem with "onmode -wf" and the use of a link.

    The "onmode -wf" command works by directly updating the file corresponding to the symbolic link and keeping the link in the $INFORMIXDIR directory.



    -- Franck Thomas ConsultiX franck.thomas@consult-ix.fr http://www.consult-ix.fr
    Le 20/06/2023 à 10:12, Andreas Legner via IBM TechXchange Community a écrit :
    01000188d7dcae57-438bd015-827d-4582-8d96-0fba786138cb-000000@email.amazonses.com">
    You can create $INFORMIXDIR/etc/$ONCONFIG as a link to the file in your common config directory, and that might well have been what they did back... -posted to the "Informix" group
    IBM TechXchange Community

    Informix

    Post New Message
    Re: ONCONIFG in a directory other than $INFORMIXDIR/etc
    Reply to Group Reply to Sender
    Andreas Legner
    Jun 20, 2023 4:12 AM
    Andreas Legner

    You can create $INFORMIXDIR/etc/$ONCONFIG as a link to the file in your common config directory, and that might well have been what they did back in the day.

    Nowadays this probably would only work until your next 'onmode -wf' command, and even without it the server might decide to update onconfig which typically occurs through renaming the existing $INFORMIXDIR/etc/$ONCONFIG, in this location, and continuing with a modified copy - which isn't going to be a link any more.

    Andreas



    ------------------------------
    Andreas Legner
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  

    Original Message



     
    You are subscribed to "Informix" as franck.thomas@consult-ix.fr. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.



    Original Message:
    Sent: 6/20/2023 4:12:00 AM
    From: Andreas Legner
    Subject: RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    You can create $INFORMIXDIR/etc/$ONCONFIG as a link to the file in your common config directory, and that might well have been what they did back in the day.

    Nowadays this probably would only work until your next 'onmode -wf' command, and even without it the server might decide to update onconfig which typically occurs through renaming the existing $INFORMIXDIR/etc/$ONCONFIG, in this location, and continuing with a modified copy - which isn't going to be a link any more.

    Andreas



    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message:
    Sent: Mon June 19, 2023 06:59 PM
    From: Art Kagel
    Subject: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Jacob:

    You can only do that with the sqlhosts file using the INFORMIXSQLHOSTS environment variable. There is no equivalent for the onconfig file. 

    Art



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


  • 5.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Tue June 20, 2023 05:30 AM

    You're right - I was wrong.  The link is preserved, the actual file gets updated and no 'before image' copy gets created.

    Thanks for correction!



    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


  • 6.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Wed June 21, 2023 10:48 AM

    Thanks for you all who ganged up on me (kidding here) to tell me how wrong I am.  No, $ONCONFIG MUST refer to a file under $INFORMIXDIR/etc/  However, Art reminded me of what was going on at that bank:  The $INFORMIXSQLHOSTS can be anywhere, not dependent on $INFORMIXDIR.  That must be what I had mis-remembered.

    Again, thank to y'all but mostly thanks to Art.

    -- Jacob S



    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------

    Original Message


  • 7.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Wed June 21, 2023 10:53 AM
    ONCONFIG, REMOTE_CFG file, EAR files and the SSL directory are the only ones that must live under $INFORMIXDIR  AFAIR.  But all can be links

    Cheers
    Paul

    On 6/21/2023 9:47 AM, Jacob Salomon via IBM TechXchange Community wrote:
    01000188de6cfe30-082584ef-a41b-4a08-b5a4-9fda545c6274-000000@email.amazonses.com">
    Thanks for you all who ganged up on me (kidding here) to tell me how wrong I am.  No, $ONCONFIG MUST refer to a file under $INFORMIXDIR/etc/ ...
    IBM TechXchange Community

    Informix

    Post New Message
    Re: ONCONIFG in a directory other than $INFORMIXDIR/etc
    Reply to Group Reply to Sender
    Jacob Salomon
    Jun 21, 2023 10:48 AM
    Jacob Salomon

    Thanks for you all who ganged up on me (kidding here) to tell me how wrong I am.  No, $ONCONFIG MUST refer to a file under $INFORMIXDIR/etc/  However, Art reminded me of what was going on at that bank:  The $INFORMIXSQLHOSTS can be anywhere, not dependent on $INFORMIXDIR.  That must be what I had mis-remembered.

    Again, thank to y'all but mostly thanks to Art.

    -- Jacob S



    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  

    Original Message



     
    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: 6/21/2023 10:48:00 AM
    From: Jacob Salomon
    Subject: RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Thanks for you all who ganged up on me (kidding here) to tell me how wrong I am.  No, $ONCONFIG MUST refer to a file under $INFORMIXDIR/etc/  However, Art reminded me of what was going on at that bank:  The $INFORMIXSQLHOSTS can be anywhere, not dependent on $INFORMIXDIR.  That must be what I had mis-remembered.

    Again, thank to y'all but mostly thanks to Art.

    -- Jacob S



    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------

    Original Message:
    Sent: Mon June 19, 2023 06:59 PM
    From: Art Kagel
    Subject: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Jacob:

    You can only do that with the sqlhosts file using the INFORMIXSQLHOSTS environment variable. There is no equivalent for the onconfig file. 

    Art



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


  • 8.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Tue June 20, 2023 05:02 AM

    Hi Jacob,

    Your ONCONFIG file must be located in the $INFORMIXDIR/etc directory, you have no other choice.
    The ONCONFIG value cannot contain the directory path.
    If you want to bundle your onconfig files from different releases of informix in the same directory, you should consider consider using a symbolic link.
    For example :
    ln -s /ifmx/onconfig.schmoe /ifmx/ids.14.10.FC10/etc/onconfig.schmoe
    export ONCONFIG=onconfig.schmoe

    Indeed, Informix can start without problems if your ONONCONFIG file in $INFORMIXDIR/etc is a symbolic link!

    --

    Franck Thomas ConsultiX franck.thomas@consult-ix.fr http://www.consult-ix.fr
    Le 20/06/2023 à 00:39, Jacob Salomon via IBM TechXchange Community a écrit :
    01000188d5d0820c-bb16c02d-b99a-4a8e-bced-f3e53e93b416-000000@email.amazonses.com">
    Hi Folks. I feel so stupid asking this and there is an easy solution to my little conundrum anyway.  But I've been away for too long and some...
    IBM TechXchange Community

    Informix

    Post New Message
    ONCONIFG in a directory other than $INFORMIXDIR/etc
    Reply to Group Reply to Sender
    Jacob Salomon
    Jun 19, 2023 6:40 PM
    Jacob Salomon

    Hi Folks.

    I feel so stupid asking this and there is an easy solution to my little conundrum anyway.  But I've been away for too long and some things have just faded from my memory.  So here it is:

    Of course when I specify in my ENV:

    export ONCONFIG=onconfig.schmoe

    then when I try to connect to (or initialize) my server it looks in $INFORMIXDIR/etc for that file.  I have a memory from 2008 that the bank where I was working had set ONCONFIG=<Some other directory>/ONCONFIG.schmoe 

    I was trying to configure my environment similarly:

    export ONCONFIG=/ifmx/onconfig.schmoe

    but oninit -t tells me:

    unable to open /ifmx/ids.14.10.FC10/etc//ifmx/onconfig.schmoe

    That is: Looking under $INFORMIXDIR although I had specified a complete path.

    Obviously the solution is to just put that into $INFORMIXDIR/etc, set ONCONFIG= just the unembellished name of the file and toe the line like a nice little DBA.

    My memory aside: Is there a way to do it in a path independent of INFORMIXDIR?

    Why in blazes does he even want to do this?  Glad you ased that question! ;-)

    The aforementioned bank had many different releases of Informix on one box. As I recall it, all the ONCONFIG files were consolidated in one directory so I could upgrade one instance and not have to chase down its ONCONFIG file to copy into the INFORMIXDIR/etc  of the upgraded server.



    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  



     
    You are subscribed to "Informix" as franck.thomas@consult-ix.fr. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.



    Original Message


  • 9.  RE: ONCONIFG in a directory other than $INFORMIXDIR/etc

    Posted Tue June 20, 2023 06:47 AM
    It must be in $INFORMIXDIR/etc/ but can be a link to a 'general area'. The same rules apply to a number of config files

    Cheers
    Paul

    On 6/19/2023 5:39 PM, Jacob Salomon via IBM TechXchange Community wrote:
    01000188d5d081a4-8f1d26d6-0051-43c6-9597-032727fb707c-000000@email.amazonses.com">
    Hi Folks. I feel so stupid asking this and there is an easy solution to my little conundrum anyway.  But I've been away for too long and some...
    IBM TechXchange Community

    Informix

    Post New Message
    ONCONIFG in a directory other than $INFORMIXDIR/etc
    Reply to Group Reply to Sender
    Jacob Salomon
    Jun 19, 2023 6:40 PM
    Jacob Salomon

    Hi Folks.

    I feel so stupid asking this and there is an easy solution to my little conundrum anyway.  But I've been away for too long and some things have just faded from my memory.  So here it is:

    Of course when I specify in my ENV:

    export ONCONFIG=onconfig.schmoe

    then when I try to connect to (or initialize) my server it looks in $INFORMIXDIR/etc for that file.  I have a memory from 2008 that the bank where I was working had set ONCONFIG=<Some other directory>/ONCONFIG.schmoe 

    I was trying to configure my environment similarly:

    export ONCONFIG=/ifmx/onconfig.schmoe

    but oninit -t tells me:

    unable to open /ifmx/ids.14.10.FC10/etc//ifmx/onconfig.schmoe

    That is: Looking under $INFORMIXDIR although I had specified a complete path.

    Obviously the solution is to just put that into $INFORMIXDIR/etc, set ONCONFIG= just the unembellished name of the file and toe the line like a nice little DBA.

    My memory aside: Is there a way to do it in a path independent of INFORMIXDIR?

    Why in blazes does he even want to do this?  Glad you ased that question! ;-)

    The aforementioned bank had many different releases of Informix on one box. As I recall it, all the ONCONFIG files were consolidated in one directory so I could upgrade one instance and not have to chase down its ONCONFIG file to copy into the INFORMIXDIR/etc  of the upgraded server.



    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------
      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. 

    --  Paul Watson Oninit www.oninit.com Tel: +1 913 364 0360 Cell: +1 913 387 7529  Oninit® is a registered trademark of Oninit LLC  If you want to improve, be content to be thought foolish and stupid Failure is not as frightening as regret



    Original Message


Related Content