Restore the Time Zone String | Teradata DSA - 17.00 - 17.05 - Restoring the Time Zone String - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Configuration
Installation
Publication ID
B035-5942-170K
Language
English (United States)
If you removed the Time Zone String on the destination system before restoring DBC database, restore the string after you run the post_data_restore script.
  1. On the destination system, access the directory where you saved the copy of tdlocaledef.txt. For example:
    # cd /opt/teradata/tdat/tdbms/XX.XX.XX.XX/etc/
  2. Delete the tdlocaledef.txt file you edited to remove the Time Zone String, and rename the original tdlocaledef.txt.orig file to tdlocaledef.txt. For example:
    # rm tdlocaledef.txt
    
    # mv tdlocaledef.txt.orig tdlocaledef.txt
  3. Run the tdlocaledef utility to compile the tdlocaledef.txt file.
    # /usr/tdbms/bin/tdlocaledef -input  tdlocaledef.txt  -output new
  4. Run tpareset to restart the database and put the new tdlocaledef settings into effect, restoring the original Time Zone String:
    # tpareset -f set the Time Zone String
  5. Run the DBS Control utility and display the General fields to confirm that the Time Zone String has been restored.
    # dbscontrol
    
    Enter a command, HELP, or QUIT:
    di gen
    
    Confirm that the value for field 18 is no longer Not Set.
     18. System TimeZone String         = America Pacific