IBM® Informix® Warehouse Accelerator, Version 12.10

Configuration

You must configure the accelerator server to work with the Informix® database server.

After you install Informix Warehouse Accelerator, there are several configuration steps that you must complete before it can accelerate queries.

Configuring Informix Warehouse Accelerator
You must configure the Informix Warehouse Accelerator before you can enable query acceleration and set up the connection between the accelerator server and the database server.
Configuring Informix Warehouse Accelerator for hardware clusters
You must configure Informix Warehouse Accelerator before you can enable query acceleration and set up the connection between the accelerator server and the database server. In a cluster system, one accelerator server coordinator node uses the first cluster node, and then each cluster node that you add to the cluster becomes an accelerator server worker node.
Configuring Informix Warehouse Accelerator on secondary servers in a high-availability environment
You can create data marts, load data mart data, and accelerate queries on one or more secondary servers in a high-availability cluster. By using secondary servers for Informix Warehouse Accelerator, you have greater flexibility in a mixed-workload environment. For example, you can dedicate the primary server for OLTP transactions and use a secondary server for processing the warehouse analytic queries. Configure the secondary servers by modifying the ONCONFIG file of each secondary server, connecting one of the secondary servers to an accelerator, and copying the sqlhosts entry in the sqlhosts file to each server in the cluster.
dwainst.conf configuration file
The dwainst.conf configuration file contains the parameters that are used to configure the accelerator server.
Configuring memory for Informix Warehouse Accelerator
To process queries efficiently, verify that you have the optimal configuration for the operating-system kernel parameters, shared memory, and swap space on the computer where Informix Warehouse Accelerator is installed. You can also monitor the virtual memory usage to see if you need to reduce the total size of the loaded data marts or add physical memory.
The ondwa utility
Use the ondwa utility to set up and work with the accelerator server.

Parent topic: Informix Warehouse Accelerator

Installing Informix Smart Analytics Optimizer Studio

Examples exchange | Troubleshooting

To find the PDF, see Publications for IBM Informix Warehouse Accelerator 12.10.
For the release notes, see the Release Notes topic.

Release date: March 2015