16.20 - Example: Generating a Report of Tables Without the Fallback Option - Teradata Vantage NewSQL Engine

Teradata Vantage™ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K

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.