Determining Database Readiness - Teradata Database

Teradata Database Node Software Upgrade Guide: Overview and Preparation

Product
Teradata Database
Release Number
16.10
15.10
Published
July 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
ecl1480972909700.ditamap
dita:ditavalPath
ft:empty
dita:id
cvc1467245366194
Product Category
Software

The Pre-Upgrade Preparation Script evaluates the Teradata Database to find any problems that must be addressed before a major or a minor Teradata Database upgrade is performed. The script combines several inspections into a single script. The script also runs queries to generate data to input into the Upgrade Estimator Tool, which estimates the time required for the upgrade.

The script inspects the following areas for problems and creates a summary report:
  • Reserved Words conflicts
  • DBQL Data
  • Stored Procedures with no source
  • In-Doubt Transactions (Replication systems only)
  • MDS Rows
  • Default Role assigned to user DBC
  • Potential Unicode Conversion errors

Examine the summary report and resolve any problems it finds. More information about how to resolve these problems is provided in the specific Teradata Database Upgrade Guide for your system, OS and Teradata Database target release.

The summary report also provides data you will use when you run the Upgrade Estimator Tool. Make sure you save this information for later use.