How to create a Drop Impact report in Batch within RC/Query
search cancel

How to create a Drop Impact report in Batch within RC/Query

book

Article ID: 48662

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

Generating a RC/Query for Db2 for z/OS (RCQ) 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.

Resolution

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.

Powered by Wolken Software