To start a former coodinator, synchronize it against the new
coordinator.
Prerequisites
Perform the following steps on the computer where the former coordinator runs.
Task- Remove the .LOG transaction log file in the
former coordinator directory.
- Back up the catalog store to the directory where the former coordinator runs.
Specify the new coordinator's connection parameters in the -c string:
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 former coordinator using the start_iq command.