OpenEdge database log file

The OpenEdge database log is a text file that contains a history of significant database events and parameter settings, such as:
  • Date and time of startup and shutdown
  • Utility activities
  • System error messages
  • Startup parameter and secondary broker parameter settings
  • Code page, collation, and word-rule settings

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 1. 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.