This second article in the Easy IWA series details how to create an Accelerator under IBM Informix 12.10.FC4 Workgroup and Advanced editions. Worked examples to establish initial memory requirements are provided, which is key to effective and efficient resource usage and ensuring that initial provisions are reasonable. The Accelerator provides the interface between IBM Informix and the Warehouse Accelerator, performing mart administration and query processing.
Before creating and initialising an accelerator there are several considerations that should be made and requirements established and satisfied:
Setup and initialisation of IBM Informix Warehouse Accelerator is a straight forward process, however, it is critical to understand the shared memory resource requirements that will be made by an Accelerator which are entirely dependent on Data Mart design and the number of allocated
WORKER processes, along with the complexity of the query being processed which will have an impact on the private memory requirements beyond shared memory. This article attempts to provide a straight forward and clear guide to initial IWA instantiation and explain how the Accelerator configuration in conjunction with Data Mart design impacts on resource usage.
The code fix suggested above is provided “as is” without warranty of any kind, either express or implied, including without limitation any implied warranties of condition, uninterrupted use, merchantability, fitness for a particular purpose, or non-infringement.