Pinned topic Change onconfig without downtime
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
andreasl 100000CHVU400 Posts
Re: Change onconfig without downtime2012-10-02T06:53:00ZThis is the accepted answer. This is the accepted answer.Hi Bobby,
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.
SystemAdmin 110000D4XK1143 Posts
Re: Change onconfig without downtime2012-10-02T09:04:19ZThis is the accepted answer. This is the accepted answer.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 :)
hans_68 270007KSRK2 Posts
Re: Change onconfig without downtime2015-04-17T12:16:34ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
-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.
JacquesRenaut 1100009H9F1 Post
Re: Change onconfig without downtime2015-04-17T13:49:59ZThis is the accepted answer. This is the accepted answer.
- andreasl 100000CHVU
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.
onmode -wf "LTAPEDEV=/tmp/somefile"