z/OS DB2 Utility WorkloadThe DB2 Utility Workload consists of four separate jobs that can be run separately or in sequence.
- a setup job that drops and recreates an empty database
- a job to load records into the empty database
- a job to reorganize the data in a fully populated database
- a job to create run statistics for a fully populated database
A REXX EXEC is used to create unique combinations of these 4 independent jobs.
For our specialty engine DB2 Utility Workload, the REXX EXEC contained 4 executions of the setup job followed by the load job.
At the end of the each execution, these jobs provide information about the number of records processed and the elapsed time to complete. A quantitative transaction rate can thus be calculated for any measurement.