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