BTEQ Script Listing for ReconfigCheck Macro | SystemFE Macros | Teradata Vantage - 17.10 - ReconfigCheck - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
Language
English (United States)
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;';
      );