17.00 - 17.05 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

The ListRestart_Logon_Events report is based on event code 033-13895-00 for restart events, and the time the "Logons are enabled" message is reported in the Software_Event_Log table for logon-enabled events.

For a complete description of these events, see “Parallel Database Extensions (PDE) Messages” in Teradata Vantage™ - Database Messages, B035-1096.

The output shows the date, time, and all lines of the DBC.SW_Event_Log connected with each software restart event, and one line connected with the logon-enabled event. The logon-enabled event is the time the "Logons are enabled" message is reported in the DBC.SW_Event_Log table. This macro depicts the time Teradata Database recovered.

The column value “TheTime” in the DBC.SW_Event_log table is the time when the database came back up after the restart. It is not the time the reset starts because while the database is down, the system cannot access the SW_Event_log table to log the time.