Users may create an IQ Local Store on one or more query servers in order to create and store persistent objects. These objects will be visible to all users of that query server, but not to users on other servers of the multiplex, so users of that server could continue development operations without affecting the shared main storage.
Users can create, modify and query the following persistent objects and associated metadata, using SQL statements:
Base tables
Indexes
Domains (user-defined data types)
Referential integrity constraints
User names and permissions
Views
Stored procedures
For details about creating and populating persistent objects, see Table 5-9.
DROP
DOMAIN is prohibited on a multiplex query server without a local
IQ Store. Synchronizing the multiplex removes domains from query servers
without IQ Local Stores. If the Query Server has an IQ Local Store, then
both CREATE DOMAIN and DROP DOMAIN are permitted.
