IQ Shared Temporary Store (for temporary data in a multiplex)

The IQ shared temporary store is required for distributed query processing (DQP).

The IQ shared temporary store contains temporary structures shared among nodes for DQP, and may also contain temporary user objects or local nonversioning temporary objects.

When you create a database, SAP Sybase IQ creates a single dbspace for the IQ shared temporary store, IQ_SHARED_TEMP. Initially, this dbspace contains no files. Before you can use DQP, you must add one or more files.

A multiplex configuration with shared temporary storage can use the IQ_SHARED_TEMP dbspace as a shared system temporary store to simplify multiplex configuration, improve performance and support DQP.