Appropriate Content: Informix Documentation Team
Tom Rieger created this excellent video about how great Informix is. Learn about how pervasive Informix is, how easy it is to administer, and many cool features that have been added in recent years. This video is a great introduction to Informix, but also a great reminder for those of us who already believe.
It's worth a watch!
Thanks to Fernando Nunes for blogging about this first.
IngeHalilovic 060000MPB8 Tags:  manager connection oat transactions spl database server features xid timeseries high-availability genero fixpack cluster administration warehouse informix inout 1,600 Visits
Here's a summary of the IBM® Informix® 11.70.xC6 new features:
· · Enhancements to the OpenAdmin Tool (OAT) for Informix
· · Support for the same XID for transactions on different databases
· · Coordinating transactions within a high-availability cluster
· · Easier failover configuration for Connection Managers in a high-availability cluster
· Application development
· · Enhanced support for OUT and INOUT parameters in SPL routines
· · Additional functions for spatial data
· · Return the default values of columns
· · SPL routines for application compatibility
· Time Series data
· · Load time series data faster through a virtual table
· Data warehousing
· · Refresh dimension-table data without reloading the whole data mart
The What's new in Informix topic has short descriptions of each of these features and links to more information.
Also, we've added some interesting links to the portal topics in the information center (those are the top-level nodes in the left-side navigation pane). We've split up SQL, client API, and Informix Genero® information into separate nodes to make it easier for you to find what you need.
Take a look at this new RedBook®: Solving Business Problems with Informix TimeSeries. Even if you don't have time series data, this books is worth a read through because it shows how truly innovative IBM® Informix® is.
The book provides a lot of excellent practical information on how to use the Informix TimeSeries technology, and also has a couple of real-world examples of how the Informix TimeSeries solution can be used in the energy and utilities industry, complete with graphs about the space savings and application code examples.
I've been following the Discover Informix events that Louis announces on his blog: http://louistcherian.wordpress.com/. The session yesterday was in Singapore as part of a series of visits to the ASEAN region.
Did you know that, because our product serves a global audience, we offer Informix documentation in various languages? Check out the following links to find documentation in your preferred language and delivery format:
HTML (Information Center): http://ibm.biz/BdxiNW
PDF (books): http://ibm.biz/BdxiN6
AnaB 110000H1JJ 769 Visits
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.
IngeHalilovic 060000MPB8 Tags:  information_center search documentation database informix 1,329 Visits
If you use an external search engine to find Informix® documentation and get hits in information centers, make sure you go to the right information center. For example, often topics in the information center for Informix version 10 are listed before topics in the later information centers. That's because the version 10 information center has been around longer and had more hits. For example, if you search for "Informix create table" you'll get a couple of version 10 information center topics right at the top, but no topics from the version 11.70 information center on the first page of results.
To find the right documentation for your Informix version, put the major version number in the search string, for example: "Informix create table 11.70". Note that "11.70" works better than just "11.7".
Here's why you should look at later information centers instead of version 10:
So how can you tell which information center a search hit is in? Look at the URL: each one has a version number in it:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/...: Version 10 information center (out of service since September 2010)
http://publib.boulder.ibm.com/infocenter/idshelp/v111/...: Version 11.10 information center (going out of service in September 2012)
http://publib.boulder.ibm.com/infocenter/idshelp/v115/...: Version 11.50 information center
http://publib.boulder.ibm.com/infocenter/idshelp/v117/...: Version 11.70 information center
You can tell which information center you are in by looking at the title on the browser tab and the first item in the navigation tree:
If you're in the version 10 information center, you'll also see this very conspicuous header at the top of every page:
If you find yourself in the wrong information center, the links to all the others are on the home page of every Informix information center.
This week I spent some time in email conversation with a customer and Erika about installing OAT on 64-bit Windows. I wanted to share with you what I learned.
You probably already know that since 11.70.xC4, you can install OAT when you install the IBM Informix Client Software Development Kit. This option is available on Windows 32-bit, Linux 32-bit and 64-bit, and MAC OS 64-bit operating systems.
You can also install OAT on 64-bit Windows, but it can be a little trickier. OAT is not part of the 64-bit Windows Client SDK. To get OAT on Windows 64, use the installation program for the 32-bit Windows Client SDK with these important additional steps from Erika!
1. First, review this topic: Verify system requirements (Windows). As described in this topic, you need to set the PATH to include the SysWOW64 folder before running the 32-bit installer on 64-bit Windows. One added note: In the first step, open the command prompt as Administrator.
2. Equally important! OAT requires that the installation directory does not contain any special characters. So the default "C:\Program Files (x86)\" directory for 64-bit Windows does not work because of the parenthesis. Choose a different installation location.
With that in mind, you can download and install the 32-bit Windows Client SDK. For even more information about installing OAT, including the prerequisites, see Installing the OpenAdmin Tool for Informix with the Client SDK.
When OAT is successfully installed, an OAT item is added to the Windows Start menu.
Another resource that you might find helpful is the OpenAdmin Tool forum at www.iiug.org/forums/oat. It's sponsored by the International Informix Users Group (IIUG), not IBM, but the OAT team follows it.