Can Detector PDTBATCH generate a report of the top 10 programs within a plan of the highest CPU users.

Products

• Detector for DB2 for z/OS

Issue/Introduction

Can Detector for Db2 for z/OS (PDT) PDTBATCH generate a report of the top 10 programs within a plan of the highest CPU users?

Resolution

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 and all of their corresponding packages and their SQL Calls in descending CPU order.
2. Report of the top 10 packages and 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 and UserID.

Further customized reports can only be generated by unloading the Datastore information into PDT Db2 tables and creating SQL queries