Generate a db file from the coordinator’s catalog store and copy it to the newly created reader server’s directory, then start the new server.
Alternatively, you can do this in Sybase Central by right-clicking the multiplex server icon and selecting Control | Synchronize.
Manually starting the multiplex server
If it has not been created already, create the multiplex server directory. Following the convention of this demo, the multiplex directory is:
On UNIX – /myiqdemo/r2
On Windows – C:\myiqdemo
Change to the newly created multiplex server directory:
On UNIX – cd /myiqdemo/r2
On Windows – cd C:\myiqdemo
If it does not exist, copy the params.cfg from the coordinator directory to the reader’s directory.
If a previous transaction log file exists in the directory (for example, mpx.log), remove it. Leaving old transaction logs in a multiplex server directory after synchronizing may stop the server from starting.
From the command line, run the following commands, substituting the appropriate path name, host name, and server name for the new multiplex server:
On UNIX –
dbbackup -y -d -c ‘uid=DBA;pwd=sql;eng=SUN62574_iqdemo;links="tcpip{host=SUN62574;port=2638}"’ .
rm –rf "iqdemo.log"
dblog -r -t "iqdemo.log" "iqdemo.db"
start_iq @params.cfg -n SUN62574_iqdemo_r2 -x "tcpip{host=SUN62574;port=2640}" iqdemo.db
On Windows –
dbbackup -y -d -c "uid=DBA;pwd=sql;eng=PC62573_iqdemo;links=tcpip{host=PC62573;port=2638}" .
erase /F /Q "iqdemo.log"
dblog -r -t "iqdemo.log" "iqdemo.db"
start_iq @params.cfg -n PC62573_iqdemo_r2 -x "tcpip{host=PC62573;port=2640}" iqdemo.db
Generally, you would use ODBC DSN for dbbackup, and edit the configuration file, add the links information, and the server name in the configuration file to start the server.
Confirm that the server is running by connecting to it using Interactive SQL.
