17.10 - Example: Creating a Software_Event_Log Copy for a Specific Date - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
Language
English (United States)

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.