Migrating DB2 reporting

The following procedure describes how to migrate reporting data from IBM® Z Workload Scheduler V9.3. If you are migrating from V9.5 with APAR PH30466 installed, you do not need any migration action for the reporting data.

According to the environment where you are using DB2, perform the following steps:
DB2 for z/OS environment
Use the samples generated by EQQJOBS in your sample job JCL data set.

To migrate the tables and views, submit the EQQMIGRE sample by following the indications provided in its prolog section.

DB2 for distributed environment (Windows, UNIX, Linux)

Run the following scripts, which you find on the installation CD described in the IBM Z Workload Scheduler: Memo to Users.

These scripts update the JHR_JOB_HISTORY_RUNS and JOS_JOB_STATISTICS tables by adding new columns. The related views are also updated with the corresponding changes.

dbmigrate.bat (for Windows)
dbmigrate.sh (for UNIX and Linux)
Run the following command: 
dbmigrate dbName db2Admin db2AdminPwd
where the parameters are positional and indicate the following:
dbName
Name of the database to be used for the reporting feature.
db2Admin
DB2® administrator user ID.
db2AdminPwd
DB2® administrator password.

Migrating DB2 for the Dynamic Workload Console

If you had previously installed the Dynamic Workload Console with a DB2 database, to migrate the database see Performing a direct upgrade of the Dynamic Workload Console and its database.