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.