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