17.10 - Finding Directories that Serve a Site - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)
  1. After you choose a site, you can search the DNS SRV RRs to find all the local directories that serve the site:
    _ldap._tcp. site ._sites. domain
    site
    The name of a site identified in Locating the Site Objects in a Domain.
    domain
    The name of the DNS domain that contains the site.
  2. Convert the site name into DNS SRV RR format. For example, you can convert CN=SanDiegoHQ,CN=Sites,CN=Configuration,DC=DOMAIN1,DC=COM into a DNS SRV RR format, _ldap._tcp.SanDiegoHQ._sites.DOMAIN1.com.
  3. Use the Linux dig utility to search the DNS for directories that serve the site:
    dig +tcp -t SRV _ldap._tcp.SanDiegoHQ._sites.DOMAIN1.com

    The dig command produces output similar to:

    <<>> DiG 9.2.4 <<>> +tcp -t SRV _ldap._tcp.SanDiegoHQ._sites.domain1.com;
    ;; global options:  printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 49397
    ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 5, ADDITIONAL: 8
    
    ;; QUESTION SECTION:
    ;_ldap._tcp.SanDiegoHQ._sites.domain1.com. IN        SRV
    
    ;; ANSWER SECTION:
    _ldap._tcp.SanDiegoHQ._sites.domain1.com. 86400 IN SRV 0 100 389 sdhq7602.DOMAIN1.COM.
    _ldap._tcp.SanDiegoHQ._sites.domain1.com. 86400 IN SRV 0 100 389 sdhq7603.DOMAIN1.COM.
    
    ;; AUTHORITY SECTION:
    _sites.domain1.com. 86400   IN      NS      sdint7857.DOMAIN1.COM.
    _sites.domain1.com. 86400   IN      NS      socal7210.DOMAIN1.COM.
    _sites.domain1.com. 86400   IN      NS      socal7211.DOMAIN1.COM.
    _sites.domain1.com. 86400   IN      NS      socal7212.DOMAIN1.COM.
    _sites.domain1.com. 86400   IN      NS      sdhq7562.DOMAIN1.COM.
    
    ;; ADDITIONAL SECTION:
    sdhq7544.DOMAIN1.COM. 1800    IN      A       141.206.23.0
    sdhq7602.DOMAIN1.COM. 1800    IN      A       141.206.48.0
    sdhq7603.DOMAIN1.COM. 1800    IN      A       141.206.66.0
    socal7210.DOMAIN1.COM. 1800   IN      A       141.85.51.0
    socal7211.DOMAIN1.COM. 1800   IN      A       141.85.130.0
    socal7212.DOMAIN1.COM. 1800   IN      A       141.85.16.0
    sdhq7562.DOMAIN1.COM. 1800    IN      A       141.85.77.0
    sdint7857.DOMAIN1.COM. 1800   IN      A       141.29.162.0
    
    ;; Query time: 11 msec
    ;; SERVER: ip_address8#53(ip_address8)
    ;; WHEN: Wed Dec 16 14:19:06 2009
    ;; MSG SIZE  rcvd: 397

    where the ANSWER SECTION lists the two directories that serve the SanDiegoHQ site.

  4. Do one of the following:
    • If the ANSWER SECTION for the output lists one or more directories, go on to Configuring Site-Aware SRV Resource Records in TDGSS, and use the DNS SRV RR formatted site name you used earlier in this procedure.
    • If the ANSWER SECTION for the output of your dig command does not list one or more directories, redo the first two steps.