Can PDTBATCH generate a report of the top 10 programs within a plan, of the highest CPU users?

Document ID : KB000044495
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction: 

This document states whether or not PDTBATCH can generate a report of the top 10 programs within a plan, of the highest CPU users.

Question: 

Can PDTBATCH generate a report of the top 10 programs within a plan, of the highest CPU users?

Environment:  

z/OS 1.11 and above.

Answer: 

PDTBATCH is designed to provide general, but not customized reports. It can provide a single, or multi-interval Standard Activity:

1) Report of the top 10 plans & all of their corresponding packages & their SQL Calls in descending CPU order

2) Report of the top 10 packages & their SQL Calls in descending CPU order. However, the Plan is not displayed

Also, a single interval report of the top 10 CPU using exceptions in descending order, including their Plan, Program & UserID.

Further customized reports can only be generated by unloading the Datastore information into DB2 tables & creating SQL queries