Updating Informix Warehouse Accelerator

When you install a database server fix pack, you must update the Informix® Warehouse Accelerator software to match the database server version.

Prerequisite: Make sure that all the data mart definitions are up to date in the accelerator server.
You can only update the Informix Warehouse Accelerator software to a version that corresponds to the database server. For example, if you are updating the Informix server from version 11.70.FC4 to 11.70.FC5, then you must update the Informix Warehouse Accelerator software to version 11.70.xC5.
  1. Drop all the data marts in the accelerator server.
    Make sure that you connect to the correct database when you drop the individual data marts.
  2. Stop the accelerator server by using the ondwa stop command.
  3. Run the ondwa clean command.
  4. Install the Informix Warehouse Accelerator update:
    1. Rename the installation directory to a different name. You will use the configuration files in the original installation directory to configure the new installation.
      By default Informix Warehouse Accelerator is installed in the directory that is specified by the INFORMIXDIR environment variable, if the INFORMIXDIR environment variable was set. Otherwise, the default installation directory is /opt/IBM/informix.
    2. Use the installer to install the new version.
      The installer will install the new version in the original installation directory.
  5. Configure Informix Warehouse Accelerator.
    The configuration file is dwainst.conf. Cluster configurations use an additional file, cluster.conf. Both files are located in the $IWA_INSTALL_DIR/dwa/etc directory.
    • To use the previous configuration, copy the configuration file or files from the original renamed installation directory to the new installation directory.
    • To take advantage of new capabilities in the updated version, merge the previous configuration file or files with the new default configuration files as needed.
  6. Run the ondwa setup command.
  7. Run the ondwa start command.
  8. Re-create and load the data marts.
  9. Optional: After you have tested the updated Informix Warehouse Accelerator installation, remove the original renamed installation directory.