- Automatic read-ahead operations
- Configuring the server response to low memory
- Reserving memory for critical activities
- Connection Manager enhancements
- Enhancements to the OpenAdmin Tool
- Managing message logs in embedded and enterprise environments
- Built-in SQL compatibility functions for string manipulation and trigonometric support
- Client SDK includes the DB-Access utility
- High availability clusters and Enterprise
- Automatically connecting to a grid
- Code set conversion for Enterprise Replication
- Enhancements to the Informix Replication plug-in for OAT
- Non-root installations support shared-memory and stream-pipe connections
- Retaining numbers for audit log files
- Restrict operating system properties for mapped users
- Time Series data
- Simplified handling of time series data
- Informix TimeSeries plug-in for OAT
Appropriate Content: Informix Documentation Team
IngeHalilovic 060000MPB8 Tags:  oat informix memory enterprise_replication utf8 warehouse connection_manager dbaccess readahead grid low_memory timeseries audit 3,948 Views
The Informix® 11.70 information center has been updated with 11.70.xC3 information!
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:  information_center migration administration embeddability programming warehouse portal informix extensibility 4,123 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!
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.
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.
IngeHalilovic 060000MPB8 Tags:  replication database server features oat memory embeddability gskit event_alarms informix 4,091 Views
IBM® Informix® 11.50.xC9 is the ninth release of 11.50, and yet, it has new features! Here's a summary:
If you have version 11.70xC3, you can enable the database server to use read-ahead operations automatically to improve performance. Automatic read-ahead requests for pages to be brought into the bufferpool cache during sequential scans of data records improves the performance of a query, including OLTP queries and index scans, when the server detects that the query is encountering I/O.
You use the new AUTO_READAHEAD configuration parameter to configure automatic read-ahead operations for all queries, and use the SET ENVIRONMENT AUTO_READAHEAD statement to configure automatic read-ahead operations for a particular session. For more information, see Automatic read-ahead operations.
Note: View the prior blog entry for a list of new Version 11.50xC9 features!
If you upgrade to either version 11.70xC3 or 11.50xC9 of IBM Informix, you can:
Ever wonder what to do when you got a severity 4 event alarm? For IBM® Informix® 11.50.xC9, we added descriptions, server states, and user actions for severity 4 and 5 event alarms to the Administrator's Reference.
Are you familiar with IBM® Informix® Warehouse Accelerator, which comes with the IBM Informix Ultimate Warehouse Edition? If not, check out the two video demos that were recently announced on the Informix Warehouse Accelerator blog.