15.10 - ReconfigCheck - Teradata Database

Teradata Database SystemFE Macros

prodname
Teradata Database
vrm_release
15.00
15.10
category
Administration
featnum
B035-1103-015K

ReconfigCheck

Returns an estimated number of bytes for each access module process (AMP) required for a reconfiguration operation.

Syntax

where:

 

Syntax Element …

Specifies …

DestAMPs

the number of AMPs to which you would like to calculate the amount of bytes required per AMP to complete the reconfiguration operation.

Note: This macro is not case sensitive. Uppercase and lowercase letters can be used interchangeably.

Usage Notes

The ReconfigCheck macro is useful for obtaining an estimate of the space required prior to performing a reconfiguration operation. Because of background system test, multiple executions of ReconfigCheck might return different results.

For more information on reconfiguring your system and the Reconfiguration utility, see Support Utilities.

Example  

The following statement generates a report which provides the estimated space required to reconfigure a one-AMP system:

Exec ReconfigCheck (1);

Example  

The following statement generates a report which provides the estimated space required per AMP to reconfigure a four-AMP system:

Exec ReconfigCheck (4);

The resulting report follows:

*** Delete completed. One row removed.
 
*** Total elapsed time was 1 second.
*** Insert completed. One row added. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Query completed. One row found. 2 columns returned. 
13/05/21                  Bytes Required For 4 AMP System                  10:50
 
                                          Bytes
                                       Required
                                        Per AMP
                                 --------------
                                  1,021,118,464
 
 *** Echo accepted.