Adding a Catalog Dbspace

Under normal circumstances, you will need not add catalog dbspaces; they automatically grow as needed. However, if your catalog dbspace file is on constrained storage, you may need to add a new catalog dbspace to accommodate catalog data.

1. Shut down all servers in the multiplex.
2. Start the coordinator in single node mode:

   start_iq @params.cfg mpxtest.db -iqmpx_sn 1 
   -n mpxnode_c

3. Create the dbspace:

   CREATE DBSPACE DspCat2 AS 'sadb2.db' 
   CATALOG STORE

4. Restart the coordinator without the -iqmpx_sn 1 switch:

   start_iq @params.cfg mpxtest.db -n mpxnode_c

5. Synchronize all secondary servers in the multiplex.