Creating or upgrading the IBM Workload Scheduler database tables before installing or upgrading
- Master domain manager or backup master domain manager:
- IBM Workload Scheduler tables
- Dynamic workload broker tables.
- Dynamic domain manager or backup dynamic domain manager:
- Dynamic workload broker tables.
For DB2® and Oracle,
the procedure to create or upgrade the IBM Workload Scheduler and Dynamic workload broker database
tables described in this section is not mandatory for the installation
or upgrade of IBM Workload Scheduler.
The database tables can be created or upgraded at the same time as
when you install or upgrade the component when you choose the Installation
Manager wizard or silent installation methods. The database administrator
must run the manual procedure to create or upgrade the IBM Workload Scheduler database
tables before the installation of IBM Workload Scheduler 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.
For Informix® Dynamic
Server and MicroSoft SQL Server, this manual procedure
is mandatory, and you must create or upgrade the IBM Workload Scheduler 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.
- DB2
- See Creating or upgrading the database tables 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 IBM Workload Scheduler,
the IT administrator can specify as database administrator user name
the user to be granted access by the administrator of the database
server, to the IBM Workload Scheduler database.
To upgrade IBM Workload Scheduler,
the IT administrator can specify another user that has the same permissions
as the user who installed the product.