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
With IBM® Informix® 12.10.xC5, you can search time series data for matches to a specific pattern of values. For example, after you identify a pattern of abnormal electricity usage that indicates an outage, you can search for matches to that pattern to find other outages. A pattern is a sequence of numeric values in a field within the TimeSeries subtype. You can specify a search pattern as a time range in a specific time series or as a list of numeric values. A match is a sequence of values from a target time series that conform to the search criteria.
When you run a pattern matching search, you specify the method to evaluate possible matches and the margin of error between the search pattern and matching values.
The following information is returned for each resulting match:
You can create a pattern matching search index on a time series instance to improve query performance.
Read more: Pattern matching searches.
Attend the Using Pattern Matching Analytics in IoT and TimeSeries data Webinar on April 20: https://events.na.collabserv.com/register.php.
One of the great features of the IBM Knowledge Center is that you can create PDF versions of any documentation you want. First you create a collection of topics that you want to be in the PDF.
To create a PDF from the Knowledge Center:
1. Sign in to the Knowledge Center with your IBM ID. The Sign In button is in the upper right corner of the black title bar.
2. In the navigation pane, click the topic that you want to add to a collection. The subtopics are also added to the collection, but you can edit the collection to remove the topics that you don't want.
3. Choose an option from the Add to collection menu, in the upper right above the topic:
4. If you chose a new collection, enter a name. Otherwise, choose an existing collection name.
5. Click My Collections at the bottom of the navigation pane to see your collections.
6. Select the collection in the navigation pane and click Create PDF File. Note: Only the first 1000 topics are included in the PDF.
The PDF is created. You have about an hour to download it before it disappears.
If you're installing Informix server in a Unicode environment, check out the tips that we added about setting the GL_USEGLU environment variable. You’ll learn:
Examples are provided to show the steps that you must use to create a Unicode database. And, just in case something doesn’t go as expected, we added some troubleshooting tips for errors that you might encounter.
IngeHalilovic 060000MPB8 Tags:  redbooks developerworks search informix manuals documentation 301 Visits
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.
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.
jasna 110000T2XC 512 Visits
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
For more reasons to go to IOD 2013, check out Jerry Keesee's invitation.
I'm sure you are all familiar with the IBM Knowledge Center, which has the information for Informix versions 11.5, 11.7, and 12.1. But maybe you are used to seeing the old version 10.0 information center show up in search results.
The Informix information centers for version 10.0, 11.1, and older products have been taken down.
You can still access the documentation, however! There are web pages that link to PDFs or .zip files:
JohannaTuraj 0600007SU6 531 Visits
We've made some changes to the Informix on-line notes in the 12.10.xC2 release.
Release notes are provided only in HTML format, in the Information Center and with the product. Text versions are no longer available.
We removed redundancy and the need to look in multiple files to get the information that you need.
jmcdavid 270003BVSW 536 Visits
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
jmcdavid 270003BVSW 594 Visits
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.
Informix 12.10.xC4 has some very exciting new features for JSON compatibility:
Support for CORS requests in the REST API (12.10.xC4W1)
You can now set up cross-origin resource sharing (CORS) with the REST API. To do so, set the following optional parameters that were added to the jsonListener.properties file:
Informix now supports the following MongoDB 2.4 features:
You can perform the following new tasks that extend MongoDB functionality in your JSON application:
You can customize the behavior of the wire listener by setting new properties. For example, you can control logging, caching, timeout, memory pools, and the maximum size of documents.
Access Informix from REST API clients
You can now directly connect applications or devices that communicate through the REST API to Informix. You create connections by configuring the wire listener for the REST API. With the REST API, you can use MongoDB and SQL queries against JSON and BSON document collections, traditional relational tables, and time series data. The REST API uses MongoDB syntax and returns JSON documents.
Create a time series with the REST API or the MongoDB API
If you have applications that handle time series data, you can now create and manage a time series with the REST API or the MongoDB API. Previously, you created a time series by running SQL statements. For example, you can program sensor devices that do not have client drivers to load time series data directly into the database with HTTP commands from the REST API.
You create time series objects by adding definitions to time series collections. You interact with time series data through a virtual table.
Joel_SF 110000ECNB Tags:  informix json nosql internet-of-things ids12 informix-roadshow 12 625 Visits
Gartner recently released its 2014 Hype Cycle report, showing the Internet of Things (IoT) at the peak of the Hype Cycle. The Hype Cycle report tracks emerging technologies from infancy to widespread adoption. With IoT at peak hype, companies must be ready to hit the ground running with this technology.
A huge amount of data is already being generated by IoT devices, and much of this data is unstructured. IBM Informix can natively handle NoSQL and structured data simultaneously, providing the enterprise-level capabilities of an structured database system. The capabilities offered by IBM Informix include transaction support, backup and recovery, high availability, compression, enhanced scalability, security, and access control.
To learn more about IBM Informix, JSON/NoSQL, and the Internet of Things, you can:
96QY_Pat_Smith 27000196QY 667 Visits
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:
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.
IngeHalilovic 060000MPB8 763 Visits
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
OAT has new compression options on the Space Administration > Storage > Tables and Indexes page:
IBM Informix Schema Manager Plug-in for OpenAdmin Tool (OAT) has the following compression options on the SQL ToolBox > Schema Manager page: