Usage Notes - Teradata Vantage - Analytics Database

SystemFE Macros

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
iqw1628112378327.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
usl1472251351342
lifecycle
latest
Product Category
Teradata Vantage™

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.