Synchronizing copies the coordinator's version of the database
catalog to secondary servers.
Prerequisites
Log in as a user with the BACKUP DATABASE privilege and perform the following
steps on the computer where the secondary server runs.
Task- Remove the .LOG transaction
log file in the secondary server directory.
- Back up the catalog store to the directory where the
secondary server runs:
dbbackup -y -d -c "uid=dba;pwd=sql;links=tcpip{port=2763};eng=mpxnode_c" /host1/mpx/
- Set the log file path:
dblog -r -t mpxtest.log mpxtest.db
- Start the secondary node using the start_iq command.
- Repeat the previous steps for each secondary server
in the multiplex.