- Reserving memory for critical activities
- Configuring the server response to low memory
- Handle high severity event alarms
- Reserving space for BYTE and TEXT data in round-robin fragments
- Enhancements to the OpenAdmin Tool (OAT) for Informix
- IBM Informix TimeSeries Plug-in for OpenAdmin Tool (OAT)
- Application Development
- Comparing date and interval values
- Enterprise Replication
- Easier setup of faster consistency checking for Enterprise Replication
- Support for later versions of IBM Global Security Kit (GSKit)
Appropriate Content: Informix Documentation Team
IngeHalilovic 060000MPB8 Tags:  replication features server database oat memory gskit embeddability event_alarms informix 2,341 Views
IBM® Informix® 11.50.xC9 is the ninth release of 11.50, and yet, it has new features! Here's a summary:
You can enable the database server to automatically rotate and delete online, ON-Bar activity, and ON-Bar message log files, and you can specify the maximum number of these files to rotate. The Scheduler tasks that rotate and delete these message log files are useful for embedded applications, because they reduce DBA or system administrator requirements for managing the logs. For more information, see Manage message logs in an embedded environment.
With IBM Informix Version 11.70, you can't accidentally initialize disk space for an existing server by running the oninit -i command. Initializing disk space destroys all of the database data that the server manages. If you do want to initialize disk space for an existing server, you can set the FULL_DISK_INIT configuration parameter to allow the oninit -i command to succeed. For more information, see FULL_DISK_INIT configuration parameter in the Version 11.70 Information Center.
IngeHalilovic 060000MPB8 Tags:  information_center migration administration embeddability programming warehouse portal informix extensibility 1,863 Views
Recently we've added information portals to the Informix® 11.70 information center. Information portals have links to key documentation both within and outside the information center. For example, we'll include links to interesting developerWorks® articles and Redbook® publications. Most of these portals are the top level nodes in the left hand navigation pane of the information center.
Here are the ones we've done so far:
Let me know if you have suggestions for additions to these portals or other portals you would like to see!
Today is the 10th anniversary of the Informix acquisition by IBM. I'm very happy to be employed, and by a stable company like IBM! About half the current Informix doc team came over in the acquisition. What can I say--we're very loyal to Informix! One of the best things about working on Informix is working with a development team that is really passionate about their product.
One of the other best things about Informix is the amazing customers. Every time I talk, email, or just listen to a customer, I find it very valuable. IBM really emphasizes the importance of customer perspective in its writers, as well as an understanding of customer business needs and improving time to value. We all try very hard to translate the information about functionality that we get from development into a clear statement of customer value. Please keep the feedback coming!
This year, I feel like I've come a full circle with Informix. When I started at Informix almost 15 years ago, one of my first projects was working on the TimeSeries DataBlade documentation with Kevin Brown. It has always been one of my favorite parts of Informix to work on. But after that initial assignment, I didn't get many chances to work on the TimeSeries documentation again, until this year. With 11.70.xC3, the TimeSeries extension, as it is now known, has been significantly enhanced, and I was lucky enough to be able to do the documentation for it. The TimeSeries data type technology was very cool 15 years ago, but today it is really coming into focus as a solution for the ubiquitous monitoring of everything that seems to be happening these days. Here's a couple of case studies that I found particularly interesting:
Hildebrand solves a key problem in smart metering research
Coldset Printing Partners: The IBM Informix TimeSeries solution helps company track usage trends and analyze data over time
I'm looking forward to seeing what the next 10 years of Informix at IBM will hold!
IngeHalilovic 060000MPB8 Tags:  oat informix memory enterprise_replication utf8 warehouse connection_manager dbaccess readahead grid low_memory timeseries audit 2,198 Views
The Informix® 11.70 information center has been updated with 11.70.xC3 information!
I recently looked through the list of new DeveloperWorks articles and discovered an excellent article about how to use fragment-level statistics. Fragment-level statistics, which are a new IBM Informix version 11.70xC1 feature, affect the way UPDATE STATISTICS MEDIUM and HIGH operations gather data and generate column distributions on fragmented tables. For information on the circumstances under which you might want to use fragment-level statistics as well as details about setting up your system to use fragment-level statistics, see:
Incidentally, the DeveloperWorks article includes the following code example for forcing the use of fragment-level statistics. This example includes the new STATLEVEL property of a fragmented table. See the DeveloperWorks article and the Informix documentation for more details about the code:
CREATE TABLE tab1(col1 integer, col2 char(10))
96QY_Pat_Smith 27000196QY 848 Views
You can use MQ messaging functions to enable Informix applications to exchange data directly between the application and IBM WebSphere MQ. Applications can send and receive messages from local or remote queue managers that reside anywhere in the network and participate in a transaction.
IBM Informix Version 11.70 includes several new MQ messaging functions, which simplify administrative tasks and reduce the number of WebSphere MQ licenses that are needed.
For more information, see What's new in Database Extensions for IBM Informix, version 11.70 in the Database Extensions Users Guide.
IngeHalilovic 060000MPB8 Tags:  thesaurus database index informix analyzer stopword search text 1,616 Views
In IBM Informix 11.70.xC2, you have many more option for customizing basic text searching for your needs.
See the What's New for links to each of these features.
Here are a couple of examples:
The following example creates a bts index on two XML fields and uses a different analyzer for each field:
CREATE INDEX boats_bts
The following example creates stopword list of am, be, and are for all fields except the fields author and title, which have their own stopwords, and the field edition, which does not have any stopwords.
CREATE INDEX books_bts ON books(book_data bts_lvarchar_ops)
Each version of Informix supports new SQL keywords that are reserved words. The use of these words in your applications might affect the migration of your applications when you upgrade to a new version of Informix. If you haven't migrated to the new version and would like to see the new keywords, you can find them listed in the following IBM Informix Migration Guide appendix: New keywords of SQL
The Version 11.70 IBM Informix Guide to SQL: Syntax contains an alphabetic list of all keywords.