Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Logged Data : OpenEdge database log file
 

OpenEdge database log file

The OpenEdge database log is a text file that contains a history of significant database events and parameter settings. The log file includes startup parameter settings, the date and time of startup and shutdown, system error messages, and utility and maintenance activity. This file has a .lg extension. Entries in the database log can help you trace events preceding database crashes.
The format of each entry in the database log file provides detailed information about the time the event occurred, the source of the event, and the text of the associated message and message number. A database log entry is formatted as follows:
[yy/mm/dd@hh:mm:ss.uuushhmm] P-nnnnnn T-nnnnnn S name nnn: (nnnnn) Message
The table below describes the fields of each entry in the log file. All fields, with the exception of the message text, have a fixed width.
Table 55. Database event log format
Field in log entry
Description
yy/mm/dd
Date in year/month/day format.
hh:mm:ss.uuu
Local time in hours, minutes, seconds, milliseconds.
shhmm
Time zone relative to GMT where s is a + or - and hhmm are hours and minutes. For example, a value of -0500 represents a time zone five hours behind GMT.
P-nnnnnn
The process id of the process that produced the message. The process id is blank for remote clients. Space is allocated for a maximum of 10 digits in the process id.
T-nnnnn
The thread id of the thread that produced the message. In Windows, thread ids are unique across a system; there is no implied relationship between a thread id and the thread's creation order. On UNIX, thread ids are unique to a process. The id of the main thread is 1, and additional threads will be numbered in order.
S
The severity level of the message. There are three possible values:
*I —Informational message
*W — Warning message
*F — Fatal message
name nnn:
User name and user number. These two items create single field to identify the source of the message. Possible values include: BROKER 0:, USR 5:, RPLS 5:, DBUTIL:, etc. Nine spaces are allocated for this field. The name portion is left justified and the user number is right justified.
(nnnnn)
The message number of the message. More details about the message can be obtained by accessing Help > Messages... from the OpenEdge Desktop.
Message text...
The text of the message.