17.10 - Example: Generating a Report of Tables Without the Fallback Option - 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)

The following statement generates a report of all tables without the fallback option:

Exec NoFallBack_All;

The resulting report follows:

                   Exec NoFallBack_All;

*** Query completed. 20 rows found. 3 columns returned.
13/05/21                 NoFallBack Tables In All Databases                09:36
DataBase         Table                                         Bytes
---------------  ------------------------------  -------------------
DBC              Acctg                                         7,680
                 ChangedRowJournal                             2,048
                 DataBaseSpace                               104,448
                 LocalSessionStatusTable                       6,144
                 LocalTransactionStatusTable                   2,048
                 OrdSysChngTable                               2,048
                 ReconfigJournal                               2,048
                 RecoveryLockTable                             2,048
                 RecoveryPJTable                               2,048
                 SavedTransactionStatusTable                   2,048
                 SysRcvStatJournal                            25,088
                 TransientJournal                         15,859,712
                 UtilityLockJournalTable                       2,048
 *** Echo accepted.