LogFormat (LF) protocol option

Controls the format of messages written to the log file where the database server writes information about web requests, and specifies which fields appear in the messages.

Syntax

{ LogFormat | LF }=format-string

Allowed values

format-string The following codes are supported:
- @@ The @ character.
- @B Date and time that processing of the request started, unless the request could not be queued due to an error.
- @C Date and time that the client connected.
- @D Name of the database associated with the request.
- @E Text of the error message, if an error occurred.
- @F Date and time that processing of the request finished.
- @I IP address of the client.
- @J Log the client port specified by the @I option.
- @L Length of the response, in bytes, including headers and body.
- @M HTTP request method.
- @P Listener port associated with the request.
- @Q Date and time that the request was queued for processing, unless the request could not be queued due to an error.
- @R Status code and description of the HTTP response.
- @S HTTP status code.
- @T Date and time that the current log entry was written.
- @U Requested URI.
- @V Requested HTTP version.
- @W Time taken to process the request (@F - @B), or 0.000 if the request was not processed due to an error.

This protocol option controls the format of messages written to the log file that stores information about web requests and which fields appear in them. If they appear in the string, the current values are substituted for the codes as each message is written.

If the web request fails due to an unsupported HTTP request method or a URI that is either malformed or missing a required database name, the HTTP method (@M) and HTTP version (@V) returns the string ??? and the URI (@U) returns the given request preceded by >>>.

For example, if the log format is set to "@M @U @V", then an unknown HTTP method for the URL request/sample/test HTTP/1.0 returns the following:

"???>>>request/sample/test HTTP/1.0???"