Ibm Informix Dynamic Server 11.50 Downloadl
Zee Badoni
If you are migrating from a Dynamic Server release earlier than Version9.4, please refer to the 9.4 release notes (and to the release notes for otherreleases subsequent to the version from which you are migrating) for informationabout features added or modified before Version 10.0. Release notes for DynamicServer, Version 9.4 are available at:
THIS DOCUMENT IS SUBMITTED TO RECIPIENT IN CONFIDENCE. INFORMATION CONTAINEDHEREINMAY NOT BE USED, COPIED OR DISCLOSED IN WHOLE OR IN PART EXCEPT AS PERMITTEDBY WRITTEN AGREEMENT SIGNED BY AN OFFICER OF IBM SOFTWARE, INC. THIS MATERIALIS ALSO COPYRIGHTED AS AN UNPUBLISHED WORK UNDER SECTIONS 104 AND 408 OF TITLE17 OF THE UNITED STATES CODE. UNAUTHORIZED USE, COPYING OR OTHER REPRODUCTIONIS PROHIBITED BY LAW. THIS PRODUCT INCLUDES CRYPTOGRAPHIC SOFTWARE WRITTENBY ERIC YOUNG (e...@mincom.oz.au).
IT IS PROVIDED BY ERIC YOUNG "AS IS" AND ANY EXPRESS OR IMPLIEDWARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITYAND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THEAUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENTOF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESSINTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANYWAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OFSUCH DAMAGE.
The content of the release notes has changed forVersion 9.40 and later. Some information that was typically included in therelease notes is now included in the manuals and documentation notes. Youshould still review these notes, however, for critical information.
The International Informix User Group (IIUG) runs a web site ( ) which, amongst other things, supports a SoftwareArchive ( ). The SoftwareArchive contains the source code for a lot of utilities that might be of interestto you as you use IBM Informix Dynamic Server. You need to be a member ofthe IIUG to obtain the software, but membership is free.
TRUNCATE is a SQL keyword that quickly deletes active rows from a tableand the b-tree structures of its indexes. The active rows are deleted withoutdropping the table or its schema, access privileges, triggers, constraints,and other attributes. With TRUNCATE TABLE, you can de-populate a localtable and release (or reuse for the same table) the storage space that formerlyheld its data rows and b-tree structures. For more information, see the Guide to SQL: Syntax.
The cdr check replicate and cdrcheck replicateset commands check for consistency within replicates,and optionally, repair inconsistent rows. For more information, see the Enterprise Replication Guide.
The cdr sync replicate and cdr syncreplicateset commands perform direct synchronization between a referenceserver and one or more target servers. For more information, see the Enterprise Replication Guide.
The SECURITY_LOCALCONNECTION configuration parameter enables a databaseserver administrator (DBSA) to set up security checking for local connectionswith the same host. For more information, see the Administrator'sReference.
The DB_LIBRARY_PATH configuration parameter allows you to specify a comma-separatedlist of valid directory prefix locations from which the database server canload external modules, such as DataBlade modules. You can use DB_LIBRARY_PATHto control the location from which shared objects can be loaded, and it allowsyou to enforce policies and standards on the formats of the EXTERNAL NAMEclause of the CREATE FUNCTION, CREATE PROCEDURE, and CREATE ROUTINE statements.For more information, see the Administrator's Reference.
The new BAR_SORT_DBS environment variable can improve the efficiency ofbackup and restore operations whose scope is not the whole system. This environmentvariable implements new sorting methods for parallel dbspace backup and restore.BAR_SORT_DBS takes effect if it is set to any value. You can preserve the(less efficient) legacy behavior of backup and restore operations by not settingBAR_SORT_DBS.
In DB-Access, using the -a command-line optionwill stop a process directly after the first error is encountered. Stoppinga process from continuing after the first error ensures greater database consistency.For more information on DB-Access, see the DB-AccessUser's Guide.
The default value of the IFX_EXTEND_ROLE configuration parameter is changingfrom 0 to 1. The new default is more restrictive so that only administratorsor users who have been granted extend role by administrators can registerexternal routines.
Distributed queries that use ANSI-compliant JOIN syntax for specifyingjoined tables, execute more efficiently in Informix Dynamic Server 10.00.xC3than in earlier releases, this is achieved by sending the remote joined tablesas one query instead of multiple queries for each remote table, to each participatingdatabase server for operations on local tables of those servers. If you revertfrom Dynamic Server 10.00.xC3 to an earlier release that does not supportthis implementation of the ANSI-compliant syntax, such queries might showreduced performance, because the Dynamic Server instance from which the queryoriginates performs the joins locally.
The Dynamic Server Transaction Manager recognizes XA-compliant externaldata sources, which can participate in two-phase commit transactions. Thetransaction manager can invoke support routines for each XA-compliant externaldata source that participates in a distributed transaction at a particulartransactional event, such as prepare, commit, or rollback. This interactionconforms 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.
The MQ DataBlade module provides mechanisms for data exchange between DynamicServer and queues managed by IBM Websphere MQ. For more information, see the IBM Informix Built-In DataBlade Modules User's Guide.
You can restrict which users can create Informix databases by setting theDBCREATE_PERMISSION configuration parameter in the ONCONFIG file. If you donot set DBCREATE_PERMISSION, all valid users can create databases. When youset DBCREATE_PERMISSION, only user informix and theusers whom you specify are allowed to create databases. For more information,see the chapter on security in the IBM Informix DynamicServer Administrator's Guide and the Administrator'sReference documentation notes.
For Dynamic Server version 10.00.xC1, table-level restore supported allbuilt-in, BOOLEAN, and LVARCHAR data types for physical and logical restore. For Dynamic Server version 10.00.xC3, table-level restore also supports smartlarge objects for physical restore only (restore from level-0 archive). For more information, see the Backup and Restore Guide documentation notes.
The cdr stats rqm command displays information aboutthe reliable queue manager (RQM) queues used for Enterprise Replication. The cdr stats recv command displays receiver parallelism statisticsand latency statistics by source node. For more information, see the Enterprise Replication Guide documentation notes.
You can install IBM Informix CSDK with the Dynamic Server installationprogram. CSDK version 2.90.xC3 is included as part of the Dynamic Server version10.00.xC3 installation package. You can choose whether to install CSDK simultaneouslywith Dynamic Server or separately. For more information, see the IBM Informix Dynamic Server Installation Guide for UNIX and Linux.
New syntax enhancements support FIRST (and its new keyword synonym LIMIT)in the Projection clause, as well as the new SKIP keyword, which can excludea specified number of the first qualifying rows before saving the result setas a collection-derived table. You can also use host variables or local SPLvariables to specify the SKIP or FIRST parameters of queries in prepared objects.Before applying the FIRST and SKIP clause, the rows in the result set arenumbered starting from 1. This feature provides greater flexibility in SELECTand INSERT statements, and in web applications whose pages display disjunctsubsets of qualifying rows. For more information, see the IBM Informix Guide to SQL: Syntax.
Previous Dynamic Server releases did not support the ORDER BY clause incollection subqueries nor in conjunction with the FIRST keyword in the Projectionclause of collection subquery. Syntax enhancements now support the ORDER BYclause in the FROM clause of a SELECT statements that defines a collection-derivedtables. If the SELECT statement also includes any of the FIRST, LIMIT, orSKIP keywords in its Projection clause, the ORDER BY clause is applied toqualifying rows before the SKIP and FIRST specifications are applied to theresult set. For more information, see the IBM InformixGuide to SQL: Syntax.
You can use the new SQL statement, SET ENCRYPTION PASSWORD, to implementcolumn-level encryption to improve the confidentiality of the data. New built-infunctions provide methods for encrypting and decrypting data. The system catalogdoes not identify which columns contain encrypted data, and the same columncan include both encrypted and unencrypted values. This security enhancementfeature supports data confidentiality and data integrity.
The DBSA (Database Server Administrator) can use a new built-in role, calledEXTEND, to specify which users can register UDRs that include the EXTERNALNAME clause. User-defined routines use shared-object files that are externalto the database server and that could potentially contain harmful code. TheDBSA can use the GRANT statement to confer the EXTEND role on a user (typicallythe DBA of a local database), or can use REVOKE to withdraw that role froma user. The DBSA can disable this feature by setting to "off" a newIFX_EXTEND_ROLE configuration parameter. This feature is intended to improvesecurity and to control accessibility.
7fc3f7cf58