SQL Anywhere Console new features

Following is a list of new features introduced in version 16.0 for the SQL Anywhere Console.

Based on JRE 7 The SQL Anywhere Console utility (dbconsole) now uses and requires JRE 7 (Java Runtime Environment 1.7.0).

Enable request logging options In the Console tab on the Options window, the Enable request logging option now supports the following options:

Option	Description
Blocks	Enables logging of details showing when a connection is blocked and unblocked on another connection.
Host variables	Enables logging of host variable values. The information listed for SQL is also logged.
Plans	Enables logging of execution plans (short form). Execution plans for procedures are also recorded if Procedures is enabled.
Procedures	Enables logging of statements executed from within procedures and user-defined functions.
SQL	Enables logging of START DATABASE, STOP DATABASE, STOP SERVER, EXECUTE IMMEDIATE, COMMIT, ROLLBACK, and DROP STATEMENT statements, as well as statement preparation and execution, option settings, PREPARE TO COMMIT operations, connects and disconnects, beginnings of transactions, statements, cursor explanations, errors, and cursor open, close, and resume.
Triggers	Enables logging of statements executed from within triggers.
Other	Enables logging of additional request types not included by SQL, such as FETCH and PREFETCH. Specifying Other automatically enables SQL. Specifying Other can cause the request log file to grow rapidly and could negatively affect server performance.
Replace log file when logging starts	At the start of logging, the existing request log is replaced with a new (empty) one of the same name. Otherwise, the existing request log is opened and new entries are appended to the end of the file.

Discuss this page in DocCommentXchange.