16.20 - Example: Generating a Report of BYNET Events Between December and January - 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 BYNET Events between December 19, 2012 and January 1, 2013:

Exec BynetEvents ('2012-12-19', '2013-01-01');

The resulting report follows:

Exec BynetEvents ('2012-12-19','2013-01-01');

*** 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. 9 rows found. 5 columns returned.
13/02/29      BYNET Events Between 12/12/19 and 13/01/01      16:19
Date                 Time Message Text
-------- ---------------- -------------------------------------------------
12/12/28  12:49:04.000000 140001006|bynet |1|S|I|O|1|1|B|0|0|bya.c|65535|65535|
                          65535|10#BYA: BYA113-4 restarting to bring in late
                          arriver node 0xDE4 on port 0.
              
          14:52:48.000000 140000806|bynet|1|H|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|11#BYA: BYA112-4 input port error on
                          adapter port 1: unexpected command.
                          140000806|bynet|1|H|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|11#BYA: BYA113-4 input port error on adapter
                          port 0: soft carrier loss.
          15:02:05.000000 140001006|bynet |1|S|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|12#BYA: BYA113-4 restarting to bring in late
                          arriver node 0xDE4 on port 0.
                          140001006|bynet |1|S|I|O|1|3|B|0|0|bya.c|65535|65535|
                          65535|12#BYA: BYA112-4 restarting to bring in late
                          arriver node 0xDE4 on port 1.
12/12/29  19:09:48.000000 140000806|bynet |1|H|I|O|1|3|B|0|0|bya.c|65535|65535|
                          65535|13#BYA: BYA113-4 input port error on adapter
                          port 0: soft carrier loss.
                          140000806|bynet |1|H|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|13#BYA: BYA112-4 input port error on adapter
                          port 1: violation error.
          19:19:06.000000 140001006|bynet |1|S|I|O|1|1|B|0|0|bya.c|65535|65535|
                          65535|14#BYA: BYA112-4 restarting to bring in late
                          arriver node 0xDE4 on port 1.
                          140001006|bynet |1|S|I|O|1|3|B|0|0|bya.c|65535|65535|
                          65535|14#BYA: BYA113-4 restarting to bring in late
                          arriver node 0xDE4 on port 0.
*** Echo accepted.