Verifying recoverability and integrity using the dashboard view (PTF BQU2204 applied)


Use the Recovery Management dashboard view to validate the recoverability of an object set. The dashboard view also reports on the integrity issues of an object set. For example, the report identifies specific data sets that do not have available copies. You should use the dashboard view as part of your routine disaster recovery preparations.

To verify recoverability and integrity of an object set

  1. In the Recovery Management perspective, click the Add View NW_plus_circle_o.png menu arrow, and then select Add Dashboard view.
  2. In the Definition tab, complete the following fields:

    Field

    Action

    Report Name

    Enter a name for the report.

    Categories

    Select one or more options from the following list:

    Category

    Description

    Unrecoverable Events

    For each object in the object set, the product checks for unrecoverable events:

    • Between the specified recovery point and the current time for backout recovery
    • Between the specified image copy type to the recovery point

    Archive Logs

    For each object in the object set, the product verifies that the required archive log exist:

    • Between the specified recovery point and the current time for backout recovery.
    • Between the specified image copy type to the recovery point

    Image Copies

    For each object in the object set, the product verifies that an image copy has been made within the specified number of hours or days for the specified copy type.

    Changed Objects

    The product checks each object in the object set for a log range between the specified recovery point and the current time.

    Encrypted Objects

    The product checks table space in the object set for encryption.

    Exception Status

    The product checks each object in the object set for an exception status.

    DB2 Connection

    Select a connection from your list of favorites. If necessary, you can add a connection. See Connecting-to-DB2-subsystems.

    Object Set

    Navigate to and select an object set.

    Recovery Point

    Enter a timestamp when checking for changed objects, checking for unrecoverable events, and verifying required archive logs.

    Image copies taken within

    Enter the number of hours or days to check that an image copy was taken within the specified interval for the specified copy type.

    Copy Type

    Select a copy type from the following list when verifying required archive logs and verifying image copies:

    • Local Primary (default)
    • Local Backup
    • Remote Primary
    • Remote Backup
    • Flash Copy

    Rebuild Indexes

    Specify whether indexes in the object set are being rebuilt or recovered. This option affects the output for checking for unrecoverable events, verifying required archive logs, and verifying image copies.

  3. Click Generate Report NW_run.png.
    The Summary tab is displayed. This tab lists the analysis results for the selected categories.
    RM_Dashboard_RecoverIntegrity_ptf_bqu2204.png

    #

    Description

    Details

    1

    Run button

    Executes the report

    2

    Status Icon

    Indicates the results of the checks for the category. The following icons can be displayed:

    Icon

    Description

    NW_check_circle_green.png

    Recoverability of the object set is verified. No action is required.

    NW_exclamation_triangle_orange.png

    Found one or more issues that could prevent recovery of the object set. Further investigation is required.

    NW_info_circle_teal.png

    Information about the integrity and state of the object set. Further investigation may be required. For example, if your site requires the object set to be encrypted, the list of unencrypted objects is displayed.

    3

    Summary Text

    A summary count of objects based on the category

    For example, for Archive Logs, the count of missing archives and missing copies is displayed.

    4

    View Details button

    Displays a list of the objects affected for the category

    For example, for Archive Logs, a list of objects with missing archives and missing copies is displayed.

    5

    Recovery Manager options

    Displays the Recovery Manager options See Setting-Recovery-Management-options.

    1. On the Summary tab, click Details in one of the result summaries displayed.
      The Details tab is displayed. The tab lists the exceptions in the selected category.
      RM_Dashboard_RecoverIntegrity_Details_ptf_bqu2204.png

      #

      Description

      Details

      1

      Run button

      Executes the report

      2

      Category list

      Selects the next category to view

      3

      Next and Previous Category

      Displays the next or previous category

      4

      Object exceptions

      Lists the excepted objects and lists a reason for the exception

      5

      Recovery Manager options

      Displays the Recovery Manager options For more information, see Setting-Recovery-Management-options

  4. On the Details tab, click Next Category NW_arrow_down_circle.png or Previous Category NW_arrow_up_circle.png to view the detailed results for another category. 


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Workbench for DB2 12.1