A single dbspace for the IQ shared temporary store, IQ_SHARED_TEMP, is created when you create a database or upgrade a 12.7 ESD #5 or higher IQ database to SAP Sybase IQ 16.0. This dbspace stores temporary structures that are shared among nodes for distributed query processing.
Initially, this dbspace contains no files. To add files, use ALTER DBSPACE ADD FILE. Allocating files to this dbspace is optional and required only for distributed query processing in multiplex servers.
When you set the TEMP_DATA_IN_SHARED_TEMP logical server policy option ON, all temporary table data and eligible scratch data writes to the shared temporary store, provided that the shared temporary store is not empty. You must restart secondary nodes after setting this option or after adding a read-write file to the shared temporary store. If the shared temporary store contains no read-write file, or if you do not restart secondary nodes, data instead writes to IQ_SYSTEM_TEMP. When OFF, all temporary table data and scratch data writes to the local temporary store.