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

Document ID : KB000105633
Last Modified Date : 06/07/2018
Show Technical Document Details
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. 
Question:
How to create a report on data sets that should not be in the Master Catalog?
Answer:
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"