Running a Plan Analyzer report within an Endevor processor

Products

• Plan Analyzer for DB2 for z/OS

Issue/Introduction

In order to intercept the output of Plan Analyzer for Db2 for Z/OS (PPA) into an Endevor processor, the output should be stored into a sequential dataset
previously initialized by the Endevor BC1PDSIN program.

This dataset should be specified with a DCB of RECFM=FB,LRECL=80, BLKSIZE=6160.

Resolution

As a default the PPA output is managed using control .LIST SYSOUT(*) in the Batch Processor input cards.
In order to write an output to a user's data set the Batch Processor input cards have to be .LIST DDNAME(ddname).
This DDNAME should point to the dataset you want to write your output to.
However, in Endevor to be able to add an output to a listing dataset, you have to pre-allocate the output dataset using the PGM=BC1PDSIN program.
BC1PDSIN Initializes any number of allocated data sets that begin with ddname C1INIT.
This utility is generally used to allocate list data sets (see Endevor Change Manager Extended Processors Guide).


A sample JCL for the BC1PDSIN utility is shown below:

//STEPNAME EXEC PGM=BC1PDSIN
//C1INITxx  DD DSN=&&COBLST,DISP=(,PASS,DELETE),
//              UNIT=SYSDA,SPACE=(TRK,(1,2),RLSE),
//              DCB=(RECFM=FBA,LRECL=121,BLKSIZE=3630,DSORG=PS)
//C1LISTxx DD DSN=&&LNKLST,DISP=(,PASS,DELETE),
//              UNIT=SYSDA,SPACE=(TRK,(1,2),RLSE),
//              DCB=(RECFM=FBA,LRECL=121,BLKSIZE=3630,DSORG=PS)

In order to initialize the PPA output dataset, the DCB should be:

 //           DCB=(RECFM=FB,LRECL=80, BLKSIZE=6160)