Creates a temporary file in place of the defined temporary dbspace.
-iqnotemp size
size is file size, in MB. This parameter causes the server to ignore all SAP Sybase IQ temporary dbfile definitions when starting a database. You can use -iqnotemp to solve temporary dbfile problems by dropping damaged files and replacing them later.
If you start the utility database server with -iqnotemp when restoring, SAP Sybase IQ ignores all temporary file definitions in the backed up database during the restore operation, including intermediate starts. You can thus restore a database to a different temporary file topology without recreating and using old temporary file definitions.
The only temporary file operation allowed on a database started with -iqnotemp is ALTER DBSPACE IQ_SYSTEM_TEMP DROP FILE.