15.10 - ListRestart_Logon_Events - Teradata Database

Teradata Database SystemFE Macros

prodname
Teradata Database
vrm_release
15.00
15.10
category
Administration
featnum
B035-1103-015K

ListRestart_Logon_Events

Returns all software restart events and logon-enabled events logged in the DBC.SW_Event_Log table for the set period of time.

Syntax

where:

 

Syntax Element …

Specifies …

Fromdate

the earliest date of a restart/logon that is to be listed in the report.

The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531.

Todate

the latest date of a restart/logon that is to be listed in the report.

The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531. The default value for Todate is the current date.

Note: This macro is not case sensitive. Uppercase and lowercase letters can be used interchangeably.

Usage Notes

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 “Parallel Database Extensions (PDE) Messages” chapter of Messages.

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.

Note: 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.

Example  

The following statement generates a report of all restarts and logon-enabled events between May 5, 2013, and the date of today:

Exec ListRestart_Logon_Events ('2013-05-05',);

Example  

The following statement generates a report of all restarts and logon­­‑enabled events between January 1, 2013 and March 9, 2013:

Exec ListRestart_Logon_Events('2013-01-01','2013-03-09');

Example  

The following statement generates a report of all restarts and logon-enabled events for the last 11 days:

Exec ListRestart_Logon_Events(date-10,date);

The resulting report follows:

EXECUTE ListRestart_Logon_Events (date-10,date);
 
 *** Query completed. 17 rows found. 5 columns returned. 
 
13/05/29                  (Crashable/logon-enabled Events)                 09:42
 
                        Between 2013-05-19 and 2013-05-29                       
 
    Date            Time Message Text
-------- --------------- -------------------------------------------------------
13/05/21 00:55:17.162969 13/05/21 00:55:17 Logons are enabled
13/05/26 03:06:04.232870 13/05/26 03:06:04 Logons are enabled
         22:40:15.943210 13/05/26 22:40:15 Logons are enabled
13/05/27		 00:39:52.300814 13/05/27 00:39:52 Logons are enabled
         01:07:21.218686 13/05/27 01:07:21 Logons are enabled
         01:16:14.637825 13/05/27 01:16:14 Logons are enabled