Prerequisite
Download and install the latest PUTTools package on all TPA nodes.
DBC must have full access rights for DBC prior to archiving/restoring DBC. If DBC does not have full access rights for DBC, those right need to be granted prior to performing the archive. If the source system is not available, when DBC has been restored, you must explicitly grant full access rights for each object, view, and macro under DBC before running the post_dbc_restore script and DIP.
Run pre_migration_prep.pl on the source system. The script performs a variety of checks for potential problems that must be resolved prior to continuing the migration process.
Each Advanced SQL Engine release has a unique subdirectory in the PUTTools directory for the pre-migration script applicable to that release. The folder is /opt/teradata/PUTTools/td17.xx.xx.xx/preupgrade/pre_migration_prep.pl.- Create a temporary directory and change directory (cd) to that directory.
-
In the temporary directory, run the perl command to start the script:
perl /opt/teradata/PUTTools/td17.xx.xx.xx/preupgrade/pre_migration_prep.pl system_name/dbc,dbc_password output_filename
The script generates output report files to the temporary directory.