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
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 369 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.
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.
For IBM® Informix® 12.10.xC5, we rewrote the database server installation information. Previously, we had two installation guides: one for UNIX, Linux, and Mac OS X, and one for Windows platforms. For 12.10.xC5, we combined the two guides into one guide and while we are at it, we condensed the information and corrected out-of-date information.
Take a look at the new Installation Guide!
Here's a teaser: the new Preparing for installation topic:
Preparing for installation
Before you install Informix database server products, you must prepare your system and plan for choices that you must make during the installation process.
Preparing for installation includes reviewing system requirements, planning how to upgrade, deciding on the installation owner and the installation directory, reviewing installation options, and gathering information if you want to create a database server during installation. It also includes preinstallation tasks such as obtaining the software and reviewing the machine notes.
To prepare for installation:
Log files are created during the installation process. You can use the log files to troubleshoot installation errors.
After you install the database server, you can create the demonstration databases that are included with the database server. Many examples in the documentation and in the $INFORMIXDIR/demo (UNIX, Linux, Mac OS X) or the %INFORMIXDIR%\demo (Windows) directory are based on the demonstration databases. You can use the demonstration databases to explore database server features. You can create the demonstration databases at any time after installation by running the dbaccessdemo command. See Demonstration databases.
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 539 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.
jmcdavid 270003BVSW 561 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
JohannaTuraj 0600007SU6 564 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.
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:
jmcdavid 270003BVSW 614 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.
96QY_Pat_Smith 27000196QY 674 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.
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.
Joel_SF 110000ECNB Tags:  informix json nosql internet-of-things ids12 informix-roadshow 12 693 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:
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.