- Once the APs are identified, use a text editor to open the client hosts file and add or edit the AP entries. Use the following syntax when adding entries to the hosts file:
a.b.c.d dbcnameCOPn [aliasCOPn]
For example, a client computer accesses one database (named dbc) through two TCP/IP APs with addresses 18.104.22.168 and 22.214.171.124 on the same logical TCP/IP LAN. Each AP is assigned two alias names. The following lines show example entries in the hosts file for the two APs:
- The Internet address is a four-byte numeric value that identifies an AP and its location on the network. An Internet address is assigned to each AP when Vantage is configured.
- The database using the AP is 1 to 70 characters in length. The first character must be alphabetic; where the remaining characters can be alphanumeric. The System Parameter Block file, %Program Files%\Teradata\Client\version\clispb.dat, lists dbc as the default dbcname. dbc can be assigned as the dbcname of a database with which the client computer communicates. This simplifies network debugging and avoids problems when Name servers become available. If the client computer communicates with more than one database on the same TCP/IP LAN, use dbc as the dbcname for the more heavily used database. Any other names can be used for any remaining instances of Vantage.
- The parameter that assigns a number to a particular AP that Vantage uses. COP is a fixed string of characters that must always be specified. The value of n can range from 1 to the total number of "APs" in a COP group. A COP group is a set of "APs" that operate together for a particular database. "APs" in the same COP group share session balancing and session recovery. Each AP within a COP group must be assigned a unique number starting with 1.
- The alias name, specifies an alternate name for a database AP. Its use is optional. More than one aliasname is permitted. An aliasname need not be unique across a network, but the hosts file for a computer must not contain the same aliasname for more than one AP. Suggestion: the n in each alias COPn equals n in the corresponding dbcname COPn.
126.96.36.199 dbcnode1 dbccop1 tdcop1 188.8.131.52 dbcnode2 dbccop2 tdcop2