16.10 - Reconfiguring the Database - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

When you add nodes, AMPs, or disks to the Teradata Database configuration, it is good practice to always first backup all data. Some types of expansion, such as adding a disk array, require row redistribution, so if the system contains very large tables, it may be faster to archive and restore.

You can use the Reconfiguration Estimator utility to obtain an estimate of elapsed time needed for reconfiguration, based on the number and size of the data tables on your current system.

The Reconfiguration Estimator prompts you for information about the planned upgrade and provides estimates for the following phases:

  • Redistribution
  • Deletion
  • Rebuilding SIs

If you have questions about possible procedures or the reported time estimates, contact Teradata Customer Support. For an overview of the utilities, issues, and procedures involved in a TPA reconfiguration, see Support Utilities.