15.10 - NoFallBack_DB - Teradata Database

Teradata Database SystemFE Macros

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

NoFallBack_DB

Returns all tables in the specified database with no fallback protection.

Syntax

where:

 

Syntax Element …

Specifies …

DBName

the name of the database you want to be listed.

The name should be in single apostrophes as indicated.

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

Usage Notes

The NoFallBack_DB 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 in a particular database 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 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