Restoring the Time Zone String - BAR - Data Stream Architecture - Follow these steps to restore Time Zone String after restoring the DBC database.

Teradata® DSA User Guide

Product

BAR

Data Stream Architecture

Release Number

16.20

Published

November 2019

Language

English (United States)

Last Update

2019-11-27

dita:mapPath

xfr1514490991957.ditamap

dita:ditavalPath

3150_DSA_UG_1650-working-RR-new.ditaval

dita:id

B035-3150

lifecycle

Product Category

Software

Teradata Tools and Utilities

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.

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/
```
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
```

Run the tdlocaledef utility to compile the tdlocaledef.txt file.

# /usr/tdbms/bin/tdlocaledef -input  tdlocaledef.txt  -output new

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
```
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
```