NoFallBack_All
Returns all tables in the system which have no fallback protection.
Syntax
Note: This macro is not case sensitive. Uppercase and lowercase letters can be used interchangeably.
Usage Notes
The NoFallBack_All macro reports the names of the database and tables, and the size of the table in bytes.
This macro is useful for obtaining a look at all the tables on the system which do not have fallback copies.
For a discussion of fallback, see Database Design.
Example
The following statement generates a report of all tables without the fallback option:
Exec NoFallBack_All;
The resulting report follows:
Exec NoFallBack_All;
*** Query completed. 20 rows found. 3 columns returned.
13/05/21 NoFallBack Tables In All Databases 09:36
DataBase Table Bytes
--------------- ------------------------------ -------------------
DBC Acctg 7,680
ChangedRowJournal 2,048
DataBaseSpace 104,448
LocalSessionStatusTable 6,144
LocalTransactionStatusTable 2,048
OrdSysChngTable 2,048
ReconfigJournal 2,048
RecoveryLockTable 2,048
RecoveryPJTable 2,048
SavedTransactionStatusTable 2,048
SysRcvStatJournal 25,088
TransientJournal 15,859,712
UtilityLockJournalTable 2,048
*** Echo accepted.