BTEQ Script Listing for ReconfigCheck Macro | SystemFE Macros | Teradata Vantage - ReconfigCheck - Teradata Vantage - Analytics Database

SystemFE Macros

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
iqw1628112378327.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
usl1472251351342
lifecycle
latest
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;';
      );