17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
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 the information about 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 Vantage 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.