Home
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
The Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).
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).

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
  The Informix® Data Warehouse Guide provides 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
  The Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).
  - 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.
  - 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.
  - 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 Informix Warehouse Accelerator
  - 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.

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).

Important: Only one instance of Informix® Warehouse Accelerator can be installed on a computer.

Before you install the Informix® Warehouse Accelerator, ensure that your computers meet the software and hardware prerequisites, and that you have decided which architecture you want to implement.