Appropriate Content: Informix Documentation Team
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 762 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,275 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.
SusanB 270001KYS8 Tags:  administration alarms advisor health informix oat reports performance 1,343 Visits
Did you know that you can monitor and analyze the state and performance of your Informix® database server, and send automatic email alerts, by using the Health Advisor plug-in for the OpenAdmin Tool (OAT)?
At the next Informix Chat with the Lab, my colleague Erika Von Bargen, IBM Software Engineer and OAT programmer par excellence, will present a deep dive into the Health Advisor plug-in. She will cover how the plug-in works and how to use it in OAT. She will also explain how you can add your own health checks and alarms.
Come and join us for the chat. You can register at:
The Health Advisor plug-in was first available with OAT 2.74, which was released with Informix 11.70.xC4. The Health Advisor plug-in works with Informix 11.50 and later. For more information about the Health Advisor plug-in, see Informix Health Advisor Plug-in for OAT.
After upgrading to a new version of the database server and backing up the new server, you can tune the server to maximize performance. If your queries are slower after the upgrade, find out what changed that affects your configuration and adjust your configuration and queries as necessary:
More tips and answers to frequently asked questions are in the Frequently asked questions (FAQs) about IBM Informix section of the Version 11.70 Information Center.
Before version 11.70, database operations treated strings stored in all Informix databases as case-sensitive. For example, a query for the string "Central" returns "Central" but not "CENTRAL" or "central". Operations designed to disregard the case of text strings required a bts index or a functional index for each query.
In version 11.70, a database is still created as case-sensitive by default. However, you can use the NLSCASE INSENSITIVE option with the CREATE DATABASE statement to create a database that ignores the case of text strings. For example, querying "Central" returns "Central", "CENTRAL", and "central".
A case-insensitive database ignores letter case only on NCHAR and NVARCHAR data types, but it treats the other built-in character data types (CHAR, LVARCHAR, and VARCHAR) as case-sensitive. You cannot include both case-sensitive and case-insensitive databases in a distributed query.
For more information, see Specifying NLSCASE case sensitivity.
IngeHalilovic 060000MPB8 Tags:  administration assertion_failure backup update_statistics informix prevention 1,338 Visits
In my previous entry, I gave some tips on how to correct assertion failures in the Informix® server. Obviously, the real goal is to prevent them in the first place!
Here are some things you should do on a regular basis that might prevent assertion failures:
To find out how and why each of these tasks can prevent assertion failures, read this topic: Prevent and prepare for assertion failures.
Of course, you should always be prepared for a catastrophic failure, so make sure you backup your data, logical logs, and your database and storage spaces schemas.