- 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.
Appropriate Content: Informix Documentation Team
IngeHalilovic 060000MPB8 Tags:  administration assertion_failure backup informix update_statistics prevention 2,717 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:  database logs autonomic bufferpool configure installation server performance parameters automatic json informix administration 2,407 Views
You can choose to create and configure a server during the installation of IBM® Informix® version 12.10.xC3. The server is configured by the choices that you make in the installation program and started after installation is complete. The resulting server is configured to require minimal administration. Creating a server during installation is not just for demonstration purposes anymore!
The mandatory configuration parameters and environment variables are set and connectivity information is configured.
The following storage spaces are created for the server:
The sizes of the spaces are based on the number of expected users that you specify during the installation.
The server is configured to automatically tune resources for performance, which includes expanding the buffer pool, the logical logs, and the physical log, and increasing virtual processors.
IBM® OpenAdmin Tool (OAT) for Informix® is configured and connected to the server.
The JSON wire listener is configured, started, and connected to the server through the ifxjson user.
Take the easy way out and let the installer do all the work of configuring the server for you!
IngeHalilovic 060000MPB8 Tags:  database restore backup administration storage deduplication informix 2,606 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:  tasks administration scheduler informix server database automatic oat 2,841 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.
IngeHalilovic 060000MPB8 Tags:  auditing administration guardium security informix 2,307 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.
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
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.
IngeHalilovic 060000MPB8 Tags:  information_center migration administration embeddability programming warehouse portal informix extensibility 3,554 Views
Recently we've added information portals to the Informix® 11.70 information center. Information portals have links to key documentation both within and outside the information center. For example, we'll include links to interesting developerWorks® articles and Redbook® publications. Most of these portals are the top level nodes in the left hand navigation pane of the information center.
Here are the ones we've done so far:
Let me know if you have suggestions for additions to these portals or other portals you would like to see!
IngeHalilovic 060000MPB8 Tags:  manager connection oat transactions spl database server features xid timeseries high-availability genero fixpack cluster administration warehouse informix inout 3,662 Views
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.
IngeHalilovic 060000MPB8 Tags:  cluster availability backup lateral restore administration deduplication informix database replication constrainsts 3,587 Views
IBM Informix 11.70.xC8 has a great set of new features!
What's new in version 11.70.xC8 of IBM Informix
IngeHalilovic 060000MPB8 Tags:  sharding compression automatic timeseries autonomic administration warehouse database json installation informix spatial nosql hertz performance tuning configuration replication quarter 3,911 Views
We have some very exciting new features in IBM® Informix® 12.10.xC3!
What's new IBM Informix version 12.10.xC3
Can't remember which onstat command shows you the information about the server that you are looking for? Try the onstat portal.
The onstat portal organizes onstat commands by functional area, with links to the individual topics for each command.
The onstat portal topic is in the
IngeHalilovic 060000MPB8 Tags:  replication sql administration informix onstat onconfig cdr 3,809 Views
The ever-popular quick reference cards for configuration parameters, onstat commands, and SQL adminstration API command are updated for 12.10, plus we have a new card for Enterprise Replication cdr commands:
You can find these links on the home page of the IBM® Informix® 12.10 information center. If you are going to IIUG, we'll be handing out hard copies of these cards.
And, of course, if you have ideas about other quick reference cards, please let us know! Email email@example.com.
IngeHalilovic 060000MPB8 Tags:  performance olap backup embed high-availability upgrade iwa cluster sensor restore time-series replication grid informix usability warehouse compression oat administration 4,747 Views
The 12.10 documentation is in a new information center: http://pic.dhe.ibm.com/infocenter/informix/v121/index.jsp
Check out the amazing list of new features for IBM Informix version 12.10.xC1!
Here's a summary, but be sure to look at all new feature descriptions:
Installation and migration
IngeHalilovic 060000MPB8 Tags:  bson geojson informix jdbc json administration performance time-series text rest spatial multitenancy database replication 3,661 Views
What's new IBM® Informix® version 12.10.xC4