Topic
4 replies Latest Post - ‏2015-04-17T13:49:59Z by JacquesRenaut
SystemAdmin
SystemAdmin
1143 Posts
ACCEPTED ANSWER

Pinned topic Change onconfig without downtime

‏2012-10-02T06:25:52Z |
Hello guys,

I have a short, but important question.
I want to change the LTAPEDEV-parameter in the onconfig-file from "/dev/null" to our "Dataprotector path".

Is it possible to change this configuration without shutting down the Informix server?

Thanks for you reply

Best regards
Updated on 2012-10-02T09:04:19Z at 2012-10-02T09:04:19Z by SystemAdmin
  • andreasl
    andreasl
    369 Posts
    ACCEPTED ANSWER

    Re: Change onconfig without downtime

    ‏2012-10-02T06:53:00Z  in response to SystemAdmin
    Hi Bobby,

    three-fold answer:
    1.) yes, as far as LTAPEDEV is a parameter to the ontape backup and restore utility - ontape will read the onconfig file upon invocation
    2.) no, as far as LTAPEDEV is a parameter to oninit (the database server) and the '/dev/null' has a very special meaning.
    In fact '/dev/null' (or empty, vs. other than '/dev/null') is the only special meaning this parameter has to the database server
    telling it "don't bother backing up logical logs, instead flag them 'backed up' immediately after use and allow them for re-use."
    Changing this will only be picked up by the server upon restart.
    3.) "Dataprotectore" sounds a bit like some storage manager, so onbar being used rather than ontape for backups.
    In case onbar really is used, any value (other than empty or '/dev/null') would be good - onbar wouldn't look at this.

    So in essence the answer is no. You need to restart the database server in order to activate/allow (or deactivate) logical log backups.

    HTH,
    Andreas
    • JacquesRenaut
      JacquesRenaut
      1 Post
      ACCEPTED ANSWER

      Re: Change onconfig without downtime

      ‏2015-04-17T13:49:59Z  in response to andreasl

      You don't mention what version you are using, but doing some testing with 12.10.xC4 you can use onmode -wf/wm to modify LTAPEDEV while the server is online.  Then even if it had been set to /dev/null which makes the server automatically mark the logical logs as backed up, it will stop auto backing up the logical logs once you change it from /dev/null.

      Example command:

      onmode -wf "LTAPEDEV=/tmp/somefile"

      Jacques

  • SystemAdmin
    SystemAdmin
    1143 Posts
    ACCEPTED ANSWER

    Re: Change onconfig without downtime

    ‏2012-10-02T09:04:19Z  in response to SystemAdmin
    Hey,

    thank you for your help!

    You're right, we are using onbar with HP Dataprotector.
    Now, I have planned scheduled donwtime for today, that I can restart the Server :)

    best regards
    • hans_68
      hans_68
      2 Posts
      ACCEPTED ANSWER

      Re: Change onconfig without downtime

      ‏2015-04-17T12:16:34Z  in response to SystemAdmin

      use i.e

      onmode command

       

        -wf <onconfig parameter>=<value>   Update the value
                of the specified configuration parameter and save
                the new value to the onconfig file.
            -wm <onconfig parameter>=<value>   Update the value of
                the specified configuration parameter without saving
                the new value to the onconfig file. The new value is
                written to server memory only and will not be retained
                once the server is restarted.