The Informix® 11.70 information center
has been updated with 11.70.xC2 information!
The new features in IBM® Informix 11.70.xC2 are:
- Enhanced installation application (Linux, UNIX)
- New event alarms
- The returned MAX_PDQPRIORITY value in a query to the SNMP rdbmsSrvParamTable
- New SQL administration API arguments
- Improved results of basic text search queries
- Table and column aliases in DML statements
- Case-insensitive queries on NCHAR and NVARCHAR text strings
- Embedding Informix software without root privileges (UNIX, Linux)
- Deploying an RPM image of Informix software (Linux)
- Enhancements to the OpenAdmin Tool
- Enhancements to the Schema Manager plug-in for OAT
- Improve network connection performance and scalability
- IBM Informix Warehouse Accelerator
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.
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".
This post is from Howard Glaser, the Informix usability expert. He attended the IIUG conference last week.
I want to thank all of the 2010 IIUG Conference attendees who provided feedback in our Usability Sandbox and customer sessions at the conference. Your feedback is invaluable in making IDS even better! Below is a list of the usability sessions that were held at the conference. Let us know if there are additional usability topic areas that you would like to see at future conferences (please write to email@example.com).
• Hands on experience test driving the latest Schema and Storage Manager UIs for the OpenAdmin Tool
• A sneak peak and feedback on the new IDS Installation and Configuration Tooling/UI: A group walkthrough discussion with the IDS Dev team
• A sneak peak and feedback on the new IDS Deployment Tooling/UI: A group walkthrough discussion with the IDS Dev team
• Your opportunity to give your input on useful sources and resources for solving problems encountered while using IDS: An examination of current and future resources followed by a group exercise to provide your preferences
• How Optim may be used for problem determination and resolution with IDS: A walkthrough and group discussion
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
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.
You can monitor Scheduler threads
that are in progress with the onstat -g dbc command. You can view information about tasks
and sensors that have completed in the ph_run table.
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.
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
As an information developer who has documented and completed numerous Informix® installations in GUI mode for over 4 years, I've really liked how the installer has evolved. First, with version 11.10, the custom setup of the installer let you peel away the features of the database server that you did not want. This functionality, known as the deployment wizard, helps you save on disk space when you want to minimize the footprint of the installation. The revised interface also provided a short description of each feature—just enough information to let you know whether or not it was a component that you needed.
Client SDK and Informix Connect are fully integrated into the IBM® Informix Software Bundle version 11.70 installer in such a way that there is no need for separate standalone and bundle media. The major client programs appear in the feature tree in custom setup, so that in one step of the installation process you can exercise your right to exclude whatever client programs and whatever base server features that you don't need. (See the IBM Informix Software Bundle screen capture below.) Unlike previous versions, there is one unified interface after launching the installation of the Informix server with either Client SDK or Informix Connect. No more watching installers of separate products open and close.
Right after you select products and features, the installer puts you back in the driver seat again. You can choose whether the installer should automatically create a working instance of the database server—and if you do, you can opt to specify major configuration parameters yourself or let the installer calculate working configuration settings based on the host environment.
And perhaps the best part is that you can still complete a product installation with the media in less than 30 minutes!
Release, Doc, and Machine notes for Informix 4GL 7.50.xC6 are now available on the 11.50
Info Centers. No other 4GL documentation was updated for this release.
If you missed the Chat with the Labs last week, listen to the replay here: https://www.ibm.com/developerworks/wikis/display/ifmxchatwithlab/Home
. Two IBM® Informix®
support engineers, Ron Privitt and Sanjit Chakraborty, discuss the top 10 issues that generate support calls. You'll hear about the issues, how to solve and prevent them, and tips on what information to gather so that support can solve your problems quicker.
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:
- Test your applications thoroughly in a realistic environment before releasing
your applications into production.
- Check and repair the consistency of your data. Run oncheck!
- Upgrade to the latest major and fix pack release.
- Update statistics. In 11.70, statistics are updated automatically by default.
- Monitor and complete in-place alter operations.
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.
IBM® Informix® 12.10 comes with the new Informix Primary Storage Manager (PSM) to use with the ON-Bar utility to back up and restore data. PSM replaces the Informix Storage Manager. PSM is configured by default: you don't have to do anything to set it up. Just run a backup with the onbar command and you'll be using PSM!
Here are some of the features of PSM:
You use file devices for backups.
There's no buffer transfer size limit.
You can enable compression and encryption through ON-Bar.
You can expire backup objects from the storage manager with the onsmsync utility.
You can change the PSM configuration by resetting any of the 6 PSM configuration parameters in the onconfig file.
You can use PSM with ON-Bar in the OpenAdmin Tool for Informix.
You use the onpsm utility to manage PSM catalogs, devices, locks, and objects.
Check out these examples of configuring and using PSM.
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:
- New features: version 11.50 and 11.70 have many new product features. The new features do not just add to existing features, but in some cases actually replace older functionality. What you read about in version 10 manuals might not exist anymore.
- Accuracy: version 11.70 manuals are updated with the latest documentation defect fixes every fix pack. Version 10 manuals have not been updated since 2005.
- Translated documentation: version 11.70 has more manuals translated into more languages than any previous version.
- Better documentation: We've made a lot of improvements to the documentation since version 10. For example, we have replaced many references to other manuals with direct links and added information portals.
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.
Modified on by IngeHalilovic
With IBM® Informix® 12.10.xC5, you have a lot more control over session resources. Besides setting session environment variables to control the current session, you can set configuration parameters to limit all sessions and prevent blocked transactions.
You can specify to end sessions that exceed a specified amount of shared memory or temporary storage space:
- Set the SESSION_LIMIT_MEMORY configuration parameter to the maximum amount of shared memory that can be allocated for a session.
- Set the SESSION_LIMIT_TEMPSPACE configuration parameter to the maximum amount of temporary storage space that can be allocated for a session.
You can specify to roll back transactions that are too large or take too long:
- Set the SESSION_LIMIT_LOGSPACE configuration parameter to the maximum amount of log space that a transaction can fill.
- Set the SESSION_LIMIT_TXN_TIME configuration parameter to the maximum number of seconds that a transaction can run.
Starting in 12.10.xC4, you can set the SESSION_LIMIT_LOCKS configuration parameter (and the IFX_SESSION_LIMIT_LOCKS environment option) to limit the number of locks.
Session limits do not apply to a user who holds administrative privileges, such as user informix or a DBSA user.
Transactions and sessions that exceed a set limit are terminated by the session_mgr thread. The session_mgr thread starts when the database server starts, and remains inactive until a session limit is exceeded.
Monitor sessions with the onstat -g ses command.
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';
Before IBM® Informix® 11.70.xC4, you had to download and install the IBM OpenAdmin Tool (OAT) for Informix separately from the Informix product. Now, when you install IBM Informix Client Software Development
when you install the IBM Informix software bundle and select Client SDK or IBM Informix Connect, you can install
OAT. This option is available on Windows 32-bit, Linux 32-bit and
64-bit, and MAC OS 64-bit operating systems.
Note that OAT is not installed with Client SDK by default--you have to choose to include OAT.Here's
more information from the IBM Informix Client Products Installation
Do you want to know exactly what's new for IBM® Informix® 11.70? Visit the new v11.70 information center
For highlights of Informix 11.70, short descriptions of all the new features, and links to where the features are described in detail, see What's new in Informix
Don't forget to subscribe to the RSS feed
so that you'll know when we update the information center.
The v11.70 information center has the same collaboration features as the v11.50 information center. Find out
how to comment on, rate, and watch topics.
The v11.70 information center works best with these browsers:
- Microsoft Internet Explorer Version 6.0, Version 7.0, Version 8.0
- Mozilla Firefox Version 3.5