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.  Move rootdbs Informix 14

    Posted Mon May 15, 2023 02:51 AM

    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
    ------------------------------


  • 2.  RE: Move rootdbs Informix 14
    Best Answer

    Posted Mon May 15, 2023 06:15 AM

    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
    ------------------------------



  • 3.  RE: Move rootdbs Informix 14

    Posted Mon May 15, 2023 07:52 AM

    I don't know why I not see any message in this topic.
    Thanks ontape -r -rename helped me



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

    Original Message


  • 4.  RE: Move rootdbs Informix 14

    Posted Mon May 15, 2023 06:48 AM

    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
    ------------------------------



Related Content