If you disabled the Time Zone setting on the destination system before restoring DBC database, enable the setting after the post_data_restore script finishes running.
-
On the destination system, access the directory where you saved the copy of tdlocaledef.txt. For example:
# cd /opt/teradata/tdat/tdbms/16.10.00.00/etc/
-
Run the tdlocaledef utility on the saved copy of tdlocaledef.txt. For example:
# /usr/tdbms/bin/tdlocaledef -input tdlocaledef.txt.orig -output new
-
Issue the tpareset command to enable the Time Zone setting:
# tpareset -f set TimeZoneString
-
Run the dbscontrol utility to confirm that the Time Zone setting is enabled. For example:
# dbscontrol > display general 18. System TimeZone String = American Eastern