How to create a report on data sets that should not be in the Master Catalog?

book

Article ID: 105633

calendar_today

Updated On:

Products

CA Vantage Storage Resource Manager

Issue/Introduction

The customer needs a report that lists all data sets that should not be in their Master Catalog (MCAT).
As a starting point, they would review all entries in the Master Catalog which are not for SYS1.** data sets.
They probably have other data sets, other than SYS1.**, that are okay to be there, 
but if they can start with that list, then they would be able to pare it down. 

How to create a report on data sets that should not be in the Master Catalog?

Environment

Release:
Component: VANT

Resolution

1) User View
Create a corresponding User View based on the BCS Data Set Entries (CATALOGF) object in the Vantage GUI: 
=> Catalog Mangament 
  => BCS Data Set Entries  
and apply the following filter:  
 CATNAVN = mastercat.name AND CATDSN EXCL (SYS1./) AND CATVOL EXCL ?ALIAS
This will list all data sets cataloged in the Master Catalog not being SYS1.** data sets.    
Save the filter and check the result. 
Refine the filter as needed.
Finally, save the view as a User View, e.g. MCATLIST. 

2) GOA Script
If you want to schedule this report, create a corresponding GOA script (e.g. MCATLIST) via the GOA Wizard: 
=> right-click on "BCS Data Set Entries" in the GUI tree  
=> select "General Object Automation" to start the GOA Wizard 
... 
=> apply the filter used in the user view 
...
=> Choose to submit a job to print the report from the GOA script, 
or choose sending an email e.g. with message text: 
BCS filter mastercat 
-------------------- 
//*REPEAT* 
Catalog=%%CATNAVN%%  DSN=%%CATDSN%% 
//*REPEATEND*  

...
=> at the end, "save, activate and execute the script"