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

 REPLACE MACRO SystemFE.ReconfigCheck (DestAMPs (SmallInt)) AS
      (
      Delete From SystemFE.Temp_ReconfigSpace all;
 
      Insert Into SystemFE.Temp_ReconfigSpace
      select Sum(Currentperm)
      From DBC.TableSize;
 
      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;';
      );