Move rootdbs Informix 14
Alexander Ivanov could not start 14 FC8 on Windows after changing ROOTPATH and moving the root chunk file. Andreas Legner said renaming a chunk needs a renamed restore with onbar or ontape; Art Kagel added that from 14.10.FC6 a mirror can be used to move it. Alexander solved it with ontape -r -rename.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello. I have an Informix 14 FC8 on Windows host. I want to move rootdbs to another location. I changed ROOTPATH and moved file to another location. But the server can't start Onconfig parameter ROOTPATH modified from E:\\ifmxdata\\rootdbs.000 to E:\\ifmxdate\\ol_dohod\\rootdbs.000 Cannot open Primary Chunk 'E:\\ifmxdata\\rootdbs.000' rootdbs.000 file now in E:\\ifmxdate\\ol_dohod\\ and ROOTPATH= E:\\ifmxdate\\ol_dohod\\rootdbs.000 Is there any additional steps to move rootdbs? ------------------------------ Alexander Ivanov ------------------------------
Is this meant to be empty? I don't see the original message (that was visible in email notification).
In case it's still relevant: the only way for renaming a chunk, even the root chunk, is through a "renamed restore", i.e. a full system restore (onbar or ontape) using the rename option.
------------------------------
Andreas Legner
------------------------------
In v14.10.FC6 and later, in addition to redirected restore (as Andreas mentioned) you can use mirroring to move a chunk. Just add the new chunk as a mirror of the current chunk, let it catch up, then use the SQL API function to swap the primary and mirror chunks. At that point you can drop the mirror which is the original chunk. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
I don't know why I not see any message in this topic.
Thanks
ontape -r -renamehelped me
------------------------------
Alexander Ivanov
------------------------------