To enable the Temporal option for a virtual machine, set the Temporal property value in the node.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.
- 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.
Diagram Scenario | Temporal Settings in the Property File | DBS Control Setting Applied As |
---|---|---|
1 |
|
|
2 |
|
|
3 |
|
|
4 |
|
|
5a |
Temporal data is stored in the Teradata file system in system local time. Daylight savings is observed.
|
|
5b |
Temporal data is stored in the Teradata file system in UTC time. Daylight savings is observed.
|
|
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.
|
|
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.
|
|
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.
|
|
5f |
Temporal data is stored in the Teradata file system in UTC time. Daylight savings is not observed. Time offset from GMT is entered.
|
|