15.11 - Disabling the Time Zone Setting - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

prodname
Data Stream Architecture
vrm_release
15.11
created_date
December 2016
category
User Guide
featnum
B035-3150-026K
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.20.00.00/etc/tdlocaledef.txt
    
    # cd /opt/teradata/tdat/tdbms/16.20.00.00/etc/
    # locate tdlocaledef.txt
    /opt/teradata/tdat/tdbms/16.10.00.00/etc/tdlocaledef.txt
    
    # cd /opt/teradata/tdat/tdbms/16.10.00.00/etc/
    # locate tdlocaledef.txt
    /opt/teradata/tdat/tdbms/16.00.00.00/etc/tdlocaledef.txt
    
    # cd /opt/teradata/tdat/tdbms/16.00.00.00/etc/
    # locate tdlocaledef.txt
    /opt/teradata/tdat/tdbms/15.10.00.02/etc/tdlocaledef.txt
    
    # cd /opt/teradata/tdat/tdbms/15.10.00.02/etc/
    # locate tdlocaledef.txt
    /opt/teradata/tdat/tdbms/15.00.00.00/etc/tdlocaledef.txt
    
    # cd /opt/teradata/tdat/tdbms/15.00.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