16.20 - Example: Generating a Report of 033-12116-00 Events in May - Teradata Vantage NewSQL Engine

Teradata Vantage™ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K

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)