Upgrading the database for the Dynamic Workload Console

By default, the installation script is configured to install and use a Derby database. Alternatively, you can also choose to use any one of the supported databases.

About this task

Creating and populating the Dynamic Workload Console database

If you are using the default database Derby, you can skip this step. If you are using a database other than Derby, upgrade the existing database tables to work with the Dynamic Workload Console by performing the following steps:

Procedure

  1. Browse to the configureDb command provided with the 10.2.2 image, which is located in image_location/TWS/interp_name.
  2. To update the database version, run the following command:
    On Windows operating systems
    cscript configureDb.vbs --rdbmstype db_type --dbhostname db_hostname --dbport db_port --dbname db_name --dbuser db_user --dbpassword db_password --dbadminuser db_administrator --dbadminuserpw db_administrator_password
    On UNIX operating systems
    ./configureDb.sh --rdbmstype db_type --dbhostname db_hostname --dbport db_port --dbname db_name --dbuser db_user --dbpassword db_password --dbadminuser db_administrator --dbadminuserpw db_administrator_password
    On z/OS operating systems
    ./configureDb.sh --rdbmstype db_type --dbhostname DB_hostname
--dbport db_port --dbname db_name --dbuser db_user
--dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
--zlocationname zOS_location_containing_db --zbufferpoolname buffer_pool_in_zOS_location
    For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDB script.

Results

You have now upgraded the database tables to work with the Dynamic Workload Console version 10.2.2.

What to do next

You can now proceed to Installing the Dynamic Workload Console.