15.10 - AllRestarts - Teradata Database

Teradata Database SystemFE Macros

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

AllRestarts

Returns all software restart events logged in the DBC.SW_Event_Log table for a set period of time.

Syntax

where:

 

Syntax element …

Specifies …

Fromdate

the earliest date of a restart 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 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 AllRestarts macro report is based on event code 033-13895-00.

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. This macro also provides a summary of the causes of outage at the end of the report to help identify events that cause the most restarts.

Example  

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

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

Example  

The following statement generates a report of all restarts for the last seven days:

Exec AllRestarts (Date-6,);

Example  

The following statement generates a report of all restarts between January 1, 2013 and
May 18, 2013:

exec AllRestarts('2013-01-01','2014-03-18');

The system displays a report similar to this:

exec AllRestarts('2013-01-01','2014-03-18');
 
 *** Echo accepted. 
 *** Total elapsed time was 1 second.
 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Query completed. 4 rows found. 5 columns returned. 
14/04/04                              (Crashable Events)                             11:45
                          Between 2013-01-01 and      2014-03-18                          
 
 
    Date            Time Message Text
-------- --------------- -----------------------------------------------------------------
14/03/14 16:54:28.912135 PDE: TPA restart initiated by this node, 001-01, for event 10198.
 
         16:54:55.723604 PDE: TPA restart initiated by this node, 001-01, for event 10198.
 
14/03/17 14:39:29.013986 PDE: TPA restart initiated by this node, 001-01, for event 10198.
 
         15:05:51.651466 PDE: TPA restart initiated by this node, 001-01, for event 10198.
 
 *** Echo accepted. 
 
 *** Echo accepted. 
 
 *** Query completed. One row found. One column returned. 
                                      Total Restarts                                      
 
                                          Restarts
                                       -----------
                                                 4
 
 *** Echo accepted.