To determine which tables and databases are currently being logged for online archive, run a query against the ArchiveLoggingObjsV view. An example of a query is:
select CreateTimeStamp, DatabaseName (VARCHAR(30)), TVMName (VARCHAR(30)) from DBC.ArchiveLoggingObjsV; *** Query completed. One row found. 3 columns returned. *** Total elapsed time was 1 second. CreateTimeStamp DatabaseName TVMName -------------------------------------------------------- 2007-04-27 16:57:37 jmd t1