When submitting a Database Analyzer for Db2 Extract there are two places to enter the "J" or "D" options for JCL destination
search cancel

When submitting a Database Analyzer for Db2 Extract there are two places to enter the "J" or "D" options for JCL destination

book

Article ID: 53257

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS

Issue/Introduction

Submitting a Database Analyzer for Db2 for z/OS (PDA) Extract there are two places to enter the "J" or "D" options for JCL destination.

Resolution

Enter PF1 on the two screens described to get online help information for these fields.

The two "destination" entries relate to two different JCLs that are created.

The first entry on "SUBMIT - BUILD JCL PARAMETERS" screen determines whether action JCL that will be generated, (if selected) will be saved to dataset or executed when created.
If "Create Action JCL" is set to "N" on this screen then the "Action JCL Destination" entry will be ignored.

The second entry on "Batch JCL Specification" screen determines whether the PDA job JCL that will be generated as a result of submitting the extract procedure
will be executed immediately, copied to a dataset or previewed on screen.

For Example.
Have an extract procedure that is tied to an Action procedure to generate a reorg.
If submit the extract procedure this will generate PDA job JCL.
When run this PDA job will generate Reorg JCL for the objects selected in the extract procedure.

The "Action JCL Destination" entry on panel id "RAPESMN" specifies what to do with the reorg JCL.
The "DESTINATION" entry on panel id "PTPBMOD" specifies what to do with the PDA job JCL.