Manually synchronize the secondary nodes

To start the secondary nodes, you first need to install Sybase IQ 15.1 and then synchronize from the coordinator node. When you migrate a query node, it will become a reader node.

1. Back up the query node files. It is recommended that you at least back up existing catalog .db, catalog .log and iqmsg files.

   For example:

   rename /sunx5prod/users/work/iq-127/mpx/q1/q1.db 
   /sunx5prod/users/work/iq-127/mpx/q1/q1.db.before_schema_reload
   rename /sunx5prod/users/work/iq-127/mpx/q1/q1.log /sunx5prod/users/work/iq-127/mpx/q1/q1.log.before_schema_reload
   rename /sunx5prod/users/work/iq-127/mpx/q1/q1.iqmsg
   /sunx5prod/users/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=/sunx5prod/users/
   work/iq-127/mpx/main/main.db"
   /sunx5prod/users/work/iq-127/mpx/q1
   

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

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

   Step 2 synchronized 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/stop administration scripts on the secondary nodes to use the new name.

   To retain the same catalog database file names:

   1. Rename the synchronized coordinator catalog database file name. Assuming the coordinator file was called main.db and the secondary server was called q1.db

      For example:

      mv main.db q1.db
      

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

   (Your shell may differ.)

   start_iq @params.cfg -n mpx_q1 -x
   'tcpip{port=62632}' -o /worksrver/work/
   iq-127/mpx/q1/o.out -Z -zr all -zo /worksrver/
   iq-127/mpx/q1/zo.out /workserver/work/
   iq-127/mpx/q1/main.db
   

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

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