HCL Informix® tutorials and examples

You can learn how to use some of the features and functionality of HCL Informix® by using tutorials, examples, and recorded demonstrations.

Administration

Optimize data storage with the SQL administration API: This example shows how to estimate how much space you can save by compressing data, how to create a compression dictionary, and how to compress data. It also shows how to decompress data and remove the compression dictionary.

Manage storage devices with Informix® Primary Storage Manager: Learn how to set up and use Informix® Primary Storage Manager to manage storage devices that the onbar utility uses for backing up and restoring instances. Each example shows a specific backup strategy:

• Storing backups for an instance.
• Storing backups for two instances.
• Exporting backups to, and restoring them from, a directory.
• Exporting backups from one server, and importing them to another server.

Replication

Enterprise Replication examples: These examples show how to set up replication systems with the cdr command-line utility. They do not require a Connection Manager. Each example builds on the previous example to set up the following replication systems:

• Primary-target replication
• Update-anywhere replication
• High-availability clusters in a hierarchical tree topology

Connection Manager configuration examples: These examples show how to configure connection management, using Connection Manager technology, for high-availability clusters and replication systems.

Set up a replication system with a grid: This example shows how to set up a replication domain, create a grid, create a database, create a replicated table, and load data.

Roll out schema changes in a grid: This example shows how to alter the data types of columns in five tables, and to roll out schema changes without application downtime.

Server deployment

Deploy Informix®: This tutorial shows how to deploy a snapshot of the Informix® database server by using the deployment utility.

Informix® extensions

TimeSeries extension: These examples show how to configure database objects for specific types of time series data.

• Create and load a regular time series
• Create and load a hertz data time series
• Create and load a compressed data time series
• Create and load a time series with JSON data

Informix® extensions

Create and load a time series: This example shows how to create a TimeSeries data type, create a time series table, create a time series by using the TSCreate procedure, and load data into the time series by using the Informix® TimeSeries Plug-in for Data Studio.

JSON compatibility

Create a time series through the wire listener: This example shows how to create, load, and query a time series with the REST API or the MongoDB API through the wire listener.

Warehousing

Informix® Warehouse Accelerator: These examples show how to use Informix® Warehouse Accelerator for in-memory acceleration of data mart queries:

• Create a data mart from the command line
• Create a data mart for time series data
• Continuously refresh accelerated time series data
• Accelerate data from JSON collections

Warehousing

Create a data mart for Informix® Warehouse Accelerator: This example shows how to create, deploy, and load a data mart from the command line by using workload analysis.

For more information, see https://academy.actian.com.