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.
sp_iqmpxreplacewriteserver( IN l_new_server_name VARCHAR(30))
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 |
Description |
|---|---|
l_new_server_name |
Name for the new write server. Must differ from each server name currently in the multiplex. |
