Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Estimating recovery time

BMC AMI Command Center

 lets you run a Recovery Time Estimation report for an object set. The report shows which recovery strategies are applicable and shows recovery time estimations for (if applicable) backout, forward, and backout auto. The report also shows whether the recovery time estimations fall within the Recovery Time Objective (RTO) that you defined.

To view a Recovery Time Estimation report

New console
  1. In the Recovery Management perspective, click the Add View NW_plus_circle_o.png  menu arrow and select Time Estimation report.
  2. Click Recovery Estimation.

  3.  In the General section, complete the following fields:

     

    Field

    Description

    Report Name

    Enter a name for the report.

    RTO Target

    Accept the default value or enter the maximum acceptable Recovery Time Objective (hh:mm) for this report.

    To define the default value, see Setting-Recovery-Management-options.

    DB2 Connection

    Select a Db2 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.

  4. Click Recovery.

  5.  In the Recovery section, accept the default values or enter new values:

     

    Field

    Description

    Recovery point

    Accept the current date and time, or enter values.

    Number of Jobs

    Specify the number of jobs in the recovery run. Valid values are 1 (the default) though 99.

    Number of IO Paths (SPE2010)

    If MAXLSORT (tasks) is multiplied by the number of jobs and exceeds the number of IO paths, MAXLSORT is set to the number of IO paths for the calculation.

    Valid values are 1 through 99. The default is 20.

    MAXLSORT

    Specify the maximum number of log sorts that can run concurrently. Valid values are 1 (the default) through 32.

    Include Indexes

    Select to include indexes in the backup estimation if they are not already in the object set.

    Rebuild Indexes

    Select to rebuild indexes in the recovery estimation.

    Scope Changed

    (SPE2010)

    Select to include only objects that were changed since the specified recovery point.

    Select one of the IO factor options:

    Select an option:

    • Use a Specific IO Factor: Enter a valid value or accept the displayed value. Valid values are 1 through 10000, and the default is 100. A factor of 0 will calculate a new factor estimate.
    • Calculate IO Factor: Enter the name of a DASD unit, or use SYSALLDA as the default DASD unit. BMC AMI Command Center calculates and uses an IO value based on this DASD unit.
  6. Click Growth.

  7.  In the Growth section, accept the default values or enter new values:

     

    Field

    Description

    Number of data sets increased by

    Enter a percentage or number increase to generate a What-If recovery estimation based on an increase in the number of data sets. Valid values are 0 through 32767.

    Size of data sets increased by

    Enter a percentage or number increase to generate a What-If recovery estimation based on an increase in the size of the data sets. Valid values are 0 through 32767.

  8. Click Generate Report NW_run.png.The Time Estimation report tab is displayed.

     

    RecoveryReportRecovery_bqu1804.png

     

    #

    Description

    Details

    1

    Run button

    Executes the report.

    2

    Tabs

    Categorizes the information as follows:

    • Definition (see Step 3)
    • Recovery Estimation
    • Details

    3

    Actual data

    Indicates the actual number of objects in your selected group, their actual size, and the applicable I/O factor

    4

    Projected data

    Projects what the number and size of objects would be, based on the What-If percentage or number changes that you entered in the Growth section (see   Step 7)

    5

    Recovery Manager options

    Displays the Recovery Manager options

    See Setting-Recovery-Management-options.

    6

    View Details button

    List the objects.

    7

    Backout recovery time estimate

    Shows either the time estimate for the backout recovery strategy or a message indicating why this strategy cannot be executed.

    You can click View Details to view the list of problematic objects.

    8

    Forward

    Shows either the time estimate for the forward recovery strategy or a message indicating why this strategy cannot be executed.

    9

    Backout Auto

    Estimates the time needed for the backout auto recovery strategy

    10

    RTO indicator

    Indicates whether the recovery time estimation falls within the Recovery Time Objective (RTO) that you have defined for this report:

    NW_check_circle_green.png indicates that the time is within your defined RTO.

    NW_exclamation_triangle_orange.png indicates that the time exceeds your RTO.

    Note: No indicator is displayed if the strategy cannot be executed.

Classic console
  1. In the Recovery Management perspective, click Add View Add-16.png and select Time Estimation report from the list.The Generate Time Estimation wizard opens.

  2.  On the wizard's Step1 - General page, complete the following fields, and click Next.

     

    Field

    Description

    Name

    Enter a name for the report.

    Estimate Recovery Time

    Select Estimate Recovery Time.

    RTO Target

    Accept the default value or enter the maximum acceptable Recovery Time Objective (hh:mm) for this report.

    To define the default value, see Setting-Recovery-Management-options.

    DB2 Connection

    Select a Db2 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.

  3.  On the wizard's Step 2 - Recovery page, accept the default values or enter new values and click Next:

     

    Field

    Description

    Recovery point

    Accept the current date and time, or enter values.

    Number of Jobs

    Specify the number of jobs in the recovery run. Valid values are 1 (the default) though 99.

    MAXLSORT

    Specify the maximum number of log sorts that can run concurrently. Valid values are 1 (the default) through 32.

    Rebuild Indexes

    Select to rebuild indexes in the recovery estimation.

    Include Indexes

    Select to include indexes in the backup estimation if they are not already in the object set.

    Select one of the IO factor options:

    Select an option:

    • Use a Specific IO Factor: Enter a valid value or accept the displayed value. Valid values are 1 through 10000, and the default is 100. A factor of 0 will calculate a new factor estimate.
    • Calculate IO Factor: Enter the name of a DASD unit, or use SYSALLDA as the default DASD unit. BMC AMI Command Center calculates and uses an IO value based on this DASD unit.

  4.  On the wizard's Step 3 - Growth page, accept the default values or enter new values:

     

    Field

    Description

    Number of data sets increased by

    Enter a percentage or number increase to generate a What-If recovery estimation based on an increase in the number of data sets. Valid values are 0 through 32767.

    Size of data sets increased by

    Enter a percentage or number increase to generate a What-If recovery estimation based on an increase in the size of the data sets. Valid values are 0 through 32767.

  5. Click Finish.The General, Recovery, and Growth tabs are populated with your input, and the Time Estimation report tab is displayed.

     

    g_gud_RecoveryReportRecovery_low.png

     

    #

    Description

    Details

    1

    Run button

    Executes the report.

    2

    Tabs

    Categorizes the information as follows:

    3

    Actual data

    Indicates the actual number of objects in your selected group, their actual size, and the applicable I/O factor

    4

    Projected data

    Projects what the number and size of objects would be, based on the What-If percentage or number changes that you entered in the Growth tab (see   Step 4)

    5

    Recovery Manager options

    Displays the Recovery Manager options

    See Setting-Recovery-Management-options.

    6

    View Details button

    List the objects.

    7

    Backout recovery time estimate

    Shows either the time estimate for the backout recovery strategy or a message indicating why this strategy cannot be executed.

    You can click View Details to view the list of problematic objects.

    8

    Forward

    Shows either the time estimate for the forward recovery strategy or a message indicating why this strategy cannot be executed.

    9

    Backout Auto

    Estimates the time needed for the backout auto recovery strategy

    10

    RTO indicator

    Indicates whether the recovery time estimation falls within the Recovery Time Objective (RTO) that you have defined for this report:

    g_gud_Check_16.png indicates that the time is within your defined RTO.

    status_warning.png indicates that the time exceeds your RTO.

    Note: No indicator is displayed if the strategy cannot be executed.


 

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