To ensure a smooth multiplex migration, start the write server in single node mode to clean internal state information. To do this, start the writer node in single node mode, shutdown, start again normally, and shut down.
-gm 1 -iqmpx_sn 1
If you use administrative startup scripts, create a copy of the start_server.bat script to start the write server you want to migrate.
start_asiq -STARTDIR d:\work\iq-127\mpx\main @d:\work\iq-127\mpx\main\params.cfg -n mpx_main -gm 1 -iqmpx_sn 1 %readonly% %nomain% -x tcpip{port=62631} d:\work\iq-127\mpx\main\main.db %dbkey%There are now two .bat files, start_server.bat and start_server_single_node.bat that you will use to put the server into a good state for migration:
Start the writer node with start_server_single_node.bat.
Shutdown the writer node.
Start the writer node with start_server.bat.
Shut down the writer node.
Shut down the Sybase IQ 12.7/12.6 server.