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.

  1. Assign the COP entries on your client machine using entries from /etc/hosts file from any of the TPA node.
  2. 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-copentries
    Following 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.11databasecop8
    The hosts file on all the TPA nodes is updated with the COP entries after a system is folded or unfolded.

results matching ""

    No results matching ""