Server option -iqnotemp [CR #633738]

The -iqnotemp server option was updated in Utility Guide > Running the Database Server > Starting the database server > Table 1-1. The Description now contains the following:

Creates a temporary file in place of the defined temporary dbspace. size is file size in MB. This parameter causes the server to ignore all temporary IQ 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, Sybase IQ ignores all temporary IQ 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 filename.