Configuring COP Entries
After folding or unfolding, COP entries must be updated on the client machines and client connections must be restarted. If this is not done, the system can become unbalanced and, under heavy data transfers between the client machines and the Teradata Database, severe AMP skew and poor performance may occur.
- Assign the COP entries on your client machine using entries from /etc/hosts file from any of the TPA node.
- Enter the following command to display the COP entries in the correct order for the system.Complete this step regardless of the Fold/Unfold setting.
# tdc-network-copentriesFollowing is an example of the output:
COP entries: 10.1.1.4 databasecop1 10.1.1.8 databasecop2 10.1.1.5 databasecop3 10.1.1.9 databasecop4 10.1.1.6 databasecop5 10.1.1.10databasecop6 10.1.1.7 databasecop7 10.1.1.11databasecop8The hosts file on all the TPA nodes is updated with the COP entries after a system is folded or unfolded.