15.10 - NoFallBack_All - Teradata Database

Teradata Database SystemFE Macros

prodname
Teradata Database
vrm_release
15.00
15.10
category
Administration
featnum
B035-1103-015K

NoFallBack_All

Returns all tables in the system which have no fallback protection.

Syntax

Note: This macro is not case sensitive. Uppercase and lowercase letters can be used interchangeably.

Usage Notes

The NoFallBack_All macro reports the names of the database and tables, and the size of the table in bytes.

This macro is useful for obtaining a look at all the tables on the system which do not have fallback copies.

For a discussion of fallback, see Database Design.

Example  

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.