Tivoli Workload Automation, Version 9.2

Creating or upgrading the Tivoli Workload Scheduler database tables before installing or upgrading

Before installing or upgrading create or upgrade the Tivoli Workload Scheduler database tables.

Depending on the Tivoli Workload Scheduler component you installed, you must manage the following tables:

Master domain manager or backup master domain manager:

Tivoli Workload Scheduler tables
Dynamic workload broker tables.

Dynamic domain manager or backup dynamic domain manager:

Dynamic workload broker tables.

The procedure to create or upgrade the Tivoli Workload Scheduler and Dynamic workload broker is not mandatory for the installation or upgrade of the product.

The database administrator must run the procedure to create or upgrade the product database tables before the installation of the product 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.

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 chapter describes the procedure to follow if you want to:

Create and upgrade the Tivoli Workload Scheduler and the Tivoli dynamic workload broker database tables before installing or upgrading the product if you are using DB2. See Creating or upgrading the database tables if you are using DB2.
Create and upgrade the Tivoli Workload Scheduler and the Tivoli dynamic workload broker database tables before installing or upgrading the product if you are using Oracle. See Creating or upgrading the database tables if you are using Oracle.

The IT administrator can perform:

The installation, specifying as database administrator user name the user to be granted access, by the administrator of the DB2 server, to the Tivoli Workload Scheduler database.
The upgrade, by using another user that has the same permissions as the user that installed the product.