Requirement to submit a Plan Analyzer report by a batch job

Products

• Plan Analyzer for DB2 for z/OS

Issue/Introduction

On the Plan Analyzer for Db2 for z/OS (PPA) online screen, the SQL STATEMENT REPORT can be seen from
the PPA PACKAGE REPORTS MENU.  Can the same report information be seen by a batch job?

Resolution

Online report of the Plan Analyzer can be executed via a batch job.

For submitting a batch job for Plan Analyzer report:
1. Specify "BATCH" command in the command line of the the Plan Analyzer screen (Ex. "PPA PACKAGE REPORTS MENU" screen) and enter.
2. Then, the "PPA BATCH REPORTING JOB SUBMISSION" panel appears. 
3. In the "PPA BATCH REPORTING JOB SUBMISSION" panel, the jobcard information and sysout class should be specified and select option.