Choosing a Site - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

Choose a site that contains the database or Unity server you are configuring, and verify that the site has one or more GC directories.

  1. Choose a site that contains the Teradata Vantage system you are configuring.
  2. Run the following commands to identify the GC servers for the site.
    dig +tcp -t SRV _ldap._tcp.site_name._sites.gc._msdcs.rootdomain.com

    where:

    Option Description
    site_name The name of a site that appears on the list of sites generated in step 2 of Finding the Available Sites in the Forest, and that is the location of the Teradata Vantage system you are configuring.
    rootdomain The name of the super-domain for the GC found in Finding the Root Domain Name.

    The dig command returns output similar to:

    ; <<>> DiG 9.2.4 <<>> +tcp -t SRV _ldap._tcp.SanDiegoHQ._sites.gc._msdcs.rootdomain.com
    ;; global options:  printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 2228
    ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 3, AUTHORITY: 5, ADDITIONAL: 9
    
    ;; QUESTION SECTION:
    ;_ldap._tcp.SanDiegoHQ._sites.gc._msdcs.rootdomain.com. IN SRV
    
    ;; ANSWER SECTION:
    _ldap._tcp.SanDiegoHQ._sites.gc._msdcs.rootdomain.com. 600 IN SRV 0 100 3268 susday7542.ROOTDOMAIN.COM.
    _ldap._tcp.SanDiegoHQ._sites.gc._msdcs.rootdomain.com. 600 IN SRV 0 100 3268 sdhq7544.DOMAIN1.COM.
    _ldap._tcp.SanDiegoHQ._sites.gc._msdcs.rootdomain.com. 600 IN SRV 0 100 3268 sdhq7603.DOMAIN1.COM.
    
    ;; AUTHORITY SECTION:
    _msdcs.rootdomain.com.    86400   IN      NS      socal7210.DOMAIN1.COM.
    _msdcs.rootdomain.com.    86400   IN      NS      socal7211.DOMAIN1.COM.
    _msdcs.rootdomain.com.    86400   IN      NS      socal7212.DOMAIN1.COM.
    _msdcs.rootdomain.com.    86400   IN      NS       sdhq7562.DOMAIN1.COM.
    _msdcs.rootdomain.com.    86400   IN      NS      sdint7857.DOMAIN1.COM.
    
    ;; ADDITIONAL SECTION:
    sdhq7544.TD.TERADATA.COM.   1800 IN     A       141.206.23.0
    sdhq7602.TD.TERADATA.COM.   1800 IN     A       141.206.48.0
    sdhq7603.TD.TERADATA.COM.   1800 IN     A       141.206.66.0
    socal7210.TD.TERADATA.COM.  1800 IN     A       141.85.51.0
    ssocal7211.TD.TERADATA.COM. 1800 IN     A       141.85.130.0
    socal7212.TD.TERADATA.COM.  1800 IN     A       141.85.16.0
    sdhq7562.TD.TERADATA.COM.   1800 IN     A       141.85.77.0
    sdint7857.TD.TERADATA.COM.  1800 IN     A       141.29.162.0
    
    ;; Query time: 16 msec
    ;; SERVER: ip_address8#53(ip_address8)
    ;; WHEN: Wed Dec 16 17:17:50 2009
    ;; MSG SIZE  rcvd: 46

    where the ANSWER SECTION lists the GC servers for the site.

  3. If the ANSWER SECTION contains one or more entries, copy the SRV RR service name for the GC from the QUESTION SECTION, for example, _ldap._tcp.DaytonSDC._sites.gc._msdcs.teradata.com, to use in Configuring TDGSS.