How to delete unused files from MICS

Document ID : KB000011810
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

What is the recommended process to remove existing file instances from the MICS database after files are turned off?

Answer:

Use the CA MICS Resource Management health check utility to remove existing file instances from the database after files are turned off.

For more information, see Database Health Check Utility.

In cases where files were turned off in the past but never deleted from the MICS database, this may result in processing failures if the file is turned back on. 

Using the DB2 Analyzer as an example, DAY065 may fail with the following error 

BY VARIABLES ARE NOT PROPERLY SORTED ON DATA SET MONTHS.DB2DPP00

A PROC CONTENTS job can be run against the time-span and file listed in the error to determine the create and modified date of the file listed in the error message.   After confirming that the file in question is a 'dead file' the following SAS code can be used to delete the obsolete file(s). 

//S01 EXEC MICSDBx 

//SYSIN DD * 

PROC DATASETS LIB=MONTHS; 

DELETE DB2DPP00-DB2DPP02;