Creating or upgrading the database tables if you are using DB2
To create or upgrade the Tivoli Workload Scheduler and the Tivoli dynamic workload broker database tables if you are using DB2.
To create or upgrade the Tivoli Workload Scheduler and
the Tivoli dynamic workload broker database
tables if you are using DB2,
run the following procedures:
- Customize the properties file. See Customizing the properties file for DB2.
- Generate the SQL files. See Generating the SQL files for DB2.
- Run the Procedure to create the Tivoli Workload Scheduler SQL tables for DB2.
Important:
- Run the procedure only if the database administrator manages all the confidential information that is related to the database, such as the database administrator user ID and password and the IT administrator who upgrades the product does not know them.
- After upgrading, to grant permissions to users on the updated
database views, you must run the script:
- On Windows operating systems
<TWA_home>/TWS/dbtools/DB2/scripts/dbgrant.bat <user_ID_to_be_granted> <database_name> [<database_admin_user> <password>]- On UNIX and Linux operating systems
/<TWA_home>/TWS/dbtools/DB2/scripts/dbgrant.sh <user_ID_to_be_granted> <database_name> [<database_admin_user> <password>]