If you need to migrate a single table or database, run the post_data_restore script with the -t option. The post_data_restore script performs required actions such as revalidating PPI tables and compiling stored procedures and UDFs on all database objects in the system. Running the script with the -t option limits the required actions to only the single database or table being restored. In addition, the -t option suppresses production of harmless errors that do not require resolution.
Do not run DIP scripts after migrating a single table or database.
- Log in on the Control Node as user root.
-
Run the post_data_restore script with the -t option, using the following syntax:
# /opt/teradata/PUTTools/tdxx.xx.xx.xx/IUMB_scripts/post_data_restore -t tablename_or_databasename tdpid/dbc,dbcpassword
where xx.xx.xx.xx is the release number. Example:To run the post_date_restore script for table DB1.Tbl1 on a Teradata Database release 15.10 system (full release number 15.10.00.00) that has a TDPID of TDProd, use the following command:
# /opt/teradata/PUTTools/td15.10.00.00/IUMB_scripts/post_data_restore -t DB1.Tbl1 TDProd/dbc,dbcpassword