Appropriate Content: Informix Documentation Team
Simplify the process of adding storage space by configuring for the automatic expansion of the space
96QY_Pat_Smith 27000196QY 1,160 Views
If you upgrade to version 11.70, you can configure Informix to automatically expand an existing storage space when the space is full. You can also configure Informix to expand the space before it is full, when its free pages fall below a specified threshold. When you enable and configure automatic storage provisioning, you do not need to manually add storage space to avoid out-of-space errors. Even if you prefer to add space manually, automatic storage expansion greatly simplifies the process of adding space, because you do not need to determine where to get the space.
IngeHalilovic 060000MPB8 Tags:  configuration quick_reference informix onconfig onstat 2,454 Views
The Quick Reference Cards for onconfig.std and onstat have been updated for Informix 11.70. These cards are designed to be printed double-sided on legal-sized paper (8.5" by 14") and folded into a four-sided pamphlet. They look best printed in color, especially the onconfig.std card, which shows version numbers in red.
IngeHalilovic 060000MPB8 Tags:  highlights 11.7 database features information_center information informix 2,354 Views
Do you want to know exactly what's new for IBM® Informix® 11.70? Visit the new v11.70 information center.
For highlights of Informix 11.70, short descriptions of all the new features, and links to where the features are described in detail, see What's new in Informix.
Don't forget to subscribe to the RSS feed so that you'll know when we update the information center.
The v11.70 information center has the same collaboration features as the v11.50 information center. Find out how to comment on, rate, and watch topics.
The v11.70 information center works best with these browsers:
Basic text searching in Informix v11.50 became more versatile, configurable, and faster. See the What's New in Database Extensions for more information.
Process Multiple Basic Test Search Queries Simultaneously
If basic text search queries are slow because multiple users are running queries at the same time, you can add more BTS virtual processors so that queries run simultaneously, each in their own virtual processor. Previously, you could only create one BTS virtual processor and queries ran serially.
Control the Results of a Fuzzy Search with the Basic Text Search DataBlade® module
You can now specify the degree of similarity of search results in fuzzy searches when using the Basic Text Search DataBlade module. Specify a number between 0 and 1, where a higher value results in a higher degree of similarity. To limit results, specify a higher number. To maximize results, specify a lower number. The default degree of similarity is 0.5.
Map Characters for Indexing with the Basic Text Search DataBlade module
You can now map characters in your data to other characters during indexing with the Basic Text Search DataBlade module. For example, you can specify that letters with diacritical marks are indexed as the same letters without marks. You can also standardize inconsistent prefixes or delete character strings from indexed text. To use character maps, include the canonical_maps parameter when you create your bts index.
Default Boolean Operator in Basic Text Search Queries
You can now change the default Boolean
operator between search terms in Basic Text Search queries from OR to AND by
using the query_default_operator parameter when you create a bts index. The default
operator is represented by a blank space between terms. Many popular end-user
search engines use AND as the default operator between search terms, where
end-users expect the search results to contain all their search terms.
Storage for Temporary Basic Text Search Files
You can now specify that temporary files used by the Basic Text Search DataBlade module are stored in a separate sbspace from the one used to store the bts index. Separating temporary files from the bts index might improve query performance.
Track Basic Text Search Query Trends
You can now track what queries are run against your bts index by including the query_log parameter when you create a bts index. You can use query trends information to provide hints to end-users on popular queries or work on optimizing the most popular queries.
Fragment bts Indexes by Expressions
You can now fragment bts indexes by expressions into multiple sbspaces instead of a single sbspace.
Basic Text Search DataBlade module Supports High-Availability Clusters
You can now use the Basic Text Search DataBlade module to perform searches on high-availability cluster servers by creating indexes in sbspaces. Previously, the Basic Text Search DataBlade module only supported the creation of indexes in extspaces, and thus could not participate in any queries on high-availability secondary servers and in backup and restore operations.
Querying XML Attributes with the Basic Text DataBlade module
The Basic Text Search DataBlade module now supports searches on XML attributes in a document repository. The new all_xmlattrs parameter enables searches on all attributes that are contained in the XML tags or paths in a column that contains an XML document.
Support added for a user-defined stopword list
You can create a customized stopword list for frequently occurring words in your data or you can use the default stopword list.
Support added for XML-structured documents
You can use Basic Text Search XML index parameters to manipulate searches of XML data in different ways.
96QY_Pat_Smith 27000196QY 1,585 Views
For Version 11.50xC6 of IBM Informix, we added a new Migration Guide chapter on high-availability cluster migration. This information helps you coordinate the migration of all servers in a high-availability cluster or, if necessary, revert all servers in a cluster to the previous version of the server. Chapter topics include information on the additional steps you must perform when preparing to migrate, migrating, and reverting clusters.
If you use high-availability clusters, refer to the information when you upgrade to a new version of Informix, PID, or fix pack, migrate or, if necessary, when you revert to the previous version.
For more information, see High-availability cluster migration.