Running Pre-Processing Preparation Script - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
15.10
Published
November 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
heq1467819788761.ditamap
dita:ditavalPath
5942_Migrating_1510.ditaval.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
The latest PUTTools package must be downloaded and installed on all TPA nodes before this task can be performed.
Ensure there are no user objects created directly under DBC. They will not get copied properly in a migration or upgrade.

Run the pre-processing preparation script (pre_upgrade_prep.pl or 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 or upgrade process.

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/tdxx.xx.xx.xx, where xx.xx.xx.xx is the Teradata Database release number. Use the scripts in either the preupgrade or premigration subdirectory, depending on the process you are performing.
  1. Create a temporary directory and change directory (cd) to that directory.
  2. From a temporary directory, run the perl command to execute the script: perl /opt/Teradata/PUTTools/xx.xx.xx.xx/preprocess/pre_process_prep.pl system_name/dbc,dbc_password output_filename , for example: perl /opt/Teradata/PUTTools/xx.xx.xx.xx/preupgrade/pre_upgrade_prep.pl tdsysl/dbc,dbc_password prep.out

    The report files created by the script are stored in the local, temporary directory from which you ran the script.