Shared temporary stores communicate and store temporary on-disk structures for distributed query processing.
The shared temporary store is a dbspace that is automatically created when you create a new database. You can create shared temporary stores in databases created in versions earlier than 15.3 by upgrading them.
By default, a shared temporary store has no storage. To enable distributed processing, allocate shared storage for the shared temporary store.
If any of the shared temporary dbspace files cannot be opened, the node starts normally but declares the dbspace dynamically offline. The affected node runs normally but cannot distribute queries or participate in distributed queries.
All multiplex nodes still require local temporary storage. Temporary tables cannot be stored or shared in the shared temporary store. Local and shared temporary stores share the existing temporary buffer caches.
See these topics in the Sybase IQ documentation:
- Reference: Statements and Options > SQL Statements > ALTER DBSPACE
- System Administration Guide: Volume 1 > Database Object Management > Setting up a Sybase IQ Database > Space Allocation > Types of Dbspaces
- System Administration Guide: Volume 1 > Database Object Management > Data Storage > Read-only and Read-write Dbspaces and Files > Allowed Dbspace Transformations
- Using Sybase IQ Multiplex > Distributed Query Processing
- Using Sybase IQ Multiplex > Multiplex Transactions > DDL Commands > Dbspace Updates in Multiplex > Updates on IQ_SHARED_TEMP
- Using Sybase IQ Multiplex > Multiplex Transactions > DDL Commands > Dbspace Updates in Multiplex > Updates on IQ_SHARED_TEMP > Adding Dbfiles to Shared Dbspaces
- Using Sybase IQ Multiplex > Multiplex Transactions > DDL Commands > Dbspace Updates in Multiplex > Updates on IQ_SHARED_TEMP > Shared File Status Data
- Using Sybase IQ Multiplex > Multiplex Reference> System Procedures > sp_iqmpxfilestatus Procedure
- Using Sybase IQ Multiplex > Multiplex Reference> System Procedures > sp_iqsharedtempdistrib Procedure