Start the Multiplex Write Server

To clean the internal state information, start the write server in single-node mode.

Note: You must specify your login and password as arguments to the start_server script.

Start the writer node with the server arguments -gm 1 and -iqmpx_sn 1:

-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.

Add the two single-node startup arguments to change the preceding command as follows in start_server_single_node.bat:

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.
Shut down the writer node.
Start the writer node with start_server.bat.
Shut down the writer node.
Shut down the SAP Sybase IQ 12.7/12.6 server.