Server Location [dblocate] utility enhancements The Server Location [dblocate] utility now allows you to supply a host name or IP address to limit the search for database servers to a specific machine. As well, it supports a -n option that specifies that IP addresses are not to be resolved into machine names, which results in better performance.
For more information, see “The Server Location utility (dblocate)” in Sybase IQ Utility Guide.
WAITFOR statement This statement delays processing for the current connection for a specified amount of time or until a given time. For more information, see “WAITFOR statement” in Sybase IQ Reference Manual.
Suppress warnings on fetch operations The database server returns a wider range of fetch warnings than earlier versions. The ODBC configuration dialog allows you to suppress warning messages returned from the database server to ensure that they are handled properly for applications that are deployed with earlier versions of the software.
For more information, see “Configuring ODBC data sources” in Sybase IQ System Administration Guide.
Connectivity sample programs Sybase IQ now installs sample programs formerly in the cxmp directory in samples/asa/c. The samples in this directory illustrate using ESQL and C with Adaptive Server Anywhere. Because Adaptive Server Anywhere and Sybase IQ share common code, the samples can be adapted for use with IQ.
Connections persist across hibernation times Connections from embedded SQL, ODBC or OLE DB clients now persist while a computer hibernates. Previously, TCP/IP connections between a client and a server on the same machine would be dropped when the machine was woken from hibernation if the machine hibernated for longer than the liveness or idle timeout time.
RAISERROR statement allows connections to be disallowed This statement can now be used to disallow or limit connections. For more information, see Chapter 6, “SQL Statements” in Sybase IQ Reference Manual.
New connection limit (behavior change) The database server now allows one extra DBA connection above the connection limit, to allow a DBA to connect and drop other connections in case of an intentional or accidental denial-of-service.
For more information, see “Starting the database server” in Sybase IQ Utility Guide.
Enhanced dbping The dbping utility has additional options to help diagnose connection problems. These include the ability to use ODBC to connect, and the ability to report connection, database, and server properties upon connection.
For more information, see “The Ping utility (dbping)” in Sybase IQ Utility Guide.
DEDICATED_TASK option When specified, a request handling task is dedicated to handling requests from a single connection. This pre-established connection allows you to gather information about the state of the database server if it becomes otherwise unresponsive. For more information, see “DEDICATED_TASK option” in Sybase IQ Reference Manual.
Client can specify idle timeout Each client can specify its own idle timeout using the IDLE
connection parameter. Previously, all connections to a server used
the same idle timeout. The -ti server
command line option, which defaults to 4400 in start_asiq,
continues to specify the default idle timeout for the server.
For more information, see “Idle connection parameter [IDLE]” in Sybase IQ System Administration Guide.
New server and connection properties The new IdleTimeout server property returns the default idle timeout value.
Two new connection properties have also been added. LivenessTimeout returns the liveness timeout of the connection, and IdleTimeout returns the idle timeout of the connection.
For more information, see Adaptive Server Anywhere Database Administration Guide.
NetBios unsupported (behavior change) The NetBios port is no longer supported. If you use NetBios, you should switch to TCP/IP.
IPX unsupported (behavior change) The IPX port is no longer supported. If you use IPX, you should switch to TCP/IP.
