Restore the Time Zone String | Teradata DSA - Restoring the Time Zone String - BAR - Data Stream Architecture

Teradata® DSA User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-11-30
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities
If you removed the Time Zone String on the destination system before running the DIPMIG script, restore the string after you run it.
  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