15.10 - ListSoftware_Event_Log - Teradata Database

Teradata Database SystemFE Macros

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

ListSoftware_Event_Log

Returns all events (hardware and software) found in DBC.SW_Event_Log table for the 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 ListSoftware_Event_Log macro is useful for obtaining a quick look at the contents of DBC.SW_Event_Log for a given time frame.

Note: This report can get large very quickly.

Example  

The following statement would give a copy of the Software_Event_Log between
January 1, 2013, and the date of today:

Exec ListSoftware_Event_Log ('2013-01-01',);

Example  

The following statement would give a copy of the Software_Event_Log for the last seven days:

Exec ListSoftware_Event_Log (Date-6,);

Example  

The following statement would give a copy of the Software_Event_Log for a specific date in the past, specifically May 21, 2013:

Exec ListSoftware_Event_Log ('2013-05-21', '2013-05-21');

The resulting report follows:

Exec ListSoftware_Event_Log ('2013-05-21', '2013-05-21');
 
*** 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. 30 rows found. 6 columns returned. 
13/05/28   Software Event Log Listing Between 2013-05-21 and 2013-05-21     13:40 
 
Date       Time             Event Tag    				Message Text
---------- ---------------- ----------- --------------------------------------------------------------
13/05/21   00:55:12.569072  34-02900-00 	13/05/21 00:55:12 					Starting AMP partitions
           00:55:13.049967  34-02900-00 								13/05/21 00:55:13 					DBS RestartKind: COLD (Do not wait for
                                                          transaction recovery)
           00:55:13.090731  34-02900-00 								13/05/21 00:55:13 					Voting for transaction recovery
           00:55:13.221652  34-02900-00 								13/05/21 00:55:13 					Recovery session 1 contains 181 rows on 
                                                          AMP 00000
           00:55:13.825460  34-02900-00 								13/05/21 00:55:13 					Starting transaction recovery
           00:55:13.978402  34-02900-00 								13/05/21 00:55:13 					Starting PE partitions
           00:55:14.255917  34-02900-00 								13/05/21 00:55:14 					Completed transaction recovery
           00:55:16.582331  34-02900-00 								13/05/21 00:55:16 					System is operational
           00:55:16.674762  34-08072-00 								Event number 34-08072-00 (severity 0, category 10), occurred on	
                                        Thu May 21 00:55:16 2013, at 001-01 (Vproc 8192, partition 10,
­­­­­­­­­­­­­­                                        task 9450) in system lnxsmp6 in Module gtwgateway, version
                                        PDE:12r.00.00.00,TDBMS:12r.00.
                            34-08072-00
                            34-08072-00 				gtwsecurity.c @334 (50332208): Thu May 21 00:55:16 2013
                            34-08072-00 					tdgss library version: 12.0.0.0
                            34-08072-00
           00:55:16.675132  34-08072-00 								Event number 34-08072-00 (severity 0, category 10), occurred on
                                        Thu May 21 00:55:16 2013, at 001-01 (Vproc 8192, partition 10,
                                        task 9450) in system lnxsmp6 in Module gtwgateway, version
                                        PDE:12r.00.00.00,TDBMS:12r.00.
                            34-08072-00
                            34-08072-00 				gtwsecurity.c @376 (50332208): Thu May 21 00:55:16 2013
                            34-08072-00 				tdgss supported methods: TD1
                            34-08072-00
           00:55:16.675308  34-08072-00 								Event number 34-08072-00 (severity 0, category 10), occurred on
                                        Thu May 21 00:55:16 2013, at 001-01 (Vproc 8192, partition 10,
                                        task 9450) in system lnxsmp6 in Module gtwgateway, version
                                        PDE:12r.00.00.00,TDBMS:12r.00.
                            34-08072-00
                            34-08072-00 					gtwsecurity.c @376 (50332208): Thu May 21 00:55:16 2013
                            34-08072-00 				tdgss supported methods: TD2
                            34-08072-00
           00:55:16.675465  34-08072-00 								Event number 34-08072-00 (severity 0, category 10), occurred on
                                        Thu May 21 00:55:16 2013, at 001-01 (Vproc 8192, partition 10,
                                        task 9450) in system lnxsmp6 in Module gtwgateway, version
                                        PDE:12r.00.00.00,TDBMS:12r.00.
                            34-08072-00
                            34-08072-00 				gtwsecurity.c @376 (50332208): Thu May 21 00:55:16 2013
                            34-08072-00 				tdgss supported methods: ldap
                            34-08072-00
           00:55:17.162739  34-02900-00 								13/05/21 00:55:17 Users are logged on
           00:55:17.162969  34-02900-00 								13/05/21 00:55:17 Logons are enabled
 
 *** Echo accepted.