* New context variables have been added to the SYSTEM namespace to retrieve more information about the current connection and current transaction. The added variables: SYSTEM::CLIENT_PID and SYSTEM::CLIENT_PROCESS for the current connection, SYSTEM::LOCK_TIMEOUT and SYSTEM::READ_ONLY for the current transaction.
* Some limits have increased:
- The maximum number of connections on Windows for Superserver and Superclassic has been raised from 1024 to 2048 connections.
- The maximum number of input parameters for external functions (UDFs) has increased to 15.
* Error reporting improvements, including:
- More details are now reported for “object in use” errors.
- The relation name is now added to the text of validation constraint error messages, to help identify the error context.
- Error reporting for index and constraint violations has been extended to include the problematic key value.
* Physical backup (using ALTER DATABASE BEGIN/END BACKUP or the nBackup utility) was improved to speed up extension of the main database file when backup state changes from stalled to merge.
- Contention for the allocation table lock while a database is in the stalled physical backup state has been reduced.
- Faster file growth has been enabled on Linux systems that support fallocate().
- Attachments no longer block others when the allocation table is being read for the first time.
* Execution of a SET STATISTICS INDEX statement no longer blocks or slows down concurrent attachments.
* The scan for limbo transactions at the end of a sweep has been improved.
* Support for the UPDATE OR INSERT statement and the RETURNING clause have been implemented for Embedded SQL (ESQL).