16.20 - Restoring the Time Zone String - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K
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