Preparing the Informix database server

Before you install Informix® Warehouse Accelerator, configure the database server.

To configure the Informix database server:

1. Ensure that the user informix has write access to the sqlhosts file and the directory that the file is in.
2. Define a SOCTCP network connection type in the sqlhosts file for the connection between the accelerator server and the database server.
3. If you do not already have a default sbspace created and configured, create the default sbspace:
   1. In the onconfig file, set the SBSPACENAME configuration parameter to the name of your default sbspace. For example, to name the default sbspace sbsp1:

      SBSPACENAME sbspace1  # Default sbspace name

      You must update the onconfig file before you start the database server.
   2. Use the onspaces command to create the sbspace.
      The following example creates an sbspace named sbspace1:

      onspaces -c -S sbspace1 -p $INFORMIXDIR/tmp/sbspace1 -o 0 -s 30000

      Note: The size of the sbspace can be relatively small, for example 30 - 50 MB.
   3. Restart the Informix database server.
4. Optional: Add a dwavp virtual processor. If not explicitly added, a single dwavp virtual processor is dynamically allocated when the first Informix Warehouse Accelerator related activity occurs.
   • To add a single dwavp virtual processor for the database server instance: onmode -p +1 dwavp.
   • To permanently add a single dwavp virtual processor, add the following entry to the VPCLASS parameter in the onconfig file: VPCLASS dwavp,num=1.
   Tip: In systems with significant data mart administration activity, you can define two dwavp virtual processors to avoid the delay of other administrative commands while loading data marts. For example, to add two dwavp virtual processors for the database server instance: VPCLASS dwavp,num=2.