Multiplex Migration

Migrate multiplex databases, performing all steps in sequence.

1. Synchronizing the Multiplex Nodes
   Check the SQL Remote and multiplex server log files for synchronization problems.
2. Migrate Local Stores
   To move the 12.7 local stores before migration, use iqlsunload.
3. Start the Multiplex Write Server
   To clean the internal state information, start the write server in single-node mode.
4. Multiplex Migration Parameters
   To migrate the multiplex, run iqunload with the appropriate parameters.
5. Verifying the Migrated Multiplex Database
   Verify the migrated database in read-only mode and correct any errors.
6. Starting the Coordinator
   Starting the multiplex coordinator in single-node mode (-iqmpx_sn) and read-only (-iqro) performs some initial database checks. For coordinators, the server must reset an identity cookie before you can use the multiplex.
7. Manually Synchronize the Secondary Nodes
   To start the secondary nodes, install SAP Sybase IQ 16.0, then synchronize from the coordinator node. When you migrate a query node, it becomes a reader node.
8. Start the Secondary Nodes
   To start the secondary nodes, all nodes of the multiplex must be running.
9. Set the Failover Node
   After you migrate the multiplex data, connect to the coordinator, and set the failover node.
10. Troubleshooting Multiplex Migration
    If you cannot migrate your multiplex database, try this alternate method.