To use the Temporal option with Vantage on VMware, make sure you configure your system carefully to avoid issues with your data. For more information, see https://www.teradata.com/Resources/White-Papers and search for Enabling the Temporal Data Warehouse.
After you enable the Temporal option, you cannot turn it off, so learn about this option before you enable it. For more information, see Teradata Vantage™ - Temporal Table Support, B035-1182 and Teradata Vantage™ - ANSI Temporal Table Support, B035-1186.
To enable the Temporal option for a virtual machine, set the Temporal property value in the common.IT.properties.json file to true, and then configure the other related properties based on your preferred time options and whether you plan to restore data from another Teradata system.
Contact your Vantage Administrator for the DBSControl Flag values for the time zone variables.
To use the Temporal option, you must configure the NTP servers in the common.IT.properties.json file.
To determine your settings in the properties file, use the following diagram and table. If you do not know your TimeZoneString, see Teradata Vantage™ - Database Administration, B035-1093.
The following information is important when enabling this feature:
Temporal table support and Time Date with Zone Control by Database (TimeDateWZControl) are two different features. However, when enabling Temporal table support, Time Date with Zone Control by Database must also be enabled.
If DaylightSavings is true, you must include a TimeZoneString.
In the settings below, TimeZoneHour = 5 and TimeZoneMinute = 30 are examples. Enter the number of hours and minutes your installation is offset from GMT.