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.
Appropriate Content: Informix Documentation Team
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.
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.
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.
IngeHalilovic 060000MPB8 Tags:  spatiotemporal backup informix timeseries oat rest mongodb bson upgrade nosql java json installation jdbc 7,525 Views
Here is the list of new features for IBM® Informix® 12.10.xC5!
What's new in IBM Informix version 12.10.xC5
Go to What's new in Informix for links.
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.
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.
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.
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.
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.