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

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kak1592015099875.ditamap
dita:ditavalPath
kak1592015099875.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantageā„¢
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;';
      );