The 11.70 documentation set includes a new user guide, the IBM Informix Embeddability Guide, which contains information on customizable deployment options and configurable administration features that you can use to achieve an end-to-end deployment solution. Some examples of the topics in this guide, which are also available in the Embedding IBM Informix section of the IBM Informix 11.70 Information Center, are:
- Customize the size of Informix
- Customize deployment
- Automated administration
- Deploying Informix software
- Automating deployments
We encourage you to look at the information in the new guide when you browse through the IBM Informix 11.70 Information Center to see what else is new.
The Informix 2013 Survey is now available. Make your voice heard! Tell us how you use Informix products. Let us know how you would like to use Informix products.
Your feedback is very important. Take the time to be a part of the discussion.
Modified on by jmcdavid
Find the information you need, share your ideas, and join the conversation! The following resources can help you do all of these things.
12.10 Information Center: Complete 12.10 documentation and a portal full of useful links
11.70 Information Center: Complete 11.70 documentation and a portal full of useful links
The IBM Informix Virtual Images: Resources on virtualized Informix offerings
Informix Exchange Collection: A place to view code samples and examples, and to share your own
Informix Frequently Asked Questions (FAQ): Find the answers to common questions about installation, upgrading, and administration
List of Informix-Related Blogs: Hear what Informix experts are saying, from inside and outside of IBM
Informix Warehousing Portal: Resources for implementing Informix dimensional databases, creating data warehouse applications, and optimizing your data warehouse queries
The International Informix Users Group (IIUG) Forums: Join the conversation and share ideas with other Informix users
The OpenAdminTool Youtube Channel: Videos of key OAT features
The IBM Informix 12.10.xC6 release has a lot of new functionality to support JSON compatibility! In addition to the Parallel sharded queries that I've already blogged about, Informix is now compatible with MongoDB 2.6 and 3.0 clients, and has more options for controlling security and resource management.
MongoDB 2.6 and 3.0 compatibility
Informix now supports the following MongoDB commands:
- The following database management commands:
- The query and write operation commands insert, update, and delete.
- The instance administration commands createIndexes, listCollections, and listIndexes.
- The user management commands, for MongoDB 2.6 and later, createUser, updateUser, dropUser, dropAllUserFromDatabase, grantRolesToUser, revokeRolesFromUser, and usersInfo.
- The role management commands: createRole, updateRole, dropRole, dropAllRolesFromDatabase, grantPrivilegesToRole, revokePrivilegesFromRole, grantRolesToRole, revokeRolesFromRole, and rolesInfo.
- The query and projection command $eq.
- The field update operators $mul, $min, $max, and $currentDate.
- The pipeline aggregation operator $out.
More security options
You can configure the database server to authenticate MongoDB client users, who connect through the wire listener, with a pluggable authentication module (PAM). Because you administer user accounts through the database server, you can audit user activities and configure fine-grained access control.
You can configure the wire listener to:
- Authenticate MongoDB clients with the MongoDB 3.0 SCRAM-SHA-1 authentication method.
- Disable commands
- Specify an IP address as the administrative host
- Set authentication timeout
Better Resource management
You can configure the wire listener to:
- Configure a memory monitor to reduce resource usage.
- Create a separate thread pool for administrative connections.
- Specify the timeout periods for socket connections.
- Suppress pooled connection checking.
- Specify the number of maintenance threads for connection pools.
For more information, see What's new in JSON compatibility.
Only 3 weeks until the Information on Demand (IOD) conference. I know that they say "What happens in Vegas, stays in Vegas", but if you attend any of the Informix sessions, you are going to want to bring home what you learned!
Search for "Informix" in the session preview tool to see a list of the lectures and labs that you can choose from. For example, one (or all!) of these labs might interest you:
IDX-1344A: How to use sharding to improve performance and availability of distributed applications
IDX-1381A: Speed-of-thought query response with Informix Warehouse Accelerator and new SQL enhancements in Informix 12.1
IDX-1467A: Comprehensive compression techniques using new features available in Informix 12.1
For more reasons to go to IOD 2013, check out Jerry Keesee's invitation.
Informix Version 11.70 contains enhancements to high-availability cluster functionality. One of these enhancements lets you upgrade an 11.50 cluster to an 11.70 cluster without any downtime. For detailed information about this process, read the "Upgrade Informix high availability clusters online
" developerWorks article, written by Anju Sudhakar and Sapna Ramesh. two of our esteemed Informix software engineers.
If you upgrade to version 11.70, you can configure Informix to automatically expand an existing storage space when the space is full. You can also configure Informix to expand the space before it is full, when its free pages fall below a specified threshold. When you enable and configure automatic storage provisioning, you do not need to manually add storage space to avoid out-of-space errors. Even if you prefer to add space manually, automatic storage expansion greatly simplifies the process of adding space, because you do not need to determine where to get the space.
You can use MQ messaging functions to enable Informix applications to exchange data directly between the application and IBM WebSphere MQ. Applications can send and receive messages from local or remote queue managers that reside anywhere in the network and participate in a transaction.
IBM Informix Version 11.70 includes several new MQ messaging functions, which simplify administrative tasks and reduce the number of WebSphere MQ licenses that are needed.
For more information, see What's new in Database Extensions for IBM Informix, version 11.70 in the Database Extensions Users Guide.
There's actually more Informix information on the ibm.com site than just the Knowledge Center. For example, there's developerWorks articles, tech docs and notes, and Redbooks. If you want to search all of these sources, just use the search field on the www.ibm.com site. I know it's hard to see, being black on black, but here's what it looks like, in the upper right-hand corner of the webpage:
You don't need to log in. Include the word "informix" in your search and you'll find all sorts of things. The links to documentation in the Knowledge Center look like this: http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.welcome.doc/welcome.htm. The number after the uppercase letters is the Informix version number. In this case, 12.1.
Modified on by JohannaTuraj
We've made some changes to the Informix on-line notes in the 12.10.xC2 release.
All release notes
The release notes were simplified so that the latest information is easy to find:
Included a link to the list of new features in the Information Center
Included links to the most up-to-date queries of fixed and known defects.
Removed content that was out of date.
Moved content to the product documentation when appropriate.
Release notes are provided only in HTML format, in the Information Center and with the product. Text versions are no longer available.
Client SDK release notes
The Client Software Development Kit (Client SDK) release notes are consolidated into three files:
We removed redundancy and the need to look in multiple files to get the information that you need.
The documentation notes are available in the Information Center only. They are no longer included in the product media.
If you upgraded from Informix version 12.10.xC1, the 12.10.xC1 on-line notes files that are no longer included with 12.10.xC2 remain in your installation.
IBM® Informix® 12.10.xC5 is now available on Mac OS X in Passport Advantage. Informix is the only enterprise-class database server that supports Mac OS X.
You can use the new FULL_DISK_INIT configuration parameter to prevent the major problems that can occur if you or someone else accidentally initializes your instance or another instance when the first page of the first chunk (page zero) exists at the root path location. Page zero, which is created when Informix is initialized, is the system page that contains general information about the server.
The FULL_DISK_INIT configuration parameter specifies whether or not the disk initialization command (oninit -i) can run on your Informix instance when a page zero exists at the root path location. When this configuration parameter is set to 0, the oninit -i command runs only if there is not a page zero at the root path location. (If you change the setting of the FULL_DISK_INIT configuration parameter to 1, the oninit -i command runs under all circumstances, but also resets the FULL_DISK_INIT configuration parameter to 0 after the disk initialization.)
This feature is just one of many new useful features in Version 11.70xC1.
There are several improvements to compression in IBM® Informix® version 12.10. See the What's new in Informix page in the information center for links to documentation on these features. Here's a summary:
Improve space utilization by compressing, repacking, and shrinking B-tree indexes
You can use SQL administration API commands or CREATE INDEX statements to save disk space by compressing B-tree indexes. You can also use SQL administration API commands to consolidate free space in a B-tree index, return this free space to the dbspace, and estimate the amount of space that is saved by compressing the indexes.
Save disk space by compressing simple large objects in dbspaces
You can use SQL administration API commands to save disk space by compressing simple large objects (TEXT and BYTE data types) that are stored in the same partition in the same dbspace as the table in which they are referenced. When you run an SQL administration API compress or uncompress command, the database server compresses both the table row data and the referenced simple large objects. You can choose to compress or uncompress only the table row data or only the referenced simple large objects.
Save disk space by enabling automatic data compression
You can use the COMPRESSED keyword with the CREATE TABLE statement to enable the automatic compression of large amounts of in-row data when the data is loaded into a table or table fragment. Then, when 2,000 or more rows of data are loaded, the database server automatically creates a compression dictionary and compresses the new data rows that are inserted into the table.
Also, when you run SQL administration API create dictionary and compress commands on existing tables and fragments, you enable the automatic compression of subsequent data loads that contain 2,000 or more rows of data. If you run an uncompress command, you disable automatic compression.
In addition to saving space, automatic compression saves time because you do not have to compress the data after you load it.
Manage compression in IBM OpenAdmin Tool (OAT) for Informix
has new compression options on the Space Administration
> Tables and Indexes
You can enable automatic compression when you compress existing tables and fragments. You disable automatic compression when you uncompress a table or fragment.
You can compress indexes. You can consolidate free space in indexes (repack) and return free space to the dbspace (shrink). You can also estimate the amount of space that you can save if you compress an index. An index must have at least 2000 keys to be compressed.
You can compress simple large objects (TEXT and BYTE data types) when you compress tables and fragments. You can also estimate the amount of space that you can save if you compress simple large objects.
IBM Informix Schema Manager Plug-in for OpenAdmin Tool (OAT)
has the following compression options on the SQL ToolBox
> Schema Manager
You can enable automatic compression of row data when you create a table. The database server automatically creates a compression dictionary and compresses the data when 2000 or more rows of data are loaded into the table or fragment.
You can compress an index when you create an index that has at least 2000 keys.
Each version of Informix supports new SQL keywords that are reserved words. The use of these words in your applications might affect the migration of your applications when you upgrade to a new version of Informix. If you haven't migrated to the new version and would like to see the new keywords, you can find them listed in the following IBM Informix Migration Guide
appendix: New keywords of SQL
The Version 11.70 IBM Informix Guide to SQL: Syntax
contains an alphabetic list of all keywords
Modified on by IngeHalilovic
Due to popular demand, PDF versions of the IBM® Informix® manuals are now available!
You can find most of the manuals and a zip file of the entire doc set in the Publications for IBM Informix 12.10 family of products.
You can find the Informix Warehouse Accelerator Administration Guide in the Publications for Informix Warehouse Accelerator 12.10.