17.00 - 17.05 - Example: Generating a Report of Tables with 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.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

The following statement generates a report of all tables with the fallback option in the DBC database:

Exec FallBack_DB (’DBC’);

The resulting report follows:

EXECUTE FallBack_DB ('DBC');
 *** Echo accepted.
 *** Total elapsed time was 1 second.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Echo accepted.
 *** Query completed. 131 rows found. 3 columns returned.
13/05/21                   FallBack Tables In Database DBC                     10:31
DataBase               Table                              Bytes
--------------------   -----------------------------      ----------------
DBC                    AccessRights                                468,992
                       AccLogRuleTbl                                 8,192
                       AccLogTbl                                     4,096
                       Accounts                                      5,120
                       All                                   4,078,191,616
                       ArchiveLoggingObjsTbl                         4,096
                       CollationTbl                                 14,336
                       ColumnCorrelation                             4,096
                       ConstantDefs                                302,080
                       ConstantValues                              177,152
                       ConstraintNames                               9,216
                       CostProfiles                                 23,552
                       CostProfileTypes                              8,192
                       Dbase                                        22,528
                       DBCAssociation                                4,096
                       DBCInfoTbl                                    5,120
                       DBQLExplainTbl                                4,096
                       DBQLObjTbl                                    4,096
                       DBQLogTbl                                    10,240
                       DBQLRuleCountTbl                              3,072
                       DBQLRuleTbl                                   4,096
                       DBQLSqlTbl                                    4,096
                       DBQLStepTbl                                   6,144
                       DBQLSummaryTbl                                4,096
                       Dependency                                    4,096
                       ErrorMsgs                                   711,680
                       ErrorTbls                                     4,096
                       EventLog                                     66,560
                       Global                                        3,072
                       Hosts                                         4,096
                       IdCol                                         5,120
                       Indexes                                      61,440
                       InDoubtResLog                                 4,096
                       JARS                                          4,096
                       JAR_JAR_USAGE                                 4,096
                       LogonRuleTbl                                  6,144
                       MDSRecoveryTbl                                2,048
                       Migration                                     3,072
                       Next                                          5,120
                       OldPasswords                                  4,096
                       Owners                                        3,072
                       ParentChildCorrelation                        4,096
                       Parents                                       5,120
                       PasswordRestrictions                        141,312
                       Profiles                                      4,096
                       RCConfiguration                               4,096
                       RCEvent                                      10,240
                       RCMedia                                       2,048
                       ReconfigInfo                                  6,144
                       ReconfigOrder                                 4,096
                       ReconfigTableStats                            6,144
                       ReferencedTbls                                4,096
                       ReferencingTbls                               4,096
                       RepBatchStatus                                2,048
                       RepGroup                                      4,096
                       RepGroupTables                                2,048
                       ResUsageIpma                              2,165,760
                       ResUsageIvpr                            148,591,616
                       ResUsageSawt                             34,482,176
                       ResUsageScpu                              1,602,560
                       ResUsageShst                              8,052,736
                       ResUsageSldv                             24,064,000
                       ResUsageSpdsk                            15,404,032
                       ResUsageSpma                              3,770,368
                       ResUsageSps                           3,491,786,752
                       ResUsageSvdsk                             7,472,128
                       ResUsageSvpr                            311,285,760
                       RoleGrants                                    4,096
                       Roles                                         4,096
                       ROUTINE_JAR_USAGE                             4,096
                       SessionTbl                                    8,192
                       SW_Event_Log                                  4,096
                       SysSecDefaults                                5,120
                       SystemQTbl                                    2,048
                       TableConstraints                              8,192
                       TDWMEventHistory                              4,096
                       TDWMEventLog                                  4,096
                       TDWMExceptionLog                              4,096
                       TDWMSummaryLog                                4,096
                       TempStatistics                                4,096
                       TempTables                                    4,096
                       TextTbl                                     509,952
                       Translation                                  72,704
                       TriggersTbl                                   4,096
                       TSETQueryText                                 4,096
                       TVFields                                  3,725,312
                       TVM                                       6,695,936
                       UDFInfo                                      20,480
                       UDTCast                                       4,096
                       UDTInfo                                       4,096
                       UDTTransform                                  4,096
                       UnResolvedReferences                          4,096
 *** Echo accepted.