The IQ temporary store is used for both loading data and for queries.
It is the work area for the database. It is used to build or modify HG and optimized FP indexes during loads and deletes on columns with those indexes. It is also used to sort data during order by queries, some group by operations and some table join processing.
The physical file name of the IQ temporary store is dbname.iqtmp (for file system devices). There is one IQ temporary store per database.
The IQ temporary store is initialized at the time the IQ database is created and has the logical name IQ_SYSTEM_TEMP. It contains the IQ_SYSTEM_TEMP dbspace, which can consist of several physical files. These files can be raw or file system. If a raw partition, the physical name will be the partition name. If a file system, it should have the .iqtmp file extension.