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).
|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.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|