Running a Plan Analyzer report within an Endevor processor.

book

Article ID: 52814

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS CA PanAudit Plus CA Easytrieve Report Generator CA PAN/SQL CA Endevor Software Change Manager (SCM) CA Endevor Software Change Manager - Natural Integration (SCM) CA Endevor Software Change Manager - ECLIPSE Plugin (SCM) CA Endevor Software Change Manager - Enterprise Workbench (SCM) CA 2E

Issue/Introduction

Description:

In order to intercept the output of Unicenter 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.

Solution:

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 CA 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)

Environment

Release:
Component: C21E