How to delete unused files from MICS
search cancel

How to delete unused files from MICS

book

Article ID: 11810

calendar_today

Updated On:

Products

MICS Resource Management

Issue/Introduction

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

Environment

Release: All MICS Releases
 

Resolution

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;