Unix/Linux enhancements

  • New ODBC driver manager that can be used on Unix platforms   The libdbodm10 shared object can now be used on Unix platforms as the ODBC Driver Manager. Applications using the iAnywhere ODBC Driver Manager must restrict their ODBC reliance to version 3.0 and later. See Using the SQL Anywhere ODBC driver manager on Unix.

  • -uf server option   The -uf option allows you to specify the action taken by the database server when a fatal error occurs on Unix. See -uf server option.

  • Service utility now supported on Linux   The Service utility is now available for use on Linux to create, delete, list, start, and stop SQL Anywhere services.

  • Additional samples supported on Unix   The following SQL Anywhere samples are now supported on Unix:

    • DBTools   This sample is a database tools application that illustrates how to call and compile the database tools library by making a backup of the SQL Anywhere sample database.

    • DiskFull   This sample illustrates a sample Disk-Full Callback DLL.

    • HTTP   The samples in the HTTP directory demonstrate a variety of web service functionality, including how to use web services to set and retrieve client-side cookies within a SQL procedure, how to handle binary data within an HTTP web service procedure, how to use forms and HTML tables to display a simple calendar, how to use xp_read_file to retrieve images from the local disk and return them as the response to an HTTP request, and how to create, use, and delete HTTP sessions.

    • oemString   This sample shows you how to determine if a database file is set up for an OEM's software.

    • PerformanceFetch   This sample shows you how to use fetchtest to test fetch rates for an arbitrary query.

    • PerformanceInsert   This sample shows you how to use instest to test insert rates into a table.

  • Support for fibers on Linux (thread affinity) and improved concurrent processing   The SQL Anywhere for Linux database server introduces a new co-routine processing model similar to that of Windows fibers. This processing model enables the server more control over context switching between tasks/routines providing better affinity to database operations.

  • Direct I/O support for Linux   SQL Anywhere for Linux now supports the Linux 2.6 O_DIRECT feature, which can improve I/O performance because the file system does not cache the I/O.

  • Asynchronous I/O for Linux   SQL Anywhere for Linux now supports the Linux AIO feature that enables even a single application thread to overlap I/O operations with other processing improving IO performance.

  • Linux desktop GUI   SQL Anywhere for Linux now offers an optional desktop GUI for the personal database server, network database server, MobiLink server, MobiLink synchronization client, and SQL Remote. This GUI can be invoked with the -ui option if you have GTK libraries installed.

  • Linux desktop icons   SQL Anywhere for Linux now offers optionally installed icons for the Linux Desktop to improve the usability of starting and managing of database servers, Sybase Central, Interactive SQL, the SQL Anywhere Console utility, and the MobiLink Monitor for users running the Linux Desktop.

  • 64-bit client support for IBM AIX, HPUX, and Sun Solaris   SQL Anywhere client libraries are now available for the 64-bit memory model enabling you to take advantage of larger memory within your applications on IBM AIX, HP-UX, and Sun Solaris.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1