Replacing Dbfiles in IQ_SYSTEM_TEMP on a Coordinator

To replace a damaged dbfile, drop the file, restart the server, and add the dbfile in the coordinator.

1. Use the -iqnotemp parameter to start the database.
   The only temporary file operation allowed on a database while running with -iqnotemp is to drop one or more of the temporary file definitions.
2. Drop the last file in IQ_SYSTEM_TEMP:

   ALTER DBSPACE IQ_SYSTEM_TEMP DROP FILE filename

3. Stop the database.
4. Start the database in single-node mode with no files to empty the checkpoint log:

   start_iq @params.cfg mpxtest.db -iqmpx_ov 1
   -iqmpx_sn 1 -n mpxnode_c

5. Add a “dummy” dbfile to the coordinator. You will need to drop this file and add it again in coordinator mode, because files added in single-node mode have a null server ID; they are owned by the coordinator instead of the server that added the file. To add more space to IQ_SYSTEM_MAIN with a new file on a raw device, use syntax like the following:

   Platform	Syntax
   UNIX	ALTER DBSPACE IQ_SYSTEM_TEMP ADD FILE tempfile '/dev/rdsk/c4t600A0B80005A7F5D0000024' where tempfile is the logical or chosen logical name of the new dbfile.
   Windows	ALTER DBSPACE IQ_SYSTEM_TEMP ADD FILE tempfile '\\.\PhysicalDrive3'

6. Stop and restart the server.
7. Drop the dummy file.