Dropping a Catalog Dbspace

Under normal circumstances, you need not remove catalog dbspaces; they automatically grow as needed.

  1. Shut down all the servers in the multiplex.
  2. Start the coordinator with the -gm and -iqmpx_sn switches:
    start_iq @params.cfg mpxtest.db -gm 1 
-iqmpx_sn 1 -n mpxnode_c
  3. In Interactive SQL, enter:
    DROP DBSPACE DspCat2
  4. Restart the coordinator normally, without the -iqmpx_sn 1 switch.
  5. Synchronize all secondary servers in the multiplex.
Parent topic: Dbspace Updates in Multiplex