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