16.20 - Example: Using ArchiveLoggingObjsV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The following SELECT statement displays information about the tables that have online archive active logs and their online archive logging levels. In this example, the logging levels are either T or D (O is also a possible value).

  • T = Online Archive Logging was activated on the table level.
  • D = Online Archive Logging was activated on the database level.
  • O = Nontable objects.
    SELECT databasename, tvmname, loglevel FROM dbc.archiveloggingobjsv;

Result:

DatabaseName      TVMName      LogLevel
---------------   -------      --------
oarc_otop005db1   Tab_nfb      T
oarc_oth007db1    Tab_nfb      D
oarc_oth007db1    tab_fb       D
oarc_otop010db1   Tab_nfb      D
oarc_oth007db1    tab_ppi      D
oarc_otop010db1   tab_nusi     D
oarc_otop016db1   Tab_nfb      T
oarc_oth008db1    Tab_queue    T
oarc_otop010db1   tab_bigcol   D
oarc_otop001db1   Tab_nfb      T
oarc_otop018db1   Tab_nfb      T
oarc_comb002db1   tab_fb       T