IBM Informix Dynamic Server, Version 10.00.xC3 contains the following new 3features:
3Distributed queries that use ANSI-compliant JOIN syntax for specifying 3joined tables, execute more efficiently in Informix Dynamic Server 10.00.xC3 3than in earlier releases, this is achieved by sending the remote joined tables 3as one query instead of multiple queries for each remote table, to each participating 3database server for operations on local tables of those servers. If you revert 3from Dynamic Server 10.00.xC3 to an earlier release that does not support 3this implementation of the ANSI-compliant syntax, such queries might show 3reduced performance, because the Dynamic Server instance from which the query 3originates performs the joins locally.
3 3The Dynamic Server Transaction Manager recognizes XA-compliant external 3data sources, which can participate in two-phase commit transactions. The 3transaction manager can invoke support routines for each XA-compliant external 3data source that participates in a distributed transaction at a particular 3transactional event, such as prepare, commit, or rollback. This interaction 3conforms to X/Open XA interface standards. For more information, see the IBM Informix DataBlade API Programmer's Guide and the IBM Informix DataBlade API Function Reference.
3 3The MQ DataBlade module provides mechanisms for data exchange between Dynamic 3Server and queues managed by IBM WebSphere MQ. For more information, see the IBM Informix Built-In DataBlade Modules User's Guide.
3 3You can restrict which users can create Informix databases by setting the 3DBCREATE_PERMISSION configuration parameter in the ONCONFIG file. If you do 3not set DBCREATE_PERMISSION, all valid users can create databases. When you 3set DBCREATE_PERMISSION, only user informix and the 3users whom you specify are allowed to create databases. For more information, 3see the chapter on security in the IBM Informix Dynamic 3Server Administrator's Guide and the Administrator's 3Reference documentation notes.
3 3The previous default value of the DUMPDIR configuration parameter was the /tmp directory. The new default value of the DUMPDIR configuration 3parameter in the onconfig.std file is the more secure /usr/informix/tmp on UNIX and %INFORMIXDIR%\tmp on Windows. If the DUMPDIR configuration parameter is not in the ONCONFIG 3file, then the $INFORMIXDIR/tmp directory is used.
3 3For Dynamic Server version 10.00.xC1, table-level restore supported all 3built-in, BOOLEAN, and LVARCHAR data types for physical and logical restore. 3 For Dynamic Server version 10.00.xC3, table-level restore also supports smart 3large objects for physical restore only (restore from level-0 archive). 3For more information, see the Backup and Restore Guide documentation notes.
3 3The following AES ciphers are supported for network encryption:
3Network encryption is described in the chapter on security in the IBM Informix Dynamic Server Administrator's Guide.
3 3The cdr stats rqm command displays information about 3the reliable queue manager (RQM) queues used for Enterprise Replication. The cdr stats recv command displays receiver parallelism statistics 3and latency statistics by source node. For more information, see the Enterprise Replication Guide documentation notes.
3 3You can install IBM Informix CSDK with the Dynamic Server installation 3program. CSDK version 2.90.xC3 is included as part of the Dynamic Server version 310.00.xC3 installation package. You can choose whether to install CSDK simultaneously 3with Dynamic Server or separately. For more information, see the IBM Informix Dynamic Server Installation Guide for UNIX and Linux.
3 3New syntax enhancements support FIRST (and its new keyword synonym LIMIT) 3in the Projection clause, as well as the new SKIP keyword, which can exclude 3a specified number of the first qualifying rows before saving the result set 3as a collection-derived table. You can also use host variables or local SPL 3variables to specify the SKIP or FIRST parameters of queries in prepared objects. 3Before applying the FIRST and SKIP clause, the rows in the result set are 3numbered starting from 1. This feature provides greater flexibility in SELECT 3and INSERT statements, and in web applications whose pages display disjunct 3subsets of qualifying rows. For more information, see the IBM Informix Guide to SQL: Syntax.
3 3Previous Dynamic Server releases did not support the ORDER BY clause in 3collection subqueries nor in conjunction with the FIRST keyword in the Projection 3clause of collection subquery. Syntax enhancements now support the ORDER BY 3clause in the FROM clause of a SELECT statements that defines a collection-derived 3tables. If the SELECT statement also includes any of the FIRST, LIMIT, or 3SKIP keywords in its Projection clause, the ORDER BY clause is applied to 3qualifying rows before the SKIP and FIRST specifications are applied to the 3result set. For more information, see the IBM Informix 3Guide to SQL: Syntax.
3 3The J/Foundation component of Dynamic Server now includes JRE 1.4.2.
3 3The default value of the ADTPATH configuration parameter for Dynamic Server 310.00.xC3 and later on UNIX is the secure $INFORMIXDIR/aaodir directory, instead of the /tmp directory.
3 3The onstat commands that show SQL statement text 3being executed by a session are normally restricted to DBA users. This restriction 3can be removed by setting the UNSECURE_ONSTAT configuration parameter to 1. 3For example, the onstat -ses, onstat 3-stm, onstat -ssc, and onstat 3-sql commands show SQL statement text.
3