search cancel

CA-View - Mass Report Deletes

book

Article ID: 133396

calendar_today

Updated On:

Products

Deliver View

Issue/Introduction

There was an attempt to delete all of the AAA* reports from the View database, using the ERO table.

However, the reports did not get deleted. 

The ERO table was updated with: 

  /CPB* ALL DRETPD=0 RETPD=0 

 Is there a way to perform the mass delete of all the prefixed reports in batch?

Environment

Release : 12.2

Component : CA View

Resolution

Suggested to do the following:

 . Added a catch-all entry to the ERO table (/* ...)

 . Set SARINIT EROPRO=ALL and PRETAIN=TABLE

 . Recycle SARSTC

 . Run a View backup 

 At the backup, the desired reports were removed.