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.