Converts the query server on which it runs into the new write server for the multiplex. Must be called on the query server. Other steps are needed to move to a new write server. For details, see Chapter 5, “Working with Database Objects” in the Sybase IQ System Administration Guide.
call sp_iqmpxreplacewriteserver( ‘servername’ )
Drops and recreates main IQ Store definitions for the new write server to match those of the query server. Drops any IQ Temporary Store definitions for the former write server. Adjusts SYSIQFILE, IQ_MPX_STATUS, IQ_MPX_INFO, and SQL Remote configuration.
Column name |
Data type |
Description |
|---|---|---|
servername |
varchar(30) |
Name for the new write server. Must differ from each server name currently in the multiplex. |
Must run on query server.
Must have DBA authority.
