15.10 - ArchiveLoggingObjsV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

TVMName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

LogLevel

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

ArchiveLoggingObjsTbl.LogLevel

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.CreatorName

CreateTimeStamp

TIMESTAMP(0)

NOT NULL

YYYY-MM-DDBHH:MI:SS

ArchiveLoggingObjsTbl.CreateTimeStamp

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