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