15.10 - ReconfigCheck - Teradata Database

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;';

      );