New ways to obtain server message window contents A new system procedure, sa_get_server_messages, and three new properties, MessageText, MessageTime, and MessageWindowSize, return information from the server window.
For more information about sa_get_server_messages, see Adaptive Server Anywhere SQL Reference. For more information about MessageText, MessageTime, and MessageWindowSize properties, see Adaptive Server Anywhere Database Administration Guide.
Server log name is consistent for all platforms The default server log name on Windows has been changed to server.###.srvlog to be consistent with the name on UNIX platforms. Previously the prefix on Windows was .svrlog.
Improved debugging server log The information logged in the connection debugger has been improved to give more context about the portion of the connection being attempted; to remove the CONN: prefix; to increase the number of TCP/IP messages.
Request log filtering, host variable support Output to the request-level log can now be filtered to include only requests from a specific connection or for a specific database. As well, host variable values can now be output to a request log.
For more information, see “sa_server_option system procedure” in Sybase IQ Reference Manual, and -zr server option in “Starting the database server,” in Sybase IQ Utility Guide. See also “sa_get_request_profile system procedure,” “sa_get_request_times system procedure,” and “sa_statement_text system procedure” in Adaptive Server Anywhere SQL Reference.
The request-level log file size can be changed without restarting the database server On starting the database server, you can specify the size of the request-level log file with the -zs server option. You can use the sa_server_option system procedure to change the size of the request-level log file without restarting the database server.
For more information, see “Starting the database server” in Sybase IQ Utility Guide and “sa_server_option system procedure” in Sybase IQ Reference Manual.
Suppress TDS debugging option The SUPPRESS_TDS_DEBUGGING option controls whether TDS debugging information appears in the server window. For more information, see “SUPPRESS_TDS_DEBUGGING option” in Sybase IQ Reference Manual.
Performance messages now display database name (behavior change) The engine performance advice messages now display the database name. Messages starting with the word Note indicate that they are advice messages.
