Run the Pre-Migration Script | Teradata Vantage - 17.00 - 17.05 - 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.00
17.05
Release Date
June 2020
Content Type
Administration
Configuration
Installation
Publication ID
B035-5942-170K
Language
English (United States)
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.