The SQL log entry type provides information on the preparation and execution of SQL queries on the MS SQL and Oracle databases in the server context at the following levels:
Note: ABL procedure and Line Numbers are logged using the -Dsrv "PRGRS_LOG_ABL" connection switch with the SQL log entry type at any level.
Level 2 (Basic) — Logs some server log information related to the legacy qt_debug,SQL option, and SQL query preparation.
Level 3 (Verbose) Logs the bind values if SQL uses Bind parameters and reports the "SQL CRC".
The Cursor log entry type is mapped to the legacy qt_debug,CURSOR option and provides information about use of cursors in the server context at the following levels:
Level 2 (Basic) — Logs all existing cursor messages mapped from the legacy qt_debug option and the new and basic information on cursor such as table-number and client-cursor ID or server-cursor ID.
Level 3 (Verbose) — Logs information on cursor status, reposition of cursor, index used, sort flags, usage of cursors (block, lookahead, fast, slow), cache type, fetch source/target, fetched records, and average buffer length.
The Trans log entry type provides server-side transaction information at the following levels:
Level 2 (Basic) — Logs messages when an SQL transaction begins or ends on the server. Logs information about the undone transactions on the MS SQL and Oracle databases.
Level 3 (Verbose) — Logs messages when a transaction (including the transaction level) begins or ends. Logs information about the undone transactions and sub-transactions.
Level 4 (Extended) — Logs messages about records locked in a transaction including the type of lock and lock upgrades.
The Connects log entry type provides the server-side connection related information at the following levels:
Level 2 (Basic) — Logs information pertaining to the -Dsrv switches such as lockwait timeout, transaction isolation level, etc. and the set parameters used on the connection. Logs all DataServer connection attributes established before the start and after the end of a session.
Level 3 (Verbose) — Logs reports on the additional connection attributes.
The Performance log entry type provides the performance related information in the server context at the following levels:
Level 2 (Basic) — Logs the time of call to the server-layer entry point functions. Logs the time spent on the DataServer server layer. This reports the session level time spent at the server layer.
Level 3 (Verbose) — Logs the relative time spent on the function call to that spent on the Dataserver server layer. This reports the session level time spent at the server layer.
Level 4 (Extended) — Logs time spent for the "individual roundtrip" at the server layer.
Level 2 (Basic) — Logs some server log information related to the legacy qt_debug,SQL option, and SQL query preparation.