Inspect Pre-Migration Script Output | Teradata Vantage - 17.00 - 17.05 - Inspecting Pre-Migration Preparation Script Output - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Node Software Migration Guide

Advanced SQL Engine
Teradata Database
Release Number
Release Date
June 2020
Content Type
Publication ID
English (United States)

The script tests for several types of issues that can prevent or halt the migration. The script outputs results for each type of check to the standard output. As the script runs, results for each of the individual checks are preceded by an output line such as **** Checking for Reserved Words ….

The script saves the results of each type of check to a separate output file in the directory where the script is located. Inspect these files and resolve any reported problems before continuing.

There are checks for each of the following types of items:

Item Type What the Script Checks What You Must Do
Reserved Words Use of any reserved words in the user-defined tables and stored procedures. Remove reserved words from tables and procedures. For more information, see Working With Reserved Words.
DBQL Data Non-empty tables are reported because DBQL tables are not archived/restored. Copy DBQL table data to a user table, if you want to migrate the DBQL data to the destination system. For more information, see Saving DBQL Log Data.
Stored Procedures with No Source Code Stored procedures without source code cannot be recompiled on the destination system. Rewrite SQL procedures to include the WITH SPL option in order to store the source code in the database. For more information, see Fixing SQL Stored Procedures.
DBC Startup String

Checks for a startup string assigned to user DBC. A startup string may prevent logons after the version switch to a new release.

Set StartupString to NULL for user DBC before the migration or upgrade.
Triggers on TDWM.RULEBYPASS Checks for triggers on the TDWM.RULEBYPASS table. Remove any triggers on the TDWM.RULEBYPASS table before the migration or upgrade.
Orphaned Access Rights Checks for orphaned rows in DBC.AccessRights. Open an incident for Teradata Services and attach the orphaned rows report file.
Secure Zones Checks for the use of secure zones on the source system. See Secure Zone documentation in Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.
PPI tables using hashbuckets function to define partition ranges. Checks for PPI tables. This is not supported as part of the migration. You must partition the tables differently prior to the migration.
Geospatial types Checks for old geospatial type definitions which are not compatible with the latest geospatial types provided by Teradata. In order to use the latest geospatial types and functionality provided by Vantage, you must drop these old geospatial types.
HUT locks Checks for any HUT locks that have not been released. You must release the HUT lock manually.
Cnsrun This check is used to detect whether there is something wrong with the way the system is configured that will cause problems with the migration. You should examine the /etc/hosts file and resolve the inconsistencies.

A summary section at the end of the report indicates whether the system is ready to proceed with the migration or upgrade.