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.  Attaching a detached partition

    Posted 7 hours ago

    Dear All,

      I'm trying to attach a detached partition back to the table , for which I took backup of detached partition. But I'm getting syntax error.

    I'm testing on my personal laptop.

    OS : Redhat 7.9 , IDS 14.10 

    but when I change the process as below, it works.

    could some please help me with first solution?

    Thanks

    Amit Patel 



    ------------------------------
    AMIT PATEL
    ------------------------------


  • 2.  RE: Attaching a detached partition

    Posted 4 hours ago

    Hi Amit,

    I think the "IN <dbspace>" clause makes no sense with ALTER FRAGMENT ... ATTACH.



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------

    Original Message


  • 3.  RE: Attaching a detached partition

    Posted 2 hours ago

    Amit: 

    Besides the "IN dbspace" clause issue that Andreas noted, you have another syntax issue, try this:

    alter fragment on table emp attache z_emp_tabl_prtn_202511 as partition tabl_prtn_202511;

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


Related Content