Previous Topic: 4.4.4.5 Database Health Check Utility

Next Topic: 4.4.4.5.2 Symptom Descriptions

4.4.4.5.1 Panel Entries

------------------------  Database Health Check  -----------------------
Command ===>


Unit Database ID          ===> P

Generate Deletes          ===> Y
   Dead Cycles            ===> Y
   Unknown Files          ===> N
   Inactive Files         ===> N

   Delete Window          ===> 120   (minutes)

   Edit Exclude List      ===> N

Press END to continue.


To generate the Database Health Check Utility, choose option
5 from the CA MICS Administrator Utilities menu (MWF 5;4;5).

Fill in values, as described below, and press END or use the
PF3 key to submit the inquiry.

Unit Database ID    Defaults to the primary database ID.
                    Specify the one-character identifier
                    assigned to the unit to analyze.  A list
                    of valid values is displayed by
                    placing a question mark (?) in the field.

Print Duplicate     Defaults to N. Specify Y to have
Formats             the Database Health Check Utility
                    generate a print of any formats that
                    exist in multiple format catalogs.

Generate Deletes    Defaults to N.  Specify Y to have the
                    Database Health Check Utility generate
                    delete control statements.  Note that the
                    prefix.MICS.CNTL(DBHDELET) job needs to
                    be run to execute the deletions.  See
                    section 4.4.4.5.4 in the PIOM for more
                    information on the Database Health Check
                    Utility Delete job.

Dead Cycles         Defaults to N.  Specify Y to have the
                    Database Health Check Utility generate
                    control statements to delete dead cycles
                    (file cycles greater than defined cycles
                    in prefix.MICS.PARMS(DBMODEL)).  Note
                    that the prefix.MICS.CNTL(DBHDELET) job
                    needs to be run to execute the deletions.


Unknown Files       Defaults to N.  Specify Y to have the
                    Database Health Check Utility generate
                    control statements to delete unknown
                    files. These are members of the SAS data
                    library that are not recognized as
                    CA MICS files, possibly because they were
                    created by the user.

Inactive Files      Defaults to N.  Specify Y to have the
                    Database Health Check Utility generate
                    control statements to delete inactive
                    files. Inactive files are defined as
                    files that have been deactivated in a
                    particular timespan or for files
                    belonging to components not active in the
                    unit

Duplicate Formats   Defaults to N.  Specify Y to have
                    the Database Health Check Utility
                    generate control statements to
                    delete formats identified as
                    duplicates.  Duplicate formats are
                    defined as a format with the same
                    name and entrytype as one which
                    resides in another format catalog.
                    This can be at the complex (MCOLIB)
                    and/or unit (MUOLIB) catalog level
                    and includes the USERFMT1, MICSFMTS
                    and USERFMT2 catalogs.

                    Note:  The Database Health Check
                    Utility does not generate control
                    statements for the delete utility
                    (DBHDELET) for formats that reside
                    in the MICSFMTS format catalog(s).
                    It will only generate control
                    statements for the USERFMT1 and
                    USERFMT2 format catalogs.  This is
                    intended as a precaution to avoid
                    inadvertent loss of a CA MICS
                    format.

Delete Window       Defaults to 120. Specifies the amount of
                    time in minutes that
                    prefix.MICS.CNTL(DBHDELET) can run after
                    the Database Health Check Utility has
                    completed.  After this window,
                    prefix.MICS.CNTL(DBHDELET) will no longer
                    act on generated control statements.

Edit Exclude List   Defaults to N.  Changing this value to Y
                    activates an ISPF Edit session to modify
                    the exclude list. See section 4.4.4.5.5
                    in the PIOM for more information on the
                    exclude list.