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 script to start the write server you want to migrate. For example, copy the existing file start_server to a new file called start_server_single_node.
start_asiq -STARTDIR /work/iq-127/mpx/main @/work/iq- 127/mpx/main/params.cfg -n mpx_main $readonly $nomain - x tcpip{port=62631} /work/iq-127/mpx/main/main.db $dbkeyAdd the two single node startup arguments to change the preceding command as follows in start_server_single_node:
start_asiq -STARTDIR /work/iq-127/mpx/main @/work/iq- 127/mpx/main/params.cfg -n mpx_main -gm 1 -iqmpx_sn 1 $readonly $nomain -x tcpip{port=62631} /work/iq-127/ mpx/main/main.db $dbkey
Start the writer node with start_server_single_node.
Shutdown the writer node.
Start the writer node with start_server.
Shut down the writer node.
Shut down the Sybase IQ 12.7/12.6 server.