HCL Workload Automation, Version 9.4

Creating or upgrading the database tables if you are using Oracle

To create or upgrade the HCL Workload Automation and the dynamic workload broker database tables if you are using Oracle.

When you are creating or upgrading the HCL Workload Automation and the dynamic workload broker database tables if you are using Oracle, run the following procedures:

Creating the database tables for Oracle

To create the HCL Workload Automation and the dynamic workload broker database tables if you are using Oracle, run the following procedures:
  1. Customize the properties file. See Customizing the properties file for Oracle.
  2. Generate the SQL files. See Generating the SQL files for Oracle.
  3. Create or upgrade the SQL tables. See Running scripts to create or upgrade the SQL tables for Oracle.
See Creating the database tables if you are using Oracle for the complete procedure.

Upgrading the database tables for Oracle

A new method for upgrading the HCL Workload Automation and the dynamic workload broker database schema is provided for Oracle. The update or upgrade can be performed manually before you install the product component or, using the Installation Manager wizard or silent installation, the schema is updated during the installation procedure.

If you typically update your database tables manually before updating the HCL Workload Automation components in your environment, then you can use this new method which includes a script that quickly generates the required SQL statements in an SQL file and optionally applies them directly to the database in a single step.

The advantages of this new update method are:
  • A single script that dynamically generates the SQL statements and applies them directly to the database. Optionally, you can configure the script to generate only and then apply them at a later time but before installing the product component.
  • The script can be run and rerun as many times as needed without any cleanup required between runs. For example, if for some reason a database object is corrupt, you can rerun the script to regenerate the SQL file and apply it.
  • Use this method as a stand-alone tool to check the consistency of the database schema. The database administrator can verify if the database schema has changed and repair any inconsistencies.
Upgrading the product components using either the Installation Manager wizard or the silent installation methods automatically upgrades the database tables using this same method.
Upgrading the database schema for Oracle using this method involves the following high-levels steps:
  1. Modify the upgradeOracleIWSDB.properties file assigning the appropriate values to the parameters.
  2. Run the launchUpgradeIWSDB.bat or the launchUpgradeIWSDB.sh script to generate and apply the SQL statements. Optionally, you can choose to only generate the statements and apply them later, but before installing the product component.
See Upgrading the database tables if you are using Oracle for the complete procedure.
Parent topic: Creating or upgrading the HCL Workload Automation database tables before installing or upgrading