4. Operation › 4.4 Administering CA MICS › 4.4.4 CA MICS Administrator Utilities › 4.4.4.5 Database Health Check Utility › 4.4.4.5.4 Database Delete (DBHDELET)

4.4.4.5.4 Database Delete (DBHDELET)

The Database Health Check Utility provides options to delete
files in the CA MICS database that have been identified as
"dead cycles," "unknown," or "inactive" as well as the
option to delete "duplicate formats."

To delete these files or formats identified by the Database
Health Check Utility, perform the following:

Submit 'prefix.MICS.CNTL(DBHDELET)'

After the job completes, check the output to ensure that the
job completed successfully.  Review the MICSLOG output file
for any error messages.

Note: DBHDELET MUST run within the Delete Window specified at
the time the CA MICS Database Health Check utility was run.
NO changes should be made to the database after the Database
Health Check Utility is run and before the DBHDELET is run.
If either of the above conditions exists, DBHDELET will abend
with a U0998 error.

The LIST option allows DBHDELET to produce all reports but
will not physically delete files. This mode can be used in
conjunction with the exclude list to review exactly which
files will be deleted.

LIST is specified on the SYSPARM keyword of the EXEC
statement of the DBHDELET job before submission.  For
example:


// ... JOB ...
//DBHDELET EXEC MICSDBx,SYSPARM='LIST'
// ....


A sample report listing for the deleted files follows:

                                                  CA MICS Database Health Check               10:50 Tuesday, September 20, yyyy
                                                          Delete Report
 
                                                        LIBNAME     MEMBER
                                                       --------    --------
 
                                                        DETAIL     BATJOB99
                                                        DETAIL     BATSFA04
                                                        DETAIL     HARCPU10