IBM Workload Automation, Version 9.3

New method for updating DB2 and Oracle database schema

A new mechanism to update or upgrade the database schema for product upgrades and fix pack updates that eliminates the need for DB2® clients and, in general, provides a more dynamic, reliable and flexible method.

When creating, upgrading, or updating the master domain manager and its backup, or the dynamic domain manager and its backup, the database tables must also be created, upgraded, or updated.

If you typically update your database tables manually before updating the IBM Workload Scheduler 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.
For DB2 databases, this method eliminates the requirement of installing a DB2 client to update a database located on a remote DB2 server. The script works using the JDBC drivers and connecting directly to the database server minimizing the overhead in installing and maintaining a database client.
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.

Installing, updating, or upgrading the product components using either the Installation Manager wizard or the silent installation methods automatically upgrades the database tables using this same method.

For more information, see Creating or upgrading the IBM Workload Scheduler database tables before installing or upgrading.