16.20 - Example: Generating a Report of All Tables Without the Fallback Option in the DBC Database - 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 in the DBC database:

Exec NoFallBack_DB (’DBC’);

The resulting report follows:

*** Query completed. 15 rows found. 3 columns returned.
13/05/21                 NoFallBack Tables In Database DBC                 10:43
DataBase                       Table                                        Byte
------------------------------ ------------------------------ ------------------
DBC                            Acctg                                         7,6
                               ChangedRowJournal                             2,0
                               DataBaseSpace                               104,4
                               LocalSessionStatusTable                       6,1
                               LocalTransactionStatusTable                   2,0
                               OrdSysChngTable                               2,0
                               ReconfigJournal                               2,0
                               RecoveryLockTable                             2,0
                               RecoveryPJTable                               2,0
                               SavedTransactionStatusTable                   2,0
                               SysRcvStatJournal                            25,0
                               TransientJournal                         15,859,7
                               UtilityLockJournalTable                       2,0