The common.IT.properties.json file | Teradata VantageCore VMware - The common.IT.properties.json File - Teradata VantageCore VMware

Teradata® VantageCore VMware - Base, Advanced, Enterprise Tiers Getting Started Guide

Deployment
VantageCore
Edition
VMware
Product
Teradata VantageCore VMware
Release Number
Deployer 4.0
Published
October 2023
Language
English (United States)
Last Update
2023-10-31
dita:mapPath
gwx1617319441704.ditamap
dita:ditavalPath
nxb1617391283297.ditaval
dita:id
hrd1467245928404
Product Category
Cloud

The common.IT.properties.json file defines the VMware vSphere configuration settings common across all VantageCore VMware deployments. Configure the settings in this file initially, and verify or reconfigure each time something in the virtual environment changes.

Unless otherwise indicated, all property settings are required.

Property Category Properties Description
Teradata System Name TDsystemname Up to 15 alphanumeric characters, but cannot begin with a number. The system name is visible in Viewpoint.
Domain Setting domain The domain of the system being deployed which is placed into the /etc/hosts file.
Example:
  • domain:corp.company.com
Public (Customer) Port Groups public_vswitch The physical adapter with port group for the virtual network. The default setting is VM Network. This label is the name specified when you created the port group on the vSwitch.
Example:
  • public_vswitch:VM Network
BYNET Port Groups
  • byn_vswitch1
  • byn_vswitch2
BYNET port group labels. BYNET is required in MPP systems. The first port group is required in MPP systems. The second is for redundancy and performance in MPP systems. This label is the name specified when you create the port group on vSwitch in vSphere. The field must be empty for single-node/SMP systems.
CMIC Port Groups cmic_vswitch1

cmic_vswitch2

The labels of the Server Management (CMIC) port groups. The first is the primary connection to the CMIC. The second is for redundancy. This label is the name specified when you created the port group on the vSwitch.
DSC Port Group dsu_vswitch The label of the DSC switch. This label is the name specified when you created the port group on the vSwitch.
Public (Customer) Submask Setting public_submask The public submask name in dot-decimal notation.
Example:
  • public_submask:192.168.253.0
Public (Customer) Gateway Setting gateway The gateway name or IP address.
Example:
  • gateway:10.26.23.254
Domain Name System Settings

dns1

dns2

The DNS name or IP address.
Examples:
  • dns1:192.168.0.256
  • [Optional] dns2:192.168.1.256
External NTP Server Settings

ntp1

ntp2

The host name or IP address of the ntp1 server is required; the ntp2 server is optional.
Examples:
  • ntp1:time00.company.com
  • [Optional]ntp2:time01.company.com

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 Temporal is enabled and OSTimeZone is not enabled, then OSTimeZone will be automatically set to match the database time zone.

If you are not enabling Temporal, the database time zone syncs with the operating system.

The default time zone is US/Pacific.

Examples:
  • OSTimeZone=GMT+11
  • OSTimeZone=US/Eastern
PDisk Datastore Match Criteria PDisk_Datastore_Match Use this property to find the database datastores to attach data disks (pdisks). 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.
Make sure the value of PDisk (TPA) Datastore Match Criteria does not match the pattern of the OS Datastore property in the node.IT.properties.json properties file by choosing different naming conventions for PDisk Datastore Match Criteria and OS 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.

Storage Type StorageType The storage type for the deployment.
Example:
  • StorageType:standard

Standard means single node cliques.

Physical Disk Settings Total_Database_SizeGB The size of the Vantage system pdisks.
Example:
  • Total_Database_SizeGB:800
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 PowerShell script enumerates the datastores found on a given ESXi host using the PDisk_Datastore_Match expression. If set to false, the Analytics Database (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:
  • If each of the enumerated datastores were 900 GB and the pdiskSizeGB was set to 300 GB, then during deployment three Vantage system data disks would be placed in each datastore until each vNode has three Vantage system data disks.
System Setting PhysicalCoresPerTPA Changes the number of physical cores assigned to each Analytics Database (TPA) VM. This does not affect the other node types.
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. See Temporal Settings.
Temporal can be set either during deployment, or after deployment with Customer Service support. Additional charges will apply; please contact your Teradata Sales team.
Example:
  • Temporal:false
  • TemporalDaylightSavings:false
  • TemporalTimeDateWZControl:0
  • TemporalTimeZoneHour:0
  • TemporalTimeZoneMinute:0
  • TemporalTimeZoneString:America Pacific
Other Vantage Feature Settings
  • Columnar
  • RowLevelSecurity
  • SecureZones
[Optional] Columnar, Row Level Security, and Secure Zones are Vantage features that can be enabled by setting the field values to true. If you do not plan to use a feature, accept the default value of false.
Site ID SiteID The site ID representing this system.
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:
  • MainframeLHID:-1
Public (Customer) SSH Key PublicSshKey [Optional] Use this property to pass your public SSH key to a Vantage system.

The key you provide will be added to the authorized keys file on every database node, except CMIC, and can be used for passwordless SSH.

Use the full path. For example:

PublicSshKey: /path_to_the_key/public_key_name.pub

Folder Setting Folder [Optional] 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.
Host-Based Authentication (HBA) enableHBA

[Optional] Authenticates each node participating in internode communication and makes sure that data exchange/communication between the nodes is secure.

HBA is not in the common.IT.property.json file by default. It can be added by entering the variable, and then enabled by setting it to TRUE.

License Settings Tier Database license tier that matches the software package you ordered.
  • ET - Enterprise tier (default)
  • AT - Advanced tier
  • BT - Base tier

Obtain this value from the email you received when you purchased the license.