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.  Onmode -wm don't change some parametrs

    Posted Thu October 20, 2022 05:46 AM
    Hello.

    I have Informix 14.10 and I am trying to use informix -wm to change onconfig options. But for example "onmode -wm RESIDENT=-1" works well, but "onmode -wm CLEANERS=4" shows me a message saying "The configuration setting to be changed is invalid or not supported with this option".

    Is there a way to change onconfig settings without editing the file?

    ------------------------------
    Alexander Ivanov
    ------------------------------

    #Informix


  • 2.  RE: Onmode -wm don't change some parametrs
    Best Answer

    Posted Thu October 20, 2022 06:17 AM

    Hi Alexander,

    Some parameters in the ONCONFIG file cannot be changed dynamically when the Informix engine works.

    Unhappily, for the "cleaners" parameter, you have to modify your ONCONFIG file and restart your informix instance.

    You have the option "onstat -g cfg tunable" to know the parameters that you can change dynamically (an asterisk indicates that you can tune a configuration parameter dynamically).

    -- Franck Thomas ConsultiX franck.thomas@consult-ix.fr http://www.consult-ix.fr Téléphone : 33 (0) 1 39 12 18 00 Mobile    : 33 (0) 6 78 81 09 33 Fax       : 33 (0) 1 39 12 18 18
    Le 20/10/2022 à 11:46, Alexander Ivanov via IBM Community a écrit :
    01000183f4c97476-0a6a04ae-765a-4dc6-94cc-4a00ec2bf384-000000@email.amazonses.com">
    Hello. I have Informix 14.10 and I am trying to use informix -wm to change onconfig options. But for example "onmode -wm RESIDENT=-1" works well,...
    IBM Community

    Informix

    Post New Message
    Onmode -wm don't change some parametrs
    Reply to Group Reply to Sender
    Alexander Ivanov
    Oct 20, 2022 5:46 AM
    Alexander Ivanov
    Hello.

    I have Informix 14.10 and I am trying to use informix -wm to change onconfig options. But for example "onmode -wm RESIDENT=-1" works well, but "onmode -wm CLEANERS=4" shows me a message saying "The configuration setting to be changed is invalid or not supported with this option".

    Is there a way to change onconfig settings without editing the file?

    ------------------------------
    Alexander Ivanov
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward  



     
    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


  • 3.  RE: Onmode -wm don't change some parametrs

    Posted Thu October 20, 2022 07:01 AM
    For modifying the onconfig file, you'd have to use -wf (rather than -wm, for in-memory only) anyway.

    And yes, there are config parameters that only get evaluated at engine startup, so typically don't need to be tunable, i.e. not supported by 'onmode -w{m|f}'.
    CLEANERS is one of them.

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

    Original Message


Related Content