Disabling the Time Zone Setting - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
15.10
Published
November 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
heq1467819788761.ditamap
dita:ditavalPath
5942_Migrating_1510.ditaval.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
If the Time Zone setting is enabled on the destination system, disable the setting before restoring DBC database.
  1. On the destination system, locate the tdlocaledef.txt file that was used to enable the Time Zone setting, and access that directory. For example:
    # locate tdlocaledef.txt
    /opt/teradata/tdat/tdbms/15.10.00.02/etc/tdlocaledef.txt
    
    # cd /opt/teradata/tdat/tdbms/15.10.00.02/etc/
  2. Save a copy of the current tdlocaledef.txt file. For example:
    # cp  tdlocaledef.txt   tdlocaledef.txt.orig
  3. In tdlocaledef.txt, remove the value for the TimeZoneString property, leaving only the quotation marks. For example:
    # vi  tdlocaledef.txt 
    // System Time Zone string
    TimeZoneString {""}
    :wq!
  4. Run the tdlocaledef utility on tdlocaledef.txt:
    # /usr/tdbms/bin/tdlocaledef -input  tdlocaledef.txt  -output new
  5. Issue the tpareset command to disable the Time Zone setting:
    # tpareset -f remove TimeZoneString
  6. Run the dbscontrol utility to confirm that the Time Zone setting is disabled:
    # dbscontrol
    > display general
    
      18. System TimeZone String = Not Set