Restoring Multiplex Stores to the Same Location

Restore operations vary depending on where you are restoring the data.

1. Confirm that database home directories for each server still exist. If they do not, create them or restore them from file system backups.
2. Shut down every server in the multiplex (coordinator and all secondary servers).
   Note: If automatic startup is enabled in your ODBC configuration, users on the same machine as the server may be set up to start the server automatically. Prevent this from happening while you are restoring the database.
3. Confirm that the database shut down successfully:

   Platform	Actions
   UNIX	% ps -ef | grep iqsrv16 If you see an active iqsrv16 process with name of a multiplex, stop the process.
   Windows	IIn Task Manager, check the Processes tab for iqsrv16.exe, or find the IQ Server icon in the system tray and select Shutdown.

4. Move files required for debugging and reconfiguring the multiplex.
   • Make a file system copy of the .iqmsg file. If you have message log archiving configured, see Back Up the Right Files.
   • On each server, preserve any files that were added to IQ_SYSTEM_TEMP for that server. These files are of the form dbname.iqtmp if you used an operating system file, or they may be raw devices. If the IQ temporary store is damaged, start the server with the -iqnotemp switch to drop and re-create the temporary store dbspaces. For more information, see the Release Bulletin.

     Either drop the database, or delete the following files from the coordinator:

     <database_home>/<dbname>.db

     <database_home>/<dbname>.log

     If a query server is damaged, however, drop it and re-create it after RESTORE. Then follow the instructions in Restoring Multiplex Stores to a Different Location.

   • If you have cache dbpaces on secondary nodes, preserve all cache dbspace files on those nodes. See Restoring Cache Dbspace Restore.
5. Start the utility database from the coordinator server directory. Use any valid identifier as the server name except the name of a registered secondary server. If you use the coordinator name, rename the coordinator after the restore.

   % start_iq -n utility_startup_svr -c 32m 
   -x 'tcpip{port=1234}' 

6. Connect to the utility database (utility_db):

   % dbisql -c "eng=utility_startup_svr;uid=DBA;pwd=SQL;
   dbn=utility_db"

7. Run the RESTORE command. To restore certain dbspace files to a different path, specify a RENAME clause. For details, see RESTORE Statement in Reference: Statements and Options.
8. Shut down the utility database.
9. Make sure that the temporary dbspaces exist as before, on raw devices or as files of the correct length. For information about starting the server without using the IQ temporary store, see the Release Bulletin for your platform.
10. Start the coordinator server and, if restoring to the same location, synchronize the secondary servers.
11. Start the secondary servers.