Jump to main content
Product Documentation
Customer Support
HCL Informix V14.10
HCL Informix®
V
14.10
documentation
Product overview
Installing
Administering
Migrating and upgrading
Client APIs and tools
Embedding
Informix®
Extending
Informix®
Data warehousing
Designing databases
JSON compatibility
Security
SQL programming
Troubleshooting
Informix®
Informix PDF guides
Search
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. The resources that are external to the information center are marked as such.
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).
Troubleshooting
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. The resources that are external to the information center are marked as such.
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).
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
Missing sbspace
If you do not have a default sbspace created in the
Informix®
database server and you attempt to install
Informix® Warehouse Accelerator
, an error is returned.
Ensuring a result set includes the most current data
Occasionally you want a specific query to access the most current data, which is stored on the database server. You can turn off acceleration temporarily to run the query.
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.
Troubleshooting
Missing sbspace
If you do not have a default sbspace created in the
Informix®
database server and you attempt to install
Informix® Warehouse Accelerator
, an error is returned.
Ensuring a result set includes the most current data
Occasionally you want a specific query to access the most current data, which is stored on the database server. You can turn off acceleration temporarily to run the query.
Rate this topic
5 stars
4 stars
3 stars
2 stars
1 star
Comment on this topic.
By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at
https://hcltechsw.com/resources/us-government-contact
. Do not include any personal data in this Comment box.