Home
Data warehousingIn 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 AcceleratorThe Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).
Troubleshooting
Ensuring a result set includes the most current dataOccasionally 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.

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.

About this task

The data that is stored on the accelerator server is a snap-shot of the data on the database server. If you need to ensure that a query result set includes the most current data, turn off acceleration, run the query, and turn on acceleration again:

Procedure

Specify the SET ENVIRONMENT use_dwa 'accelerate off' statement at the beginning of the query to turn off acceleration. Setting this variable ensures that the query is processed by the Informix® database server and not processed by the accelerator server.
Add the statement SET ENVIRONMENT use_dwa 'accelerate on' at the end of the query to activate acceleration again.
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.