The common.IT.properties.json file defines the VMware vSphere configuration settings common across all Teradata Vantage on VMware deployments. Configure the settings in this file each time something in the virtual environment changes.
Property Category | Properties | Description |
---|---|---|
Teradata System Name | TDsystemname | The name of the Teradata System. The DBS name can be up to 15 alphanumeric characters, but cannot begin with a number. |
Domain Setting | domain |
The domain of the system being deployed which is placed into the /etc/hosts file. Example:
|
Public Virtual Switches | public_vswitch | The physical adapter with port
group for the virtual network. The default setting is VM Network. Example:
|
BYNET Virtual Switches |
byn_vswitch1 byn_vswitch2 |
The labels of the BYNET switches. The first is required in MPP systems. The second is for redundancy and performance in MPP systems. This setting is the name specified when you created the vSwitch in vSphere. The setting should be empty for single-node systems. |
CMIC Virtual Switches |
cmic_vswitch1 cmic_vswitch2 |
The labels of the server management switches. These are only used in MPP systems with server management. The second is for redundancy and performance in MPP systems. This setting is the name specified when you created the vSwitch in vSphere. |
DSC Virtual Switch | dsu_vswitch | The label of the DSC switch. This setting is the name specified when you created the vSwitch in vSphere. |
Public Submask Setting | public_submask | The public submask name in
dot-decimal notation. Example:
|
Gateway Setting | gateway | The gateway name or IP
address. Example:
|
Domain Name System Settings |
dns1 dns2 |
The DNS name or IP address. Examples:
|
External NTP Server Settings |
ntp1 ntp2 |
The host name or IP address
of the ntp1 server is required, however the ntp2 server is
optional. Examples:
You must configure the NTP servers if you plan to use the Temporal feature. |
Time Zone Setting | OSTimeZone | [Optional] The time zone of
the VM. Enter either a fixed time zone displacement from GMT or
the time zone file name. See the file LinuxTimeZoneStrings.txt for the valid settings
for OSTimeZone. If you are not enabling Temporal, the database time zone syncs with the operating system. The default time zone is US/Pacific. Examples:
For additional Teradata time zone information, see Temporal Time Zone Strings. |
PDisk Datastore Match Criteria | PDisk_Datastore_Match | Use this property to find the
database datastores to attach data disks. The default setting is
_data, which detects any
datastores that contain _data
in their name to be usable for database storage. Change this
setting to match your datastores. Ensure the value of PDisk Datastore Match
Criteria does not match the pattern of the
ESXI Datastore
property in the node.IT.properties.json properties file by
choosing different naming conventions for PDisk Datastore Match
Criteria and ESXI
Datastore.
Example: If you name the pdisk datastores LUN_01 and LUN_02, and the OS datastore LUN_OS, and enter LUN as the value of PDisk_Datastore_Match, the scripts cannot differentiate internally between the pdisk datastores and the OS datastore. To resolve this issue, rename the OS datastore so LUN is not in the name. |
Physical Disk Size | pdiskSizeGB | The size of the Vantage system pdisks. Example:
|
Physical Disk Settings | uniqueDisks | Knowledge of Vantage systems and vSphere storage set up is necessary to use this setting. Teradata recommends keeping the default setting to true. Do not change the default setting if you do not plan to use this feature. Change the setting to false if you want more than one Vantage system data disk to be placed into each Vantage datastore. The deployment executable file enumerates the datastores found on a given ESXi host using the PDisk_Datastore_Match expression. If set to false, the Advanced SQL Engine (TPA) nodes create pdisks without considering ownership when deploying on shared storage, SANs, or when there is not enough disks available. Database performance may be impacted. You can create as many Vantage system data disks of pdiskSizeGB that fit into the first one and then move to the next one. Example:
|
System Setting | PhysicalCoresPerTPA | Changes the number of physical cores assigned to each Advanced SQL Engine (TPA) VM. This does not affect the other node types. The total physical cores consumed by your Teradata entitlement (license) equals the PhysicalCoresPerTPA setting times the number of TPA nodes. |
Teradata Intelligent Memory (TIM) | Tim |
If you plan to use TIM, change the setting to TRUE. If you do not plan to use it, accept the default of FALSE. |
Temporal Settings |
Temporal TemporalDaylightSavings TemporalTimeDateWZControl TemporalTimeZoneHour TemporalTimeZoneMinute TemporalTimeZoneString |
If you plan to use Temporal, change the setting to true. If you do not plan to use it, accept the default of false. Refer to Temporal Settings. You must enable Temporal before deployment. If you did not enable it before deployment, you must redeploy the VM to enable it. If you do not want to redeploy the VM, contact your Teradata Sales representative to purchase a customer engagement. Example:
|
Other Teradata Database Feature Settings |
SecureZones RowLevelSecurity Columnar |
[Optional] Columnar, Row Level Security, and Secure Zones are Vantage features that can be enabled by setting them to true. If you do not plan to use a feature, accept the default of false. |
Site ID | SiteID | The site ID representing this system. This is optional. |
Mainframe Settings | MainframeLHID |
The logical host ID for mainframe connectivity. The default is -1 to indicate the deployed system does not connect to a mainframe. Example:
|
Folder Setting | Folder | Folder name where the VM is being deployed on the vSphere server. |
IP Address Setting | IPAddressSetting | Indicates whether to use a static or dynamic IP address. For a two node MPP deployment, the IP address must be static. |
License Settings | Tier |
Vantage license tier that matches the software package you ordered.
|
EntitlementID | Unique string of characters that enable you to use the licensed software. Obtain the EID from the email you received when you purchased the license. |
|
LicensePeriodInYears | Duration of license period,
in years.
Obtain this integer from the email you received when you purchased the license. The license period is visible as a suffix to the name in the Product column after you log in to the Teradata EMS server. |
|
TeradataEmsURL | URL used to verify Vantage license, assuming you are deploying on a system with Internet access. The default is https://slem.teradata.com/ems. Change this setting only if your site uses a proxy server. |