Utility Statements › PRINT LOG › Examples

Examples

Printing everything except dumps

The following PRINT LOG statement requests printing of all messages, statistics, and user traces currently in the data dictionary log area.

print log from database
   messages
   statistics
   traces;

Printing all information for a specified time period

The following PRINT LOG statement requests printing of all information recorded in the system log from January 18, 1999, at 8:00 p.m. until just before 3:00 a.m. on January 19, 1999. The PRINT LOG utility will retrieve this information from the archive log file.

print log from archive
   start at '1999-1-18-20.00.00'
   stop at '1999-1-19-02.59.59.999999';

Printing user traces for a logical terminal

The following PRINT LOG statement requests printing of all user traces for logical terminal LTVTM05 beginning at 2:30 p.m. on the current day. The PRINT LOG utility will retrieve this information from the data dictionary log area.

print log from database
   traces
   for ltvtm05
   start at '14.30.00';