17.00 - 17.05 - Example: Generating a Report of 033-12116-00 Events in May - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

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)