FallBack_DB
Returns all tables in the specified database with 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 FallBack_DB macro reports the names of the database and tables, and the size of the table in bytes.
This macro is useful for obtaining all the tables in a particular database which have fallback copies.
For a discussion of fallback, see Database Design.
Example
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.