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.