Appropriate Content: Informix Documentation Team
Want to hear about news, events, and other fun stuff about Informix? Like IBM Informix Dynamic Server (IDS) on facebook.
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
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".
fwelsch 06000203CP Tags:  informix_connect installation installer informix client_sdk 3,101 Views
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!
If you replicate your data with Enterprise Replication, you might need to repair inconsistencies in the data. Instead of syncing all the data, you can check the data to find inconsistencies and then sync only those records. The cdr check replicate and cdr check replicateset commands, which were introduced in Informix 10.0, had several new options added in Informix 11.50 to improve the speed of consistency checking and repairing data.
You can increase the speed of a consistency check on a replicate by indexing a new shadow column, ifx_replcheck. You add the ifx_replcheck column to your replicated table using the WITH REPLCHECK clause and create a unique index on the ifx_replcheck column and your primary key columns. You can also alter an existing table to add the ifx_replcheck column. The replicated table must also have the CRCOLS shadow columns. You cannot perform a table-level restore on a table that contains the ifx_replcheck column.
By default, inconsistent rows are rechecked for up to five seconds, which might not be enough time for replicated transactions to be applied on the target server. You can specify the number of seconds to spend on rechecking the consistency of inconsistent rows. Rechecking prevents transactions that are in progress from being listed as inconsistent in the consistency report. You can use the --inprogress option of the cdr check replicate and cdr check replicateset commands to specify the maximum number of seconds to perform rechecking.
You can reduce the duration of a consistency check by performing a check in parallel and by controlling the amount of data that is checked. You can specify a time from which to check updated rows by using the --since option. You can specify a subset of a table to check by using the --where option. You can prevent the checking of large objects by using the --skipLOB option.
You can increase the speed of a consistency check on a replicate set by performing the operation on each replicate in parallel. Specify the number of parallel processes to use for processing a replicate set by using the --process option with the cdr check replicateset command.
Use these options to customize your consistency checking and repairing.
For more information, see:
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.
Informix added a couple of key warehousing features in 11.50.xC5 and 11.50.xC6:
Load and Unload Data with External Tables
IDS supports external tables. You can read and write from a source that is external to the database server. External tables provide an SQL interface to data in text files managed by the operating system or to data from a FIFO device. To create external tables, use the CREATE EXTERNAL TABLE statement. Use the existing DROP TABLE statement to drop an external table.
See the Guide to SQL: Syntax.
Loading Data into a Warehouse with the MERGE Statement
Instead of using separate UPDATE and INSERT statements to load data from an OLTP database into a database warehouse environment, use the new MERGE statement, which can combine UPDATE and INSERT operations into a single SQL statement.
The MERGE statement can merge records from a table, view, or query (the source) with the records in a local table (the target). You can specify a logical condition that MERGE applies to a join of the source and target objects.
The MERGE statement supports Update and Insert triggers on the target table. Any constraints on the target table are enforced in MERGE operations.
See the Guide to SQL: Syntax.
Retrieving Data by Using Hierarchical Queries
You can now retrieve data from a table by using hierarchical queries, which maintain the relationship between the data.
The SELECT statement of Informix now supports START WITH .. CONNECT BY syntax for recursively querying a table in which a hierarchy of parent-child relationships exist. The syntax can define recursive queries that reflect the topology of the data hierarchy.
This implementation of hierarchical queries uses extensions to the ISO standard for SQL.
See the Guide to SQL: Syntax.
Informix Warehouse Feature
The Informix Warehouse Feature provides an integrated platform for the design and administration of data warehousing applications.
The core of Informix Warehouse Feature is the SQL Warehousing Tool. It includes an application development component in the Informix Warehouse Feature client and an administration component on the Informix Warehouse Feature server.
Informix Warehouse Feature client includes the Design Studio, which provides a common design environment for creating physical data models, SQL data flows and control flows. Design Studio is built on the Eclipse Workbench and automatically generates SQL that is based on visual operator flows that you model in the Design Studio. The library of SQL operators covers the in-database data operations that are typically needed to move data between database tables.
Starting with IBM® Informix® 12.10.xC4, you can allocate space efficiently when you import tables that have large rows by setting a default extent size of 16 KB. Include the new -D option of the dbimport utility to specify a default extent size of 16 KB. Extent sizes that you specify in the CREATE TABLE statement override the -D option. The -D option is useful especially when you import huge tables that contain large LVARCHAR columns.
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 firstname.lastname@example.org).
• 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
IngeHalilovic 060000MPB8 Tags:  database restore backup administration storage deduplication informix 3,014 Views
The deduplication of backups can save significant amounts of storage space. The default backup format for IBM© Informix©, however, does not result in efficient deduplication. Therefore, if your storage manager is enabled for data deduplication, use the new IFX_BAR_USE_DEDUP environment variable to make backup operations more efficient. This environment variable optimizes the format of backup images for deduplication processes.
The IFX_BAR_USE_DEDUP environment variable is available in Informix 11.70.xC8 and 12.10.xC2.
IngeHalilovic 060000MPB8 Tags:  administration assertion_failure backup informix update_statistics prevention 2,984 Views
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.
IngeHalilovic 060000MPB8 Tags:  auditing administration guardium security informix 2,982 Views
With IBM® Informix® 12.10.xc6, you now have increased capabilities when you audit the user actions for your Informix database server with IBM Security Guardium®, version 10.0. IBM Security Guardium prevents leaks from databases, ensures the integrity of information, and automates compliance controls across heterogeneous environments. IBM Security Guardium can now mask sensitive data in Informix databases. IBM Security Guardium can now audit, and if necessary, close, any Informix connection, regardless of the connection protocol. Previously, IBM Security Guardium audited and closed only TCP connections.
After you set up the IBM Security Guardium server, you start the ifxguard utility to monitor connections to your Informix databases. You can set the logging mode and the number of worker threads to prevent heavy locking by editing the ifxguard configuration file. You can enable auditing and set the actions of the database server if the IBM Security Guardium server does not respond in the timeout period by setting the IFXGUARD configuration parameter in the onconfig file.
For more information, see Auditing with IBM Security Guardium.
Note: This description has been updated from what is currently published in the IBM Knowledge Center. The original feature description stated that the ability to use Guardium with Informix was new. Not true! Guardium has worked with Informix for many years, but the capabilities of Guardium with Informix were significantly increased with this release.
96QY_Pat_Smith 27000196QY Tags:  informix database index update_statistics ustlow_sample statistics_low 11.70 2,961 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.
IngeHalilovic 060000MPB8 Tags:  openadmin_tool administration installation oat database informix 2,960 Views
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 Kit, or 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 Guide.