RMUDISPLAY72.HLB  —  Overview  Screens  Recovery Analysis Screen
    This screen provides information about process failure recovery
    performance.

    The following information is examined:

    o  Ratio of DBR invocation to database attach

    o  Date and time of the last full database backup

    Information in the Recovery Analysis screen is displayed only if
    it exceeds established threshold values or normal expectations.
    Note that the items identified in this screen are not necessarily
    indications of performance problems. The items may be an
    indication of a performance problem, but in most cases, further
    research is necessary.

    The Recovery Analysis screen has a configuration submenu that
    allows you to set thresholds for the following:

    o  DBR invocation threshold

       The default threshold is 15. You can override the default
       value with the RDM$BIND_STATS_DBR_RATIO logical name.

    o  DBR recovery duration

    o  Full database backup threshold

       The default threshold is 6. You can override the default value
       with the RDM$BIND_STATS_FULL_BACKUP_INTRVL logical name.

    Note that the Online Analysis facility uses the actual database
    parameters and attributes specified using interactive SQL. The
    Online Analysis facility does not use the Dashboard facility
    because the Database Dashboard attributes are temporary settings.
    Therefore, online changes made using the Dashboard facility are
    not reflected in the analysis output. Yet, using the Dashboard
    facility is the recommended method for testing potential database
    attribute settings. You must use interactive SQL in order to make
    the attribute settings persistent.

    Also note that the Online Analysis facility is invoked at the
    designated screen refresh interval. As the Online Analysis
    facility is fairly CPU intensive, and the analysis results seldom
    vary greatly over a miniscule period of time, it is recommended
    that the screen refresh interval be set to 3 seconds or more.

    The Recovery Analysis screen is not recorded in the binary output
    file produced using the Output qualifier. Consequently, this
    screen is not available when you replay a binary file using the
    Input qualifier.
Close Help