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:
- 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: