To clean the internal state information, start the write server in single-node mode.
-gm 1 -iqmpx_sn 1
If you use administrative startup scripts, create a copy of the start_server.sh script to start the write server you want to migrate. For example, copy the existing file start_server.sh to a new file called start_server_single_node.sh.
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.sh:
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.sh.
Shut down the writer node.
Start the writer node with start_server.sh.
Shut down the writer node.
Shut down the SAP Sybase IQ 12.7 server.