15.10 - BynetEvents - Teradata Database

Teradata Database SystemFE Macros

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

BynetEvents

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

Syntax

where:

 

Syntax element …

Specifies …

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 BynetEvents macro returns all messages based on event codes:

  • 033-11100-00 to 033-11121-00 (TDN messages)
  • 033-12900-00 to 033-12999-00 (BNS messages)
  • 033-13000-00 to 033-13021-00 (CFG messages)
  • And, for any event from any series that contains the string "bynet"
  • For a complete description of these events, see the “Parallel Database Extensions (PDE) Messages” chapter of Messages.

    If you want to examine more information than the macro displays by default, run a SELECT query on the DBC.SW_Event_Log table by providing the necessary criteria and targeting against the field “TEXT.” Here is an example of the SELECT query:

    select * from dbc.Software_Event_Log
    where Text like ’%restart%’
    order by thedate, thetime
    ;

    This causes the system to display all the available information for the events rather than a truncated version. In most cases, the latter version is sufficient to understand the nature of the problem.

    Informational messages (that is, those requiring no action) are recorded to the DBC.Software_Event_Log view when one of the following occurs:

  • A TPA restart occurs
  • The BYNET initiates a TPA restart
  • When multiple messages are recorded over a very short time period, a BYNET event might have occurred forcing a node offline. If a node has been forced offline by the BYNET, you might need a Teradata field engineer to resolve the BYNET event.

    Example  

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

    Exec BynetEvents (Date-6,);

    Example  

    The following statement generates a report of BYNET Events between October 20, 2012 and February 23, 2013:

    Exec BynetEvents ('2012-10-20', '2013-02-23');

    Example  

    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.