You can now create base tables and store data in them that persists after you disconnect. Create these base tables in the local IQ Main Store, a collection of dbspaces owned by the query server. Operations on such tables will not have global effect, so users can continue development operations on a query server without impacting the shared main storage.
Query servers also no longer need to be synchronized after the write server executes DDL on the shared IQ Main Store. Query server synchronization is required only for:
Creating new query servers
Restoring query servers
Restarting an excluded query server
To support this new functionality, the new database option LOCAL_RESERVED_DBSPACE_MB was added. The stored procedures sp_iqcheckdb, sp_iqtable, sp_iqdbsize, and sp_iqspaceinfo have new input arguments, and the stored procedures sp_iqtable, sp_iqcolumn, sp_iqconstraint, and sp_iqindex have new output columns. For more information, see Chapter 2, “Database Options” and Chapter 9, “System Procedures” in Sybase IQ Reference Manual.
