Verifying the Informix database server environment

You can use the ondwachk script to confirm that the Informix® database server environment is set up correctly for Informix Warehouse Accelerator and that the database server can connect to the accelerator server.

Before you begin

Prerequisites:
  • You must be logged on as user informix.
  • The environment of the Informix server instance is set.

About this task

The ondwachk script is part of the Informix server installation and is located in the $INFORMIXDIR/bin directory.

The ondwachk script verifies the following Informix server instance prerequisites for Informix Warehouse Accelerator:
  • The Informix and accelerator versions match
  • The sbspace is added to Informix
  • The SBSPACENAME configuration parameter is configured correctly in the onconfig file
  • The listen thread for SOCTCP is running
  • The dwavp virtual processor is running on the standard or primary server if the scheduler is stopped
  • There is a writable sqlhosts file and directory
  • An entry for an accelerator is included in the sqlhosts file
  • For secondary servers only:
    • The dwavp virtual processor is running
    • The secondary server can be updated

Procedure

To verify the Informix database server environment:
Run the ondwachk script.