Creating the database in the z/OS environment

To set up the DB2 database installed on your z/OS system for creating reports with the Dynamic Workload Console, use the samples generated by EQQJOBS in your sample job JCL data set:
  • Customize the EQQINIRE JCL sample by following the indications provided in its prolog section.
  • Edit the EQQDBREP sample by modifying the table prefix (default is MDL). This action is also required if you modified the names of the database or tablespace in EQQINIRE.
EQQINIRE triggers member EQQDBREP, which contains the SQL statements required to create the database and the following DB2 tables, including the constraints, indexes, and views related to these tables:
DB2TablePrefix.JOS_JOB_STATISTICS
Used to store statistics run data, where DB2TablePrefix is, by default, MDL. You can modify this default by editing EQQDBREP.
DB2TablePrefix.JHR_JOB_HISTORY_RUNS
Used to store job run data, where DB2TablePrefix is, by default, MDL. You can modify this default by editing EQQDBREP.