Restoring to a New Temporary File Topology

If temporary dbfiles cannot be opened or are damaged, you can restore the database to a different temporary file topology.

1. Start the utility server in such a way that it ignores all temporary IQ file definitions in the backed up database during the restore:

   start_iq -n utility_startup_svr -c 32MB 
   -x tcpip(port=1234) -iqnotemp 

2. Restore the database:

   RESTORE DATABASE 'iqdemo'
   FROM '/system1/IQ15/IQ-15_4/demo/backup/iqmain'
   

3. Restart the restored database using the -iqnotemp flag:
4. Drop all the files in IQ_SYSTEM_TEMP:

   ALTER DBSPACE IQ_SYSTEM_TEMP DROP FILE ALL

5. Restart the server without the -iqnotemp flag:
6. Add new temporary dbfiles to IQ_SYSTEM_TEMP: