Manually Synchronize the Secondary Nodes

To start the secondary nodes, install SAP Sybase IQ 16.0, then synchronize from the coordinator node. When you migrate a query node, it becomes a reader node.

1. Back up the query node files. Back up existing catalog .db, catalog .log and iqmsg files.
   For example:

   rename d:\work\iq-127\mpx\q1\q1.db d:\work\iq-127\mpx\q1\q1.db.before_schema_reload
   rename d:\work\iq-127\mpx\q1\q1.log d:\work\iq-127\mpx\q1\q1.log.before_schema_reloadrename d:\work\iq-127\mpx\q1\q1.iqmsg d:\work\iq-127\mpx\q1\q1.iqmsg.before_schema_reload

2. Issue a dbbackup command to synchronize servers. You might have a different name for the query node's catalog file, depending on your configuration. In the following example, q1.db is the catalog file name on the query node:

   dbbackup -y -x -c "uid=dba;pwd=sql;eng=mpx_main;dbf=d:\\work\\iq-127\\mpx\\main\\main.db" d:\work\iq-127\mpx\q1

   SQL Anywhere Backup Utility Version 11.0.0.5020 Debug(702 of 699 pages, 100% complete)Transaction log truncatedDatabase backup completed

3. If your query nodes do not use a different catalog database name, skip to step 4.

   Step 2 synchronizes the catalog database file from the coordinator. If you prefer to use the same catalog database file name as the coordinator, adjust any server start and stop administration scripts on the secondary nodes to use the new name.

   To retain the same catalog database file names:

   • Rename the synchronized coordinator catalog database file name. For example, assuming the coordinator file was called main.db and the secondary server was called q1.db, enter:

     mv main.db q1.db

     rename main.db q1.db

   • Rename the log file for the query node. This is necessary as the file renamed above still contains an internal pointer to main.log:

     dblog -t q1.log q1.db

4. Start the secondary server in normal mode:

   start_iq.exe @params.cfg -n mpx_q1 -x tcpip{port=62632} -o d:\work\iq-127\mpx\q1\o.out -Z -zr all -zo d:\work\iq-127\mpx\q1\zo.out D:\work\iq-127\mpx\q1\main.db

   The above command line is derived from your existing query server start_server administration script.

5. Repeat these steps on the remaining secondary nodes that you want to migrate.