Check out this teaser video for the NoSQL meetup at the IIUG next week!
Appropriate Content: Informix Documentation Team
IngeHalilovic 060000MPB8 Tags:  storage compression timeseries management hertz informix database 1,586 Visits
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 837 Visits
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!