- For each node, edit the RSG configuration file, tdconfig_directory/rsg/rsg.cfg, to
indicate where the DDL Gateway is installed and which node is the RSG master
node:
MDSGWYNODE=name_of_MDS_Gateway_node RSGMASTERNODE=name_of_RSG_master_node DEBUGTRACE=ON|OFF|REPLACE
REPLACE causes the old RSG log file to be deleted and a new log file to be created at the next TPA reset.
If the MDSGWYNODE or the RSGMASTERNODE value is NULL, RSG keeps trying to read the RSG configuration file, sleeping between tries.
- If the tdinfo utility indicates that the RSG vproc is not online, run the
vprocmanager utility to set it offline and then online as follows:
set xxxx offline
set xxxx online
where xxxx is the vproc ID.
Repeat these steps for each RSG vproc.
The vprocmanager utility cannot be used to set the state for Hot Standby Nodes. - Run the dbscontrol utility and turn on the MDS is Enabled flag:
modify general 38=TRUE
write
quit
- Restart the Teradata Database.