15.11 - Enabling 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 you disabled the Time Zone setting on the destination system before restoring DBC database, enable the setting after the post_data_restore script finishes running.
  1. On the destination system, access the directory where you saved the copy of tdlocaledef.txt. For example:
    # cd /opt/teradata/tdat/tdbms/16.20.00.00/etc/
    # cd /opt/teradata/tdat/tdbms/16.10.00.00/etc/
    # cd /opt/teradata/tdat/tdbms/16.00.00.00/etc/
    # cd /opt/teradata/tdat/tdbms/15.10.00.02/etc/
    # cd /opt/teradata/tdat/tdbms/15.00.00.00/etc/
  2. Run the tdlocaledef utility on the saved copy of tdlocaledef.txt. For example:
    # /usr/tdbms/bin/tdlocaledef -input tdlocaledef.txt.orig -output new
  3. Issue the tpareset command to enable the Time Zone setting:
    # tpareset -f set TimeZoneString
  4. Run the dbscontrol utility to confirm that the Time Zone setting is enabled. For example:
    # dbscontrol
    > display general
    
      18. System TimeZone String = American Eastern