Appropriate Content: Informix Documentation Team
In Informix 11.70, each event alarm specific message has a unique ID instead of just a class number. This is especially important for a classes with many specific messages, like class 6, which has over 75 different messages with differing severities. You can now write scripts to handle event alarms based on the unique IDs instead of parsing the specific message text.
You can see all the event alarm messages in this one very large topic in the information center for 11.70: Event alarms IDs
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.
These URLs are now redirected to the new information center:
If you have any feedback on the new information center, please let us know!
96QY_Pat_Smith 27000196QY Tags:  informix database index update_statistics ustlow_sample statistics_low 11.70 1,898 Views
If you upgrade to IBM Informix Version 11.70xC4, you can generate index statistics based on sampling when you run UPDATE STATISTICS statements in LOW mode. For an index with more than 100 K leaf pages, the gathering of statistics using sampling can increase the speed of the update statistics operation.
To enable sampling, set the USTLOW_SAMPLE configuration parameter or the USTLOW_SAMPLE option of the SET ENVIRONMENT statement. For example, to enable sampling for the current session, specify:
SET ENVIRONMENT USTLOW_SAMPLE '1';
For more information, see USTLOW_SAMPLE configuration parameter or USTLOW_SAMPLE environment option.
For information about other new Version 11.70 features, see What's new in Informix.
96QY_Pat_Smith 27000196QY 1,867 Views
If you install version 11.50xC6 or a later version of Informix and then upgrade to another new Informix version or fix pack, you can enable the server to use the onrestorept utility to restore the server to a consistent, pre-upgrade state if the upgrade fails. If you enable the server to use this utility, you can undo changes made during the upgrade in minutes (and in some cases, in seconds). Previously, if a fix pack upgrade failed, you had to restore the database by using a level-0 archive.
You use the new CONVERSION_GUARD and RESTORE_POINT_DIR configuration parameters, which are documented in the IBM Informix Administrator's Reference, to specify information that the onrestorept utility can use if an upgrade fails.
For information on the onrestorept utility and setting up the server for it, see the following topics in the IBM Informix Migration Guide:
IngeHalilovic 060000MPB8 Tags:  tasks administration scheduler database server informix automatic oat 1,855 Views
One of the great things about IBM® Informix® is how many tasks are done automatically. Many of the automatic tasks are done by the Scheduler.
Here's the documented definition of the Scheduler:
The Scheduler is a set of tasks that execute SQL statements at predefined times or as determined internally by the server. The SQL statements can either collect information or monitor and adjust the server.
The Scheduler has been around in Informix for quite a while, but Informix development adds new tasks fairly frequently. And, of course, you can add your own tasks. Check out the blog posting from the IDS Experts on how to create your own Scheduler tasks.
To view all the Scheduler tasks, either query the ph_tasks table or look at them in the OpenAdmin Tool for Informix (OAT), on the Task Scheduler > Scheduler page.
Don't forget that you can customize existing tasks, even built-in ones. For example, you can change the threshold or when the task runs. See the The Scheduler topics in the information center for all your options.
We asked IBM® Software Support about the questions they are frequently asked about Informix® and put the questions and answers in the v11.70 information center. Most questions are about installing, upgrading, and administering Informix.
Take a look at the FAQ in the information center and let us know what you think!
IngeHalilovic 060000MPB8 Tags:  performance warehouse search database oat install informix 1,837 Views
The Informix® 11.70 information center has been updated with 11.70.xC2 information!
The new features in IBM® Informix 11.70.xC2 are:
Read the What's new in Informix topic in the information center for a short description of each new feature and links to where they are documented in detail.
96QY_Pat_Smith 27000196QY 1,824 Views
If you have Informix Version 11.50, you can use SQL administration API commands to compress row data in a table or in one or more table fragments. You can also use SQL administration API commands to consolidate free space in a table or fragment, return this free space to the dbspace, and estimate the amount of space that is saved by compressing the data.
If you haven't tried compressing your data and want more information on this well-received feature, start by opening the "What's new" topic in the Administrator's Guide or Administrator's Reference and then navigate to the topics on compression.
Happy new year!
The Informix documentation team has already fulfilled one of our new year's resolutions: to make it easier to find the latest version of the 11.70 product manuals in PDF format. Check out this document, which links to the most recently published version of each of the 11.70 manuals, including translated versions of the manuals.
Let us know if you like it!
IngeHalilovic 060000MPB8 Tags:  informix database administration tenant multitenancy 1,795 Views
As of IBM© Informix© 12.10.xC4, you can deploy an Informix server that supports multiple tenants. A tenant is a set of users in a client organization that needs to access the same data and system resources. You create a dedicated tenant database, and assign storage and processing resources for that database based on the service-level agreements with the client organization. For example, you can provide services to multiple companies that run efficiently in a single Informix instance.
When you configure multitenancy, you segregate the following aspects of a database server:
To create a tenant database, run the tenant create argument with the admin() or task() function. The user that creates the database is granted DBA privileges. You can view the tenant database properties in the tenant table in the sysadmin database.
The following statement creates a tenant database that is named companyA:
The tenant database has the following properties:
The tenant database does not have a blobspace, stores temporary smart large objects in the sbspace that is specified by the SBSPACETEMP configuration parameter, and is case-insensitive.
For more information, see Multitenancy.
Today I learned about a Google search option that helps me view websites on my smartphone. Next to a search result I just click Options -> Mobile formatted (IMAGE 1). Simple, eh? The page loads rather quickly and is optimized for viewing on my teeny, tiny screen.
I can see this option being useful for viewing the IBM® Informix® information portals, such as the onconfig portal (IMAGE 2) that we've heard customers like. You can search for "onconfig portal 11.70" or you can start at the Informix information center (IMAGE 3) and select the portal that you want to use. If you try this option with our documentation let me know what you think by posting a comment to our blog. Now you can take Informix documentation "to go".
IBM Informix Survey for Continuous Availability White Paper
Complete the Survey to win an Apple iPad! - 1 week left
Every response matters. - Start Survey here!
IBMR Informix is the database software voted #1 in customer satisfaction.
Clients choose Informix because it is reliable, low cost, and hassle free.
Solution providers choose Informix for its best-of-breed embeddability.
Yet, there are some people that still don't 'get' Informix, or realize the
many benefits of deploying it. Help us gather data to support this claim.
- Informix is exceptionally hardware efficient, which means that (in the
REAL world) you need to spend MUCH less on hardware to get the same
performance as other products.
- Informix is exceptionally reliable, which means that (in the REAL world)
you don't need to pay lots of people to make sure it stays 'up'.
- Informix is exceptionally scalable, which means that (in the REAL world)
it can be idling one moment and then processing thousands of transactions
the next with no apparent stress.
Advanced DataTools is working with Oninit, to gather data about what happens
in the REAL world to support these assertions with empirical evidence in the
The data collected will be used to compile a report that will be made
available to every CTO, IT Director and IT Manager. Along with this, they
will receive a list of all the major application vendors that are now
porting their applications to Informix V11.5 and a document outlining the
key reasons to choose Informix.
Every response matters. - Start Survey here!
Win an Apple iPad. One randomly selected participant in the data collection
phase of this research will win an Apple iPad, provided by Advanced
DataTools Corporation, an Advanced IBM Informix Business Partner.
Note: Public Sector Employees are not eligible
Even though the IBM Knowledge Center contains the technical product documentation for thousands of IBM products, you can easily and quickly get information about only the products and topics that you are interested in.
To reduce the number of results returned about a particular subject area, you can refine your search by using the intitle operator. The intitle operator restricts results to words or phrases that appear only in the title of a topic. Use this operator when you are looking for the main topics about a subject area. For example, compare the following two searches for Informix 12.1:
1. basic text search error
2. basic text search intitle:error
You can also search for a phrase in the title. For example:
Backup and restore configuration parameter reference topics consolidated into one Backup and Restore Guide chapter
In Version 11.70xC4, all reference topics on ON-Bar, ontape, and archecker utility configuration parameters are now consolidated into a new "Backup and restore configuration parameters" section of the IBM Informix Backup and Restore Guide. Additionally, duplicate topics on backup and restore configuration parameters have been removed from both the Backup and Restore Guide and the Administrator's Reference. This should make it easier to find backup and restore configuration parameter reference information. This is just one example of the kinds of documentation improvements we like to make for each new release of the Informix product.
Click Backup and restore configuration parameters to view the consolidated information in the Backup and Restore Guide.