How do I create a Drop Impact report in Batch?
search cancel

How do I create a Drop Impact report in Batch?

book

Article ID: 48662

calendar_today

Updated On:

Products

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

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:
Powered by Wolken Software