Disabling the Time Zone Setting - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.10.01
Published
November 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
fyx1509665931452.ditamap
dita:ditavalPath
3150_DSA_UG_1610.ditaval.ditaval
dita:id
B035-3150
Product Category
Software
Teradata Tools and Utilities
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/16.10.00.00/etc/tdlocaledef.txt
    
    # cd /opt/teradata/tdat/tdbms/16.10.00.00/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