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.