How do I create a Drop Impact report in Batch?


Article ID: 48662


Updated On:


RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS



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.


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.


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