- 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 update_statistics informix prevention 1,847 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.
IngeHalilovic 060000MPB8 Tags:  database logs autonomic bufferpool configure installation server performance automatic parameters json informix administration 886 Visits
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 1,351 Visits
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 database server informix automatic oat 1,654 Visits
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.
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 1,735 Visits
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:  connection manager oat transactions spl database server features xid timeseries high-availability genero fixpack cluster administration warehouse inout informix 2,396 Visits
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 2,206 Visits
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 2,146 Visits
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 cdr onconfig 2,131 Visits
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 firstname.lastname@example.org.
IngeHalilovic 060000MPB8 Tags:  performance olap backup embed high-availability upgrade iwa cluster sensor restore time-series replication grid informix usability warehouse compression oat administration 3,198 Visits
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 performance administration text time-series rest spatial multitenancy database replication 1,494 Visits
What's new IBM® Informix® version 12.10.xC4
IngeHalilovic 060000MPB8 Tags:  database informix administration tenant multitenancy 1,392 Visits
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.