NoFallBack_DB
Returns all tables in the specified database with no 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 NoFallBack_DB 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 in a particular database 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 in the DBC database:
Exec NoFallBack_DB (’DBC’);
The resulting report follows:
*** Query completed. 15 rows found. 3 columns returned.
13/05/21 NoFallBack Tables In Database DBC 10:43
DataBase Table Byte
------------------------------ ------------------------------ ------------------
DBC Acctg 7,6
ChangedRowJournal 2,0
DataBaseSpace 104,4
LocalSessionStatusTable 6,1
LocalTransactionStatusTable 2,0
OrdSysChngTable 2,0
ReconfigJournal 2,0
RecoveryLockTable 2,0
RecoveryPJTable 2,0
SavedTransactionStatusTable 2,0
SysRcvStatJournal 25,0
TransientJournal 15,859,7
UtilityLockJournalTable 2,0