Creating and populating the database for PostgreSQL or PostgreSQL cloud-based databases for the Dynamic Workload Console

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

Ensure you have performed the following tasks:
  • Create the PostgreSQL database and ensure it is configured to allow remote connections. To create the database, use the following command:
    create database <database_name> with lc_collate='C' template=template0;
    This command creates the database with the collation feature enabled.
  • Create a user dedicated specifically to the new database schema and do not use the administrator user (postgres) for this purpose.
For more information about allowing remote connections and creating users, see the PostgreSQL documentation.
This picture describes the steps required for installing the master domain manager. You are now at step 3: creating and populating the Dynamic Workload Console database
PostgreSQL cloud-based databases include the following:
  • Amazon RDS for Postgres
  • Google Cloud SQL for Postgres

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 optionally configure PostgreSQL in SSL mode on UNIX operating systems by specifying the sslkeysfolder and sslpassword parameters when you run the configureDb command. For more information, see How can I use certificates when Db2 or PostgreSQL is in SSL mode?

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 configureDbPostgresql.properties file, located in image_location. If you need to modify any of the default values, edit the configureDbPostgresql.properties file, but do not modify the configureDbPostgresql.template file located in the same path. For an example of a properties file, see What is the content of a database properties file?.

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

  1. On the workstation 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 path image_location/TWS/interp_name.
  3. Type the following command to create and populate the Dynamic Workload Console database tables with typical settings:
    On Windows operating systems
    cscript configureDb.vbs --rdbmstype POSTGRESQL --dbhostname DB_hostname 
--dbport db_port --dbname db_name --dbuser db_user 
--dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
    On UNIX operating systems
    ./configureDb.sh --rdbmstype POSTGRESQL --dbhostname DB_hostname 
--dbport db_port --dbname db_name --dbuser db_user 
--dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
    where:
    --rdbmstype
    The database vendor.
    --dbhostname db_hostname
    The host name or IP address of database server.
    --dbport db_port
    The port of the database server.
    --dbname db_name
    The name of the Dynamic Workload Console database.
    --dbuser db_user
    The database user you must create before running the configureDb command. Hyphens are not supported. When you run the configureDb command, this user is automatically granted access to the Dynamic Workload Console tables on the database server.
    --dbadminuser db_admin_user
    The database administrator user that creates the Dynamic Workload Console schema objects on the database server.
    --dbadminuserpw db_admin_password
    The password of the DB administrator user that creates the Dynamic Workload Console schema objects on the database server. Special characters are not supported.
    Note: The following parameters specified with the configureDb command are also required when installing theDynamic Workload Console and their values must be the same:
    • --rdbmstype
    • --dbhostname
    • --dbport
    • --dbname
    • --dbuser

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

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

You can now proceed to Creating the IBM Workload Scheduler administrative user.