How do I create a Drop Impact report in Batch?

book

Article ID: 48662

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

Issue/Introduction

Description:

Generating a Drop Impact report at a database or multiple database level can result in hundreds of lines of report output.
This is not something that can realistically be cut and pasted into a report.

Solution:

This can be accomplished using the following steps:

  1. In RC/Query, enter BR (for batch reporting)
  2. Specify the Batch dataset
  3. Select DB2 Object: (EX; DB)
  4. Select Option: DI (for Drop Impact)
  5. Specify the database name under ITEM NAME and the CREATOR and S for Drop IMP

You can then submit the batch job or it will just write the JCL to the dataset for later submission.

Environment

Release: ENDV2A00200-14.5-Endevor-SCM Interface-for DB2 for z/OS
Component: