16.20 - ReconfigCheck - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K
REPLACE MACRO SystemFE.ReconfigCheck (DestAMPs (SmallInt)) AS
      (
      Delete From SystemFE.Temp_ReconfigSpace all;
      Insert Into SystemFE.Temp_ReconfigSpace
      select Sum(Currentperm)
      From DBC.TableSizeV;
      echo 'set defaults;';
      echo 'set format on;';
      echo 'set width 80;';
      echo 'set NULL as "-";';
      echo 'set separator 2;';
      echo 'set pagelength 60;';
      echo 'set omit on 1;';
      echo 'set heading "&DATE||Bytes Required For &1 AMP	 	            System||&TIME";'
      ;
      select :DestAmps,
    (Permspace/:DestAmps)
    (Title 'Bytes//Required//Per AMP', Format 'zz,zzz,z99,999')
      From  SystemFE.Temp_ReconfigSpace;
      echo 'set defaults;';
      );