Temporal Settings

Teradata® Database on VMware Base, Advanced, Enterprise Tiers Getting Started Guide

brand
Cloud
prodname
Teradata Database on VMware
vrm_release
Deployer 3.02
category
Configuration
Installation
featnum
B035-5958-018K
To use the Temporal option with Teradata Database on VMware, ensure you configure your system carefully to avoid issues with your data. For more information, see http://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 Temporal Table Support.

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 Teradata Database 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 Database Administration.


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)