15.10 - ListEvent - Teradata Database

Teradata Database SystemFE Macros

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

ListEvent

Returns a particular event code for the set period of time.

Syntax

where:

 

Syntax element …

Specifies …

Event

the number of the event code for which you want to search.

The format of event is an integer, as shown in Event Code (Message) Format Interpretation.

Fromdate

the date on which the search is to start.

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 date on which the search is to stop.

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 ListEvent macro is useful for obtaining a look at all occurrences of the desired event.

Example  

The following statement generates a report of all 033- 13895 -00 events between May 5, 2013, and the date of today:

Exec ListEvent (0331389500, ’2013-05-05’,);

Example  

The following statement generates a report of all 033-13895-00 events for the last seven days:

Exec ListEvent (0331389500, Date-06,);

Example  

The following statement generates a report of all 033-12116-00 events between May 5, 2013 and May 18, 2013:

Exec ListEvent (0331211600, ’2013-05-05’ , ’2013-05-18’);

The resulting report follows:

13/05/18 All 33-12116-00 Events Between 2013-05-05 and 2013-05-18     13:51
 
    Date            Time Message Text
-------- --------------- -------------------------------------------------------
13/05/18 18:54:29.380000 13/05/18 18:54:26 Running DBS Version: 12m.00.00.00
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:29.420000 13/05/18 18:54:26 Running PDE Version: 12m.00.00.00
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:29.480000 13/05/18 18:54:26 AMP 0 has been selected as the Contro
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:29.520000 13/05/18 18:54:26 Redistribution minicasts are enabled
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:29.580000 13/05/18 18:54:26 The OCS System Profiles GDO has been
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:29.620000 Event number 34-02900-00 (severity 10, category 10)
                         13/05/18 18:54:27 Initializing DBS Vprocs
 
         18:54:44.340000 13/05/18 18:54:44 Initializing DBS Configuration
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:45.010000 13/05/18 18:54:44 Configuration is operational
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:47.490000 13/05/18 18:54:47 Starting AMP partitions
                         Event number 34-02900-00 (severity 10, category 10)
 
         18:54:48.060000 send_gtw_enable: sending
 
         18:54:48.200000 May 05 18:54:48 Teradata DBS Gateway: [105]: error logg
 
         18:54:49.960000 May 05 18:54:49 Teradata DBS Gateway: [105]: ycgsecurit
 
         18:54:50.000000 May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
                         May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
                         May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
                         May 05 18:54:50 Teradata DBS Gateway: [105]: ycgsecurit
 
         18:54:54.740000 Event number 34-02900-00 (severity 10, category 10)
                         13/05/18 18:54:52 DBS RestartKind: COLD (Do not wait fo
 
         18:54:54.850000 Event number 34-02900-00 (severity 10, category 10)