Determining Whether Online Archive Logging is in Use
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