Welcome
Data warehousing
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
Informix® Warehouse Accelerator
Installation
You can install Informix® Warehouse Accelerator on the same computer as the Informix database server, on a separate computer, or on a cluster (including a high-availability cluster).
Updating Informix® Warehouse Accelerator
When you install a database server fix pack, you must update the Informix® Warehouse Accelerator software to match the database server version.

HCL Informix® V15.0 documentation
Welcome to the documentation for HCL Informix® 15.0 and related client tools and products.
Product overview
HCL Informix® is a fast and scalable database server that manages traditional relational, object-relational, and dimensional databases. Its small footprint and self-managing capabilities are suited to embedded data-management solutions.
Installing
These topics describe how to install HCL Informix® database servers, client products, and DataBlade® modules.
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Migrating and upgrading
You can upgrade to the 15.0 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
Embedding Informix®
When you embed HCL Informix®, you can use enterprise-class high-availability and high performance with embeddability features such as easy programmability, a small disk and memory footprint, and silent deployment.
Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix.
Data warehousing
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
- Dimensional databases
  These topics provide information to help you design, implement, and manage dimensional databases, and describes the tools that you can use to create data warehouses and optimize your data warehouse queries.
- Informix® Warehouse Accelerator
  - Overview of Informix® Warehouse Accelerator
    Informix® Warehouse Accelerator is a product that you use to improve the performance of your warehouse queries.
  - Installation
    You can install Informix® Warehouse Accelerator on the same computer as the Informix database server, on a separate computer, or on a cluster (including a high-availability cluster).
    - Informix® Warehouse Accelerator prerequisites and requirements
      Ensure that your system meets the prerequisites and the requirements for Informix® Warehouse Accelerator. You must have certain utilities installed. Cluster installations have additional requirements.
    - Informix® Warehouse Accelerator directory structure
      When you install and set up Informix® Warehouse Accelerator, there are several directories that are needed.
    - Preparing the Informix® database server
      Before you install Informix® Warehouse Accelerator, configure the database server.
    - Verifying the Informix® database server environment
      You can use the ondwachk script to confirm that the Informix® database server environment is set up correctly for Informix Warehouse Accelerator and that the database server can connect to the accelerator server.
    - Installing Informix® Warehouse Accelerator
      You can use the graphical mode, console mode, or silent mode to install Informix® Warehouse Accelerator.
    - Uninstalling Informix® Warehouse Accelerator
      If you need to reinstall the Informix® Warehouse Accelerator or if you no longer want to use Informix Warehouse Accelerator, you must uninstall it.
    - Updating Informix® Warehouse Accelerator
      When you install a database server fix pack, you must update the Informix® Warehouse Accelerator software to match the database server version.
  - Configuration
    You must configure the accelerator server to work with the Informix® database server.
  - Create an accelerator
    You create an accelerator by connecting the Informix® database server to the accelerator server.
  - Data marts and AQTs
    For efficient query processing, the accelerator server must have its own copy of the data. The data is stored in logical collections of related data, or data marts. A data mart specifies the collection of tables that are loaded into an accelerator and the relationships, or references, between these tables.
  - Data marts and AQTs
    For efficient query processing, the accelerator server must have its own copy of the data. The data is stored in logical collections of related data, or data marts. A data mart specifies the collection of tables that are loaded into an accelerator and the relationships, or references, between these tables.
  - Turning on query acceleration
    Before queries can be routed to the accelerator server for processing, you must set the use_dwa session environment variable.
  - SQL administration routines
    You can use the Informix® Warehouse Accelerator functions and procedures from the command line or in an application to automate administration tasks.
  - Reversion requirements for an Informix® warehouse server and Informix® Warehouse Accelerator
    If you revert the HCL Informix® server to an earlier version, you must drop all of the data marts. If you created data mart definitions by using workload analysis, you must drop all of the tables that were created by the probe2Mart() procedure.
  - Troubleshooting
  - Sample warehouse schema
    The Informix® Warehouse Accelerator examples use this sample warehouse schema.
  - Sysmaster interface (SMI) pseudo tables for query probing data
    The SMI tables provide a way to access probing data in a relational form, which is most convenient for further processing.
  - Supported locales
    Informix® Warehouse Accelerator supports a subset of the locales that HCL Informix supports.
Designing databases
The first step in creating a relational database is to construct a data model, which is a precise, complete definition of the data you want to store. After you prepare your data model, you must implement it as a database and tables. To implement your data model, you first select a data type for each column and then you create a database and tables and populate the tables with data. You can also implement fragmentation strategies and control access to your data.
JSON compatibility
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
Security
You can secure your Informix® database server and the data that is stored in your Informix databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
Troubleshooting HCL Informix®
Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter in your HCL Informix® database server environment.

Updating Informix® Warehouse Accelerator

When you install a database server fix pack, you must update the Informix® Warehouse Accelerator software to match the database server version.

Before you begin

Prerequisite: Make sure that all the data mart definitions are up to date in the accelerator server.

About this task

You can only update the Informix® Warehouse Accelerator software to a version that corresponds to the database server. For example, if you are updating the Informix® server from version 11.70.FC4 to 11.70.FC5, then you must update the Informix® Warehouse Accelerator software to version 11.70.xC5.

Procedure

Drop all the data marts in the accelerator server.
Make sure that you connect to the correct database when you drop the individual data marts.
Stop the accelerator server by using the ondwa stop command.
Run the ondwa clean command.
Install the Informix® Warehouse Accelerator update:
1. Rename the installation directory to a different name. You will use the configuration files in the original installation directory to configure the new installation.
  By default Informix® Warehouse Accelerator is installed in the directory that is specified by the INFORMIXDIR environment variable, if the INFORMIXDIR environment variable was set. Otherwise, the default installation directory is /opt/IBM/informix.
2. Use the installer to install the new version.
  The installer will install the new version in the original installation directory.
Configure Informix® Warehouse Accelerator.
The configuration file is dwainst.conf. Cluster configurations use an additional file, cluster.conf. Both files are located in the $IWA_INSTALL_DIR/dwa/etc directory.
- To use the previous configuration, copy the configuration file or files from the original renamed installation directory to the new installation directory.
- To take advantage of new capabilities in the updated version, merge the previous configuration file or files with the new default configuration files as needed.
Run the ondwa setup command.
Run the ondwa start command.
Re-create and load the data marts.
Optional: After you have tested the updated Informix® Warehouse Accelerator installation, remove the original renamed installation directory.