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

Suppose that start_server.sh contains this startup command:

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
$dbkey

Add 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

There are now two script files, start_server.sh and start_server_single_node.sh to make the server ready for migration:

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.