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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » What's new in version 16.0 » Administration tools new features


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.