Temporal Settings - Teradata Vantage on VMware

Teradata Vantage™ on VMware Base, Advanced, Enterprise Tiers Getting Started Guide

Product
Teradata Vantage on VMware
Release Number
Deployer 3.02.01
Published
February 2020
Language
English (United States)
Last Update
2020-02-14
dita:mapPath
hih1513715214615.ditamap
dita:ditavalPath
TDVMware_BAE_3.02.ditaval.ditaval
dita:id
B035-5958
lifecycle
previous
Product Category
Cloud
To use the Temporal option with Teradata Vantage on VMware, ensure 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.

To use the Temporal option, you must configure the NTP servers in the common.IT.properties.json file.

Contact your Vantage Administrator for the DBSControl Flag values for the time zone variables.

To determine your settings in the properties file, use the following diagram and table. If you do not know your TimeZoneString, see Teradata® Database Administration, B035-1093.

NO YES NO NO NO NO NO YES YES YES YES YES YES Will you restore data from another Teradata system? Locate settings for DBSControl general flags 16,17,18, and 57. Use the corresponding property values. Do you plan to use the Temporal feature? Do you observe Daylight savings? Do you know your TimeZoneString? NO Will you restore data from another Teradata system? 4 1 3 5 2 TVME_0002 See the documentation to determine your TimeZoneString. Do you want to display timestamp results in local time (instead of UTC Time)? Will you restore data from another Teradata system?

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.
  • See Temporal Time Zone Strings for the valid values for TimeZoneString.
  • In the table settings below, 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 Teradata system from which you are restoring data.
Scenario 5 reflects six possible variations, described below as 5a, 5b, 5c, 5d, 5e, and 5f.
Diagram Scenario Temporal Settings in the Property 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 Teradata 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 Teradata 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 Teradata 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 Teradata 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 Teradata 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 Teradata 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)