Migrating DB2 reporting

The following procedure describes how to migrate reporting data to HCL Workload Automation for Z V9.5.

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, customize the EQQMIGRE sample by following the indications provided in its prolog section. In particular, if you are migrating from HCL Workload Automation for Z V9.3 or V9.5 GA change the name of the EQQDBMIG member to EQQDBM93.

DB2 for distributed environment (Windows, UNIX, Linux)

Run the following scripts, which you find on the installation CD described in the HCL Workload Automation for Z: 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 Dynamic Workload Console.