HCL Workload Automation, Version 9.4

Creating or upgrading the HCL Workload Automation database tables before installing or upgrading

Depending on the HCL Workload Automation component you install, the following database tables must be created or upgraded:
Master domain manager or backup master domain manager:
  • HCL Workload Automation tables
  • Dynamic workload broker tables.
Dynamic domain manager or backup dynamic domain manager:
Dynamic workload broker tables.

For a DB2® and Oracle database, the database schema can be created or upgraded at the same time as when you install or upgrade the product component using either the Installation Manager wizard or the silent installation, or you can choose to create or update the database schema manually, and then install and upgrade the component at a later time. The database administrator must run the manual procedure to create or upgrade the HCL Workload Automation database tables before the installation of HCL Workload Automation only when the IT administrator who installs the product does not know the database administrator user ID and password. Otherwise, the IT administrator provides the database administrator user ID and password during the installation and the tables are automatically created and upgraded during the installation or the upgrade of the product. Otherwise, the IT administrator provides the database administrator user ID and password during the installation and the tables are automatically created and upgraded during the installation or the upgrade of the product.

For Informix® Dynamic Server and Microsoft SQL Server databases, the database tables must be created or upgraded manually, and you must create or upgrade the HCL Workload Automation schema on these databases before you proceed to run the configuration script (described in Installing for an Informix Dynamic Server or in Installing for a Microsoft SQL Server database) after installing or upgrading the product.

Using this procedure, the database administrator creates or upgrades the database tables before the IT administrator installs or upgrades the product with a user different from the database administrator user. The procedure ensures that only the database administrator manages all the confidential information related to the database, such as the administrator user ID and password, and the IT administrator can install or upgrade the product without knowing any confidential database information.

This section describes the procedures to follow for creating and upgrading the HCL Workload Automation and the dynamic workload broker database tables before installing or upgrading HCL Workload Automation when using one of the following databases:
DB2
See Creating or upgrading the database schema if you are using DB2.
Oracle
See Creating or upgrading the database tables if you are using Oracle.
Informix Dynamic server
See Creating or upgrading the database schema if you are using Informix Dynamic Server.
Microsoft SQL Server
See Creating or upgrading the database schema if you are using Microsoft SQL Server.

To install HCL Workload Automation, the IT administrator can specify as the database administrator user name the user to be granted access by the administrator of the database server, to the HCL Workload Automation database.

To upgrade HCL Workload Automation, the IT administrator can specify another user that has the same permissions as the user who installed the product.