Preparing the Informix database server
Before you install Informix® Warehouse Accelerator, configure the database server.
Before you begin
Procedure
To configure the Informix database
server:
- Ensure that the user informix has write access to the sqlhosts file and the directory that the file is in.
- Define a SOCTCP network connection type in the sqlhosts file for the connection between the accelerator server and the database server.
- If you do not already have a default sbspace created and
configured, create the default sbspace:
- In the onconfig file, set the SBSPACENAME
configuration parameter to the name of your default sbspace.
For example, to name the default sbspace
sbsp1
:
You must update the onconfig file before you start the database server.SBSPACENAME sbspace1 # Default sbspace name
- 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. - Restart the Informix database server.
- In the onconfig file, set the SBSPACENAME
configuration parameter to the name of your default sbspace.
- 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
. - To add a single dwavp virtual processor for the database server
instance: