LogOptions (LOPT) protocol option

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » Network protocol options

LogOptions (LOPT) protocol option

Specifies the types of messages that are recorded in the log where the database server writes information about web requests.

Syntax

{ LogOptions | LOPT }= [ NONE ] [, OK ] [, INFO ] [, ERRORS ] [, ALL ] [, status-codes ] [, REQHDRS ] [, RESHDRS ] [, HEADERS ]

Available protocols

Allowed values

The following keywords control which categories of messages are logged:

NONE Log nothing.
OK Log requests that complete successfully (20x HTTP status codes).
INFO Log requests that return over or not modified status codes (3xx HTTP status codes).
ERRORS Log all errors (4xx and 5xx HTTP status codes).
USER Log all errors (6xx, 7xx, 8xx, and 9xx HTTP status codes).
ALL Log all requests.

The following common HTTP status codes are also available. They can be used to log requests that return particular status codes:

C200 OK
C400 Bad request
C401 Unauthorized
C403 Forbidden
C404 Not found
C408 Request timeout
C501 Not implemented
C503 Service unavailable

The following keywords can be used to obtain more information about the logged messages:

REQHDRS When logging requests, also write request headers to the log file.
RESHDRS When logging requests, also write response headers to the log file.
HEADERS When logging requests, also write both request and response headers to the log file (same as REQHDRS,RESHDRS).

Default

Remarks

See also

Discuss this page in DocCommentXchange.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1