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
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.
IngeHalilovic 060000MPB8 Tags:  informix database environment onstat onconfig administration configuration monitor 1,261 Views
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,541 Views
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,659 Views
What's new IBM® Informix® version 12.10.xC4
IngeHalilovic 060000MPB8 Tags:  area database perimeter latitude esri coordinates measure distance informix round-earth longitude spatial geographic 1,151 Views
For version IBM® Informix® 12.10.xC3, we've enhanced our support for spatial data. The most exciting enhancement is support of the round-Earth model. Basically, you can put in two sets of longitude and latitude coordinates and get out a distance or area in meters (or whatever linear unit you want). Here's the official description:
You can now calculate the distance and area for data that is based on the round-Earth model. If your geometries have a spatial reference system that is based on angular units, you can calculate distance and area in meaningful linear units. Specify the appropriate unit of measure to convert angular units to linear units in the ST_Area, ST_Buffer, ST_Distance, ST_Length, and ST_Perimeter functions. You can specify predefined units of measure or define your own units of measure. The SE_Nearest function calculates distance between geometries that are in geographic coordinate systems by applying the linear unit of measure of meters.
Also, we've included the following enhancements:
See the Spatial Data User's Guide for details.
Check out this teaser video for the NoSQL meetup at the IIUG next week!
IngeHalilovic 060000MPB8 Tags:  storage compression timeseries management hertz database informix 2,006 Views
IBM® Informix® version 12.10.xC3 has a couple of new options for efficiently storing time series data:
If your time series data is recorded at a regular subsecond frequency, you can define a hertz time series to store the data efficiently, up to 255 data points per second. The way the hertz data is stored can save about 10 bytes per record.
If your time series data is recorded at a regular frequency and all the time series values are numeric, you can define a compressed time series to store the data efficiently. You can choose the type of compression and the margin of error. The compression ratio of the rest of the time series data varies depending on the type of data and the compression definitions. For example, you can compress an 8-byte BIGINT value down to 1 byte, with some loss of precision.
See Packed data for more information.
IngeHalilovic 060000MPB8 Tags:  database logs autonomic bufferpool configure installation server performance automatic parameters json informix administration 997 Views
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!