Run the Pre-Migration Script | Teradata Vantage - Running the Pre-Migration Preparation Script - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
stb1559324757649.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
Teradata Vantage
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.
  1. Create a temporary directory and change directory (cd) to that directory.
  2. 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.