The new Informix Products information center
has all the documentation for older Informix server and CSDK versions, 4GL, DataBlade modules, and other tools.
Instead of clicking around over 2000 Pubs Library web pages, you can now find all the titles on one site!
To find the title you are looking for, just enter it in the search box in the upper left-hand corner and click Go.
URLs are now redirected to the new information center:
- all the pages under
Of course, the latest documentation is still on our more established information centers:
If you have any feedback on the new information center, please let us know!
Modified on by Joel_SF
Informix was recently ranked as number 10 in the top 20 in-demand mobile skills by job search site Dice.com. The site listed the top 20 search subjects that hiring managers and recruiters use when they request people with mobile experience (http://www.zdnet.com/top-20-mobile-skills-in-demand-7000023318/). This may be surprising news to some, considering that Informix is known for being a traditional RDBMS. However, with the introduction of Informix JSON support in 12.10.XC2, aimed specifically at mobile development support that leverages the MongoDB API, Informix is stronger than ever!
To learn more the Informix JSON capability, see these resources:
In IBM Informix 11.70.xC2, you have many more option for customizing basic text searching for your needs.
- You can improve the results of basic text
search queries by choosing a text analyzer that best fits your data and query
needs. A text analyzer determines how the text is indexed. The snowball analyzer
indexes word stems. The CJK analyzer processes Chinese, Japanese, and Korean
text. The Soundex analyzer indexes words by sound. Other analyzers are
variations of these analyzers and the standard analyzer. You can also create
your own analyzer.
- You can create a thesaurus of synonyms to
use during indexing.
- You can specify different stopwords for
each column being indexed instead of using the same stopwords for all indexed
- You can query each column in a composite
- You can increase the maximum number of
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
ON boats(xml_data bts_lvarchar_ops)
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
CREATE INDEX books_bts ON books(book_data bts_lvarchar_ops)
Modified on by jasna
Consider subscribing to the following Informix channels on YouTube to learn more about our technology and how you can benefit from it.
IBM Informix Channel (https://ibm.biz/InformixVideos):
This channel was introduced this week. Currently it contains videos about the role Informix can play for data management in the Internet of Things (IoT). I'm told more videos will be coming soon about other areas, such as cloud, NoSQL, and hybrid capabilities for combining structured and unstructured data.
IBM Informix Genero Channel (https://ibm.biz/InformixGeneroChannel):
IBM Informix Genero is an application development environment that provides easy, graphical tools for accelerating a new generation of mobile and cloud-based applications. This channel includes demos about using Informix Genero to modernize Informix 4GL applications quickly and efficiently.
IBM OpenAdmin Tool Channel (https://ibm.biz/ifxoatvideos):
The IBM OpenAdmin Tool (OAT) for Informix is a web application for administering and analyzing the performance of Informix database servers. This channel includes demos about what's new in recent releases of OAT, as well as demos about how to accomplish specific things by using the tool (such as automating Informix backups and administering Informix Warehouse Accelerator).
IBM Informix Marketing Channel (https://ibm.biz/InformixMarketingVideos):
For a higher-level view of what Informix has to offer, check out the Marketing videos, which highlight Informix technologies and products.
Did you know that multiple forums and wikis are available to the IBM Informix community, including users and developers, to share information, solutions to problems, and new ideas? For a list and description of these, see Forums and wikis
in the Version 11.70 Information Center.
With IBM® Informix® version 12.10.xC5, the powerful and flexible basic text searching feature is now available for Linux on IBM Power Series and IBM zSeries machines:
- IBM Power Series 64-bit with Red Hat Enterprise Linux ES releases 5.3, 6, and 7, and SUSE SLES 11
- IBM zSeries 64-bit with Red Hat Enterprise Linux ES releases 5.3 and 6, and SUSE SLES 11
If you're not already a fan of basic text search, here's some of the reasons why you should be:
- You have precise control over what data is indexed for text searches. You can index any type of text data, including XML or JSON documents.
- You control how the data is indexed by choosing an analyzer, and creating synonyms and stopwords.
- You can run word, phrase, Boolean, proximity, and fuzzy searches.
Find out more: basic text searching.
If you upgrade to either version 11.70xC3 or 11.50xC9 of IBM Informix, you can:
- Configure the actions that the server takes to continue processing when memory is critically low. You can specify the criteria for terminating sessions based on idle time, memory usage, and other factors so that the targeted application can continue and avoid out-of-memory problems. Configuring the low memory response is useful for embedded applications that have memory limitations.
- Reserve memory for use when critical activities (such as rollback activities) are needed and the server has limited free memory. If you reserve memory, the critical activities can complete even when you get out-of-memory errors.
For more information, see "What's New in Informix" topic in the 11.70xC3 Information Center or the 11.50xC9 Information Center.
In Version 11.50 and previous releases, each user who needed to access the database server also needed an operating system account on the host computer. With version 11.70, you can configure Informix so that users who are authenticated by an external authentication service (such as Kerberos or Microsoft Active Directory) can connect to Informix. The USERMAPPING configuration parameter specifies whether or not such users can access the database server, and whether any of those users can have administrative privileges.
In a little under two weeks, I’ll head down the coast for San Diego and IIUG. I’m seriously looking forward to meeting
Informix customers and developers from around the world, and running sessions
in the Informix Usability Sandbox.
The sessions we have lined up are going to be good ones, and
I can’t wait to sit down with other IIUG members and hear what they have to say
about the new 12.10 release, and where they would like to see Informix go in
Sessions will include:
Usability testing of the new Mobile
OAT application, fresh off of the 12.10 release. Users can try Mobile OAT out
and tell us what they think, and show us how we might make improvements in the
future. We’ll also be discussing the
latest changes to OAT, and what might be done for any future development.
Discussions on Informix-related media. When does the Info Center
work for users, and when does it not work? How about videos? How about these
blog posts? We want to figure out the best ways to connect users to the
information they want and need.
Informix and mobile. The singularity might or might not be coming
soon, but either way, Informix is going places. We want to figure out where
untethered Informix might end up. It’s
going to be an excellent opportunity for Informix users to shape the
For those of you attending, I’ll be in (the room) Santa Fe 3, April 22-24th, for scheduled sessions between the hours
of 9am and 5pm each day. Otherwise,
I’ll be out shaking hands and meeting other IIUG members. Sign up for a session and/or be ready to
shake my hand.
IIUG members will be able to sign up for sessions at the
conference IBM Information Table. But anyone can also drop me a line (firstname.lastname@example.org) to set up
some time to talk. Comments or conversations,
all are welcome!
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
Modified on by IngeHalilovic
One of the great features of the IBM Knowledge Center is that you can create PDF versions of any documentation you want. First you create a collection of topics that you want to be in the PDF.
To create a PDF from the Knowledge Center:
1. Sign in to the Knowledge Center with your IBM ID. The Sign In button is in the upper right corner of the black title bar.
2. In the navigation pane, click the topic that you want to add to a collection. The subtopics are also added to the collection, but you can edit the collection to remove the topics that you don't want.
3. Choose an option from the Add to collection menu, in the upper right above the topic:
4. If you chose a new collection, enter a name. Otherwise, choose an existing collection name.
5. Click My Collections at the bottom of the navigation pane to see your collections.
6. Select the collection in the navigation pane and click Create PDF File. Note: Only the first 1000 topics are included in the PDF.
The PDF is created. You have about an hour to download it before it disappears.
With version 11.70, you can see which tables have outstanding in-place alter operations. (Tables that have outstanding in-place alter operations can cause a slight performance degradation.)
Each table with an outstanding in-place alter operation has an informative alert row in the ph_alert table in the sysadmin database. For more information, see In-place alter in the IBM Informix 11.70 Information Center, or see information on the Alerts page of the Health Center in the IBM OpenAdmin Tool for Informix .
Modified on by IngeHalilovic
You might have noticed that all IBM® Informix® online documentation for version 12.1, 11.7, and 11.5 is now in IBM Knowledge Center. The search functionality of IBM Knowledge Center is significantly better than the search in the information centers, but sometimes it works a bit differently than you might expect.
In IBM Knowledge Center search, the hyphen character means "exclude this term". To include an item that has a hyphen in your search, you must quote it; for example:
"onstat -g ses"
onstat "-g" ses
If you don't quote it, you'll get a helpful "Did you mean: ..." note:
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
Modified on by IngeHalilovic
IBM® Informix® version 12.10.xC1 added support for grid queries. A grid query selects data from multiple servers in a grid and consolidates the results. After you define a grid and designate which tables can be used in grid queries, all you have to do is identify the grid name with the GRID keyword in the FROM clause of a SELECT statement. The query then runs on all the grid servers.
The result of a grid query are qualifying rows from a logical UNION or UNION ALL of each table in the FROM clause across tables with the same names and the same schema in every grid server. This union can include tables across all nodes in the grid, or across a subset of those grid nodes, called a region.
So how useful are grid queries? Check out this example.
The following example is based on the stores_demo database. A grid named grid1 has eight servers, named store1 through store8. The example assumes that you defined the items, orders, and customer tables as grid tables.
Suppose you want the total sales and number of sales for each customer across all stores. You use subquery to return information by grid server. The main query aggregates the results of the subquery.
You run the following statement to return the total sales and number of sales per person:
SELECT fname, lname,
SUM(tot_amt) AS amt_by_person, SUM(tot_cnt) AS tot_by_person
SELECT c.fname, c.lname, ifx_node_name() AS node,
SUM(i.total_price) AS tot_amt, SUM(i.quantity) AS tot_cnt
FROM items i, orders o, customer c GRID ALL 'grid1'
WHERE i.order_num = o.order_num
AND o.customer_num = c.customer_num
GROUP BY 1,2
GROUP BY fname, lname
ORDER BY 2, 1;
The ALL keyword in the GRID ALL 'grid1' clause indicates that duplicate results are allowed.
The query returns the following results:
fname lname amt_by_person tot_by_person
Alfred Grant $336.00 20
Marvin Hanlon $1752.00 40
Anthony Higgins $5807.20 135
Roy Jaeger $5560.00 50
Fred Jewell $2336.00 50
Frances Keyes $1800.00 10
Margaret Lawson $1792.00 110
. . .
Look at other grid query examples.
Find out all about grid queries.
Explore the syntax for grid queries.