Temporal Settings | Teradata VantageCore VMware - Temporal Settings

To use the Temporal option with VantageCore 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 shown in the following table, TimeZoneHour = 5 and TimeZoneMinute = 30 are examples. Enter the number of hours and minutes offset from GMT.
See Temporal Time Zone Strings for the valid values for TimeZoneString.
In the table settings shown in the following table, TimeZoneString = America Pacific is an example. Enter the time zone for your system.
In diagram scenario 5, you must copy the time zone settings from the DBSControl General Flags of the Vantage system from which you are restoring data.

Scenario 5 reflects six possible variations, described in this table as 5a, 5b, 5c, 5d, 5e, and 5f.

Diagram Scenario	Temporal Settings in the Properties File	DBS Control Setting Applied As
1	Temporal:false TimeDateWZControl:0 (Disabled) DaylightSavings:false TimeZoneHour:0 TimeZoneMinute:0 TimeZoneString:Not Set	16. System TimeZone Hour:0 17. System TimeZone Minute:0 18. System TimeZone String:Not Set 57. TimeDateWZControl:0 (Disabled)
2	Temporal:true TimeDateWZControl:3 (Local) DaylightSavings:false TimeZoneHour:0 TimeZoneMinute:0 TimeZoneString:Not Set	16. System TimeZone Hour:0 17. System TimeZone Minute:0 18. System TimeZone String:Not Set 57. TimeDateWZControl:3 (Local)
3	Temporal:true TimeDateWZControl:3 (Local) DaylightSavings:false TimeZoneHour:5 (Example) TimeZoneMinute:30 (Example) TimeZoneString:Not Set	16. System TimeZone Hour:5 (Example) 17. System TimeZone Minute:0 18. System TimeZone String:Not Set 57. TimeDateWZControl:3 (Local)
4	Temporal:true TimeDateWZControl:3 (Local) DaylightSavings:true TimeZoneHour:0 TimeZoneMinute:0 TimeZoneString:America Pacific (Example)	16. System TimeZone Hour:0 17. System TimeZone Minute:0 18. System TimeZone String:America Pacific (Example) 57. TimeDateWZControl:3 (Local)
5a	Temporal data is stored in the file system in system local time. Daylight savings is observed. Temporal:true TimeDateWZControl:3 (Local) DaylightSavings:true TimeZoneHour:0 TimeZoneMinute:0 TimeZoneString:America Pacific (Example)	16. System TimeZone Hour:0 17. System TimeZone Minute:0 18. System TimeZone String:America Pacific (Example) 57. TimeDateWZControl:3 (Local)
5b	Temporal data is stored in the file system in UTC time. Daylight savings is observed. Temporal:true TimeDateWZControl:2 (UTC) DaylightSavings:true TimeZoneHour:0 TimeZoneMinute:0 TimeZoneString:America Pacific (Example)	16. System TimeZone Hour:0 17. System TimeZone Minute:0 18. System TimeZone String:America Pacific (Example) 57. TimeDateWZControl:2 (UTC)
5c	Temporal data is stored in the file system in system local time. Temporal data is displayed in UTC time. Daylight savings is not observed. Temporal:true TimeDateWZControl:3 (Local) DaylightSavings:false TimeZoneHour:0 TimeZoneMinute:0 TimeZoneString:Not Set	16. System TimeZone Hour:0 17. System TimeZone Minute:0 18. System TimeZone String:Not Set 57. TimeDateWZControl:3 (Local)
5d	Temporal data is stored in the file system in UTC time. Temporal data is displayed in UTC time. Daylight savings is not observed. Temporal:true TimeDateWZControl:2 (UTC) DaylightSavings:false TimeZoneHour:0 TimeZoneMinute:0 TimeZoneString:Not Set	16. System TimeZone Hour:0 17. System TimeZone Minute:0 18. System TimeZone String:Not Set 57. TimeDateWZControl:2 (UTC)
5e	Temporal data is stored in the file system in system local time. Daylight savings is not observed. Time offset from GMT is entered. Temporal:true TimeDateWZControl:3 (Local) DaylightSavings:false TimeZoneHour:5 (Example) TimeZoneMinute:30 (Example) TimeZoneString:Not Set	16. System TimeZone Hour:5 (Example) 17. System TimeZone Minute:30 (Example) 18. System TimeZone String:Not Set 57. TimeDateWZControl:3 (Local)
5f	Temporal data is stored in the file system in UTC time. Daylight savings is not observed. Time offset from GMT is entered. Temporal:true TimeDateWZControl:2 (UTC) DaylightSavings:false TimeZoneHour:5 (Example) TimeZoneMinute:30 (Example) TimeZoneString:Not Set	16. System TimeZone Hour:5 (Example) 17. System TimeZone Minute:30 (Example) 18. System TimeZone String:Not Set 57. TimeDateWZControl:2 (UTC)

Temporal Settings | Teradata VantageCore VMware - Temporal Settings - Teradata VantageCore VMware

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