Restoring with a Larger Number of AMPs - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

When running a complete restore (including database DBC) on a system with a larger number of AMPs, Teradata ARC sometimes returns an error that indicates the user database is out of space. This usually occurs only with databases that contain a large number of stored procedures or tables with poorly distributed data.

The reason for the error is that the perm space for a database is divided evenly among the AMPs on a system. When the target system has more AMPs, the perm space available on each AMP is lower. Tables with poorly distributed data might exceed the perm space allocation for one or more AMPs. If this error occurs, increase the perm space for the database and restart the restore operation.

A reconfiguration that defines fewer disks will always be logically smaller than the original, even if it uses the same number of AMPs. To prevent the restore from resulting in negative database space, reduce the maximum perm space of user databases before initiating a restore operation.