Creating the database for Informix for the Dynamic Workload Console

Instructions for creating and populating the Dynamic Workload Console database for Informix

Before you begin

Before you create the database for Informix or OneDB , ensure you have created a db space sized 100 MB and with a page size of 8K or greater. When you run the configureDb command, as described below, specify this db space for the iwstsname parameter.

About this task

This picture describes the steps required for installing the Dynamic Workload Console. You are now at step 3: creating and populating the Dynamic Workload Console database.

You can perform a typical database procedure, as described in the following scenarios, or you can customize the database parameters, as described in FAQ - Database customizations.

You can run the configureDb command specifying a typical set of parameters. In this case, default values are used for all remaining parameters.

You can run the configureDb command specifying a typical set of parameters. In this case, default values are used for all remaining parameters.

For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDB script.

Default values are stored in the configureDbIds.properties file, located in image_location. If you need to modify any of the default values, edit the configureDbIdsdatabase_vendor.properties file, but do not modify the configureDbIdsdatabase_vendor.template file located in the same path.

To create the Dynamic Workload Console database and schema, perform the following steps:

Procedure

  1. On the server where you plan to install the Dynamic Workload Console, extract the Dynamic Workload Console package to a directory of your choice.
  2. Browse to the directory where you extracted the package.
  3. To populate the Dynamic Workload Console database with typical settings, type the following command:
    On UNIX operating systems
    ./configureDb.sh --rdbmstype IDS --dbname db_name -–dbuser db_user
        --dbhostname db_hostname --dbadminuser db_admin
        --dbadminuserpw db_admin_password
    Note: The following parameters specified with the configureDb command are also required when installing the Dynamic Workload Console and their values must be the same:
    • rdbmstype
    • dbhostname
    • dbport
    • dbname
    • dbuser

Results

You have now successfully created and populated the Dynamic Workload Console database.