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.
Appropriate Content: Informix Documentation Team
Starting with version 12.10.xC4, you can resolve in-place alter operations by running the admin( ) or task( ) SQL administration command with the table update_ipa or fragment update_ipa argument. You can include the parallel option to run the operation in parallel. For example, the following statement removes in-place alter operations in parallel from a table that is named auto:
See the table and fragment arguments: Compress and optimize storage topic for details.
IngeHalilovic 060000MPB8 Tags:  informix database environment onstat onconfig administration configuration monitor 1,030 Visits
Quick Reference Cards are meant to be printed in color to provide a handy reference (and enhance the decor of your office).
We've updated the following Quick Reference Cards with IBM® Informix® 12.10.xC4 content:
IngeHalilovic 060000MPB8 Tags:  informix database administration tenant multitenancy 1,294 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.
IngeHalilovic 060000MPB8 Tags:  bson geojson informix jdbc json administration performance time-series text rest spatial multitenancy database replication 1,404 Visits
What's new IBM® Informix® version 12.10.xC4
IngeHalilovic 060000MPB8 Tags:  database logs autonomic bufferpool configure installation server performance parameters automatic json informix administration 851 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:  sharding compression timeseries automatic autonomic administration warehouse database json informix installation spatial nosql performance hertz tuning configuration replication quarter 2,078 Visits
We have some very exciting new features in IBM® Informix® 12.10.xC3!
What's new IBM Informix version 12.10.xC3
IngeHalilovic 060000MPB8 Tags:  database restore backup administration storage deduplication informix 1,307 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:  cluster availability backup lateral restore administration deduplication informix database replication constrainsts 2,143 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:  json warehouse shard oat timeseries accelerator iwa administration informix restore backup replication database performance 2,904 Visits
It's that time again: another Informix® fixpack that's full of new functionality!
Here's a list of what's new:
IngeHalilovic 060000MPB8 Tags:  replication sql administration informix onstat cdr onconfig 2,088 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 iwa upgrade cluster restore sensor time-series replication grid usability informix warehouse compression oat administration 3,135 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:  oat administration informix database features 1 Comment 2,264 Visits
I'm very excited about the upcoming IBM® Informix® release! Not only are there are amazing new features in specialized areas like replication, warehousing, and time series data, but there are also many new features in the server that every Informix DBA can take advantage of. And let's not forget the OpenAdmin Tool (OAT) for Informix: the new release supports new features in the server but also includes major usability improvements and new functionality that was demanded by customers like you!
Jerry Keesee and John Miller will be introducing the new Informix release in a webcast on March 26, 2013 (Tuesday) at 10:00 AM PST.
IngeHalilovic 060000MPB8 Tags:  tasks administration scheduler informix server database automatic oat 1,624 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.
IngeHalilovic 060000MPB8 Tags:  manager connection oat transactions spl database server features xid timeseries high-availability genero fixpack cluster administration warehouse informix inout 2,349 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.