16.20 - Running the post_data_restore Script - 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
The post_data_restore script must be executed after restoring all user data. This script performs a variety of tasks necessary to prepare the system for use on the Teradata Database release, including DIP script execution and stored procedure recompilation. You must review the results of the post_data_restore script to verify that all tasks completed without error.

Each Teradata Database release has a unique subdirectory in the PUTTools directory for the pre-upgrade and pre-migration scripts applicable to that release. The folder is /opt/teradata/PUTTools/tdnn.xx.xx.xx, where nn is the major release number (15, 16, 17, and so forth), and xx.xx.xx is either the literal string xx.xx.xx (for initial releases, like 15.00, 16.00, 17.00, and so forth) or the minor release number (like 10, for 15.10 or 16.10) followed by xx.xx.

  1. Log on to the Control Node as user root.
  2. Run the post_data_restore script.
    # /opt/teradata/PUTTools/tdnn.xx.xx.xx/IUMB_scripts/post_data_restore DBSsystem_name/dbc,dbcpassword
  3. When the script finishes, examine the error summary at the end of the output log file, where each error detected during the script execution is detailed. Output log files can be found in /var/opt/Teradata/PUTTools/post_data_restore_xx.xx.xx.xx .
  4. After correcting the errors, run the script again until there are no errors that require correction.
    Do not continue with the migration until the script runs without any errors that require correction.