16.20 - Example: Generating a Statement of Tables with the Fallback Option - 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 with the fallback option:

Exec FallBack_All;

The resulting report follows:

BTEQ -- Enter your DBC/SQL request or BTEQ command:
EXECUTE FallBack_All;
EXECUTE FallBack_All;
*** Echo accepted.
*** Total elapsed time was 1 second.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Query completed. 147 rows found. 3 columns returned.
13/05/21                  FallBack Tables In All Databases                 10:20
DataBase         Table                                         Bytes
---------------  ------------------------------  -------------------
DBC              AccessRights                                468,992
                 AccLogRuleTb                                  8,192
                 AccLogTbl                                     4,096
                 Accounts                                      5,120
                 All                                   4,078,191,616
                 ArchiveLoggingObjsTb                          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
                 DBQLExplainTb                                 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
SysAdmin         FastLog                                       4,096
                 HelpSyntax                                1,381,376
SYSLIB           dem                                           4,096
                 demddl                                        4,096
                 dempart                                       4,096
                 installsp                                    35,840
                 loadpkg                                     226,304
                 savepkg                                      57,344
SystemFe         CleanupQCFVer                                 7,168
                 CreateQCFVer                                119,808
                 opt_cost_table                               22,528
                 Opt_DBSCtl_Table                              4,096
                 opt_ras_table                                24,576
                 Temp_ReconfigSpace                            2,048
Sys_Calendar     CALDATES                                  2,652,160
 *** Echo accepted.