Move phisical log

Greetings again I want to move the physical log of a IDS from rootdbs to a new dbs Can I do it in online mode or Do i Have to quisce or down ? Does the users are affect during the change ? Thanks for your help

You can do this online using the onprarms utility, no problem. Consider creating a new Physical Log type dbspace (onspaces -c -p ... ) for this if you are using v12.10+. The Physical Log type dbspace is auto extending by default and can only be used for the physical log. A physical log placed in a Physical Log type dbspace is also auto expanding if the server determines that the physical log is not big enough. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jan 16, 2017 at 12:52 PM, HUGO PADILLA <hugo_padilla@terra.com.mx> wrote: > Greetings again > > I want to move the physical log of a IDS from rootdbs to a new dbs > > Can I do it in online mode or Do i Have to quisce or down ? Does the users > are > affect during the change ? > > Thanks for your help > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a114b41286195d1054639f6f8

As a best practice you should move the physical log from rootdbs to a dedicated dbspace onparams -p -s size -d dbspace -y This must be done in quiescent or administration mode https://www.ibm.com/support/knowledgecenter/SSGU8G_11.50.0/com.ibm.admin.doc/ids _admin_0785.htm